>On Mon, 4 Jul 2005, John Pearson wrote:
>> I need to do some macros in Excel. Am I correct in assuming that I
>> should learn VBA to do this?
>
>Yes, if you have any recent version of Excel

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.

>Sometimes the microsoft.public.excel.programming newsgroup can
>be of assistance, either searching old postings or when that
>doesn't work asking new questions.

This was where I went to learn most of my Excel VBA snippets. The MVP folk
there were most helpful. Here is a list of credits that I put in one of my
spreadsheets, after getting help from them.


      Steve Bullen http://www.bmsltd.co.uk/Excel/
      Dave McRitchie http://www.mvps.org/dmcritchie/excel/excel.htm
      John Walkenbach  http://www.j-walk.com/ss/excel/index.htm
      Chip Pearson http://www.cpearson.com/
      Tushar Mehta http://www.tushar-mehta.com/
      Microsoft MVP's http://www.mvps.org/
      Woody's Watch http://woodyswatch.com/

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