> Maybe you need to learn VBA, but the problem I find is that the help files
> are almost useless, and finding the functions names and definitions is an
> exercise in futility. What I tend to do is turn on the macro recorder,
> then
> carry out the operation I want, turn off the macro recorder, and then look
> at the VBA it recorded. Modify as I feel fit and try it.
>
>>"real time" I've never even considered doing with Excel/VBA.
>
> Have a spreadsheet written by a colleague, where LabView writes to the
> spreadsheet data that is obtained in the process of calibration. The graph
> is updated in real time, so I can set the calibration process running, and
> switch to the graph, and watch it change. This spreadsheet uses no VBA,
> but
> there is no reason that using VBA to update values would not allow the
> same
> to happen.


Real time update with no VBA?  How's does that work?  Labview opens &
controls the spreadsheet?

MS help has been getting steadily worse over the years, although the MSDN
website occasionally has useful things.  Because XL has such a big object
model, using the macro recorder is often the only way you can figure out
what's going on.  The code generated tends to be a bit horrible, but it
points you in the right direction.  eg, Who would think that comments are
just a type of shape?

I wish Outlook had a macro recorder.

Tony

-- 
http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist