Macro in different books

  • Thread starter Thread starter VL
  • Start date Start date
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!
 
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
 
How would you communicate to the macro the names of the workbooks.

Regards,
Tom Ogilvy
 
Back
Top