soteman2005
New Member
- Joined
- Nov 24, 2005
- Messages
- 32
Hi,
I would like to open a workbook whose name is defined in named range "Welcome_Overrides_Factbase_Selected_Name" in a workbook called "Test1_Adam_20_12_05_2", then copy 4 sheets, ("sheet1","sheet2","sheet3","sheet4") from the just opened workbook to "Test1", replacing sheets ("sheet1","sheet2","sheet3","sheet4") , which already exist in the workbook. Then close the initially open workbook.
Is this possible, and could I save the new workbook with a name that takes the original workbooks name, except the Test1 part i.e. "Test2_Adam_20_12_05_2"?
I am quite stuck on this one so any help would be greatly appreciated.
Thanks
Adam
I would like to open a workbook whose name is defined in named range "Welcome_Overrides_Factbase_Selected_Name" in a workbook called "Test1_Adam_20_12_05_2", then copy 4 sheets, ("sheet1","sheet2","sheet3","sheet4") from the just opened workbook to "Test1", replacing sheets ("sheet1","sheet2","sheet3","sheet4") , which already exist in the workbook. Then close the initially open workbook.
Is this possible, and could I save the new workbook with a name that takes the original workbooks name, except the Test1 part i.e. "Test2_Adam_20_12_05_2"?
I am quite stuck on this one so any help would be greatly appreciated.
Thanks
Adam