View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rich_z[_6_] Rich_z[_6_] is offline
external usenet poster
 
Posts: 1
Default Accessing multiple workbooks through a macro


The easiest way to see how to do things is to use the macro recorder.
This will generate a macro for you with all the relevant properties and
methods.

You can then use this as a base to write fully functional code that
accepts parameters and all the other bells and whistles you can put in
yourself (A good bookm on VBA would help).

To access the recorder, use -Tools-Macro-Record New Macro-. To
access the Vb editor to see the monster you've created use
-Tools-Macro-VB Editor-.

Regards

Rich


--
Rich_z
------------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php...o&userid=24737
View this thread: http://www.excelforum.com/showthread...hreadid=383159