ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   copying macro to multiple excel files (https://www.excelbanter.com/excel-programming/406157-copying-macro-multiple-excel-files.html)

[email protected]

copying macro to multiple excel files
 
Hello,

I need to copy a Macro to multiple excel file.
Is there a way to do this without the need to open every file
individually and doing the work manually?

Thanks
Ori

Mark Ivey[_2_]

copying macro to multiple excel files
 
If you will be running the macro from one machine, you might consider
putting it into your personal.xls file.

If this is not the case, you could export the module and import it into your
other files as needed.

Otherwise, you could look over this site and see if it may give you some
other ideas...

http://puremis.net/excel/code/004.shtml

Mark Ivey




wrote in message
...
Hello,

I need to copy a Macro to multiple excel file.
Is there a way to do this without the need to open every file
individually and doing the work manually?

Thanks
Ori




All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com