Hello all,
I have a workbook containing 15 VBA modules and wish to copy them into multiple other workbooks with a particular naming convention (contain "TSP" in their name, do not contain "blank template" in their name). I am aware you can drag and drop modules while in Visual Basic, however as I currently have approximately 75 destination workbooks, I was hoping there was a way to automate this process.
Any help would be appreciated; FYI I have a method of looping through the files that meet the naming convention, more interested in how to copy Modules to other workbooks via a macro
I have a workbook containing 15 VBA modules and wish to copy them into multiple other workbooks with a particular naming convention (contain "TSP" in their name, do not contain "blank template" in their name). I am aware you can drag and drop modules while in Visual Basic, however as I currently have approximately 75 destination workbooks, I was hoping there was a way to automate this process.
Any help would be appreciated; FYI I have a method of looping through the files that meet the naming convention, more interested in how to copy Modules to other workbooks via a macro