Hi All,
Sorry if this is posted somewhere else. I have a question on how to create New Excel Worksheets from a Master.
I am running a repair department at a company. I have a sheet that lists all of the units we have to repair. I have another sheet (workshop Master report) in the same workbook that I make a copy of and fill in some of the details. I have created a VBScript that allows me to save off the sheet in a new workbook. I am using the following commands:
Sheets(WSRTemp).Copy
ActiveWorkbook.SaveAs Filename:=WSRFilename &".xls", FileFormat:=xlWorkbookNormal
ActiveWorkbook.Close
The data copies fine. I am having problems trying to figure out how to copy the macros. I have created some macros that enable the repair staff update the sheets easier.
Thanks in advance.
Sorry if this is posted somewhere else. I have a question on how to create New Excel Worksheets from a Master.
I am running a repair department at a company. I have a sheet that lists all of the units we have to repair. I have another sheet (workshop Master report) in the same workbook that I make a copy of and fill in some of the details. I have created a VBScript that allows me to save off the sheet in a new workbook. I am using the following commands:
Sheets(WSRTemp).Copy
ActiveWorkbook.SaveAs Filename:=WSRFilename &".xls", FileFormat:=xlWorkbookNormal
ActiveWorkbook.Close
The data copies fine. I am having problems trying to figure out how to copy the macros. I have created some macros that enable the repair staff update the sheets easier.
Thanks in advance.