john3j
04-09-2010, 12:36 PM
Hello,
I was wondering if someone could help me come up with code to copy all of the sheets in a workbook to a new workbook and then save it as a specific file. I need to copy the sheets to a new workbook because I have datasources and code in the original that other users should not be able to see or given the chance to break. Lets say there is a workbook called Test1 where I will be copying the sheets from. I want copy all of the worksheets from Test1 into a new workbook. I would then like it to save the new workbook as Test2 in the specified folder of My Documents. I just dont want users to be able to screw this up. Any help is greatly appreciated.
Thanks,
John: pray2:
I was wondering if someone could help me come up with code to copy all of the sheets in a workbook to a new workbook and then save it as a specific file. I need to copy the sheets to a new workbook because I have datasources and code in the original that other users should not be able to see or given the chance to break. Lets say there is a workbook called Test1 where I will be copying the sheets from. I want copy all of the worksheets from Test1 into a new workbook. I would then like it to save the new workbook as Test2 in the specified folder of My Documents. I just dont want users to be able to screw this up. Any help is greatly appreciated.
Thanks,
John: pray2: