Thread
:
Copy VBA Module to new workbook
View Single Post
#
3
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
Copy VBA Module to new workbook
Create a template file with the code, layouts etc already in-situ. Then
when creating a new workbook use the template.
--
Regards,
Nigel
"Mark" wrote in message
...
I have a script that I run the formats a bunch of data and copies 5 sheets
and puts them in a new work book. I want to add an autorun module to this
new book. I'm not sure if it is easier to add the module from scratch or
copy it, but I want the module to be there when the other code I have
saves
the new work book.
Can anyone offer any suggestions?
thanks!
Mark
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]