Macro in different books

V

VL

Hi,
this might be simple.
I would like to run a macro in one workbook that transfers
data between to other workbooks. My problem is that the
names of these two books gets recorded. Is there a way to
make the macro run using books having different names each
time?
Thanx!
 
P

Peter Atherton

Hello

Save the workbook as Start and this will open each time
you use Excel. Then the macro will be available to other
workbooks that are opened.

Regards
Peter
 
T

Tom Ogilvy

How would you communicate to the macro the names of the workbooks.

Regards,
Tom Ogilvy
 
Top