| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
running the same macro for different Excel workbooks
I'm using Excel 2007. I'm collecting reports from different persons, using an
Excel template, and I'm storing them in a shared directory. I'd like to record a macro that is supposed to perform the same set of operations on different files with the same structure and I do not want this macro to be stored in each file, because it is difficult to update and I don't want it to personalized, i.e. it should be available for different users, operating from different workstations. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
running the same macro for different Excel workbooks
Create an Add-In and distribut the Add-In
-- Gary''s Student - gsnu200908 "Petre" wrote: I'm using Excel 2007. I'm collecting reports from different persons, using an Excel template, and I'm storing them in a shared directory. I'd like to record a macro that is supposed to perform the same set of operations on different files with the same structure and I do not want this macro to be stored in each file, because it is difficult to update and I don't want it to personalized, i.e. it should be available for different users, operating from different workstations. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Close all workbooks and keep excel running | Excel Discussion (Misc queries) | |||
| Update links to other workbooks while running macro | Excel Programming | |||
| Running the same macro to multiple workbooks | Excel Programming | |||
| Keeping an Array Filled and running macro from other workbooks? | Excel Programming | |||
| Workbooks in multiple running Excel applications | Excel Programming | |||
Linear Mode
