View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter Atherton Peter Atherton is offline
external usenet poster
 
Posts: 31
Default 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!
.