Copying a macro to multiple docs Closed

Question

Hello,

Is there a way to copy a macro into multiple excel files at the same time without touching each file? I have a macro built and need to incorporate into 400 files, I can copy from doc to doc with opening each, but would like to copy to over 400 without opening each file. 

Thanks!

rizvisa1 · Answer

You can have macro save in an xla file. So each time excel opens, macro is available

or in a new book have some thing like this

Sub AddModule(myBook As Workbook, myModule As String)
   
        myBook.VBProject.VBComponents.Import myModule

End Sub

and define your book and module to import

Copying a macro to multiple docs

1 response

Similar discussions

Subscribe To Our Newsletter!