| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A macro code to print multiple sheets in different w.books | Excel Discussion (Misc queries) | |||
| Macro 4 copy & paste between 2 books/files | Excel Discussion (Misc queries) | |||
| Create a macro which can find a record in three books | Excel Worksheet Functions | |||
| compare books macro | Excel Programming | |||
| Put copy/paste between books in macro | Excel Programming | |||
Linear Mode
