Macro in different books
 

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!

Macro in different books
 

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
-----Original Message-----
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!
.

Macro in different books
 

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

Regards,
Tom Ogilvy

"VL" wrote in message
...
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!