JamieDuncan
Board Regular
- Joined
- Aug 23, 2006
- Messages
- 132
Ok this is a bit of a challenge this one, im trying to write a macro that when run;
1. Opens an existing workbook
2. Lets the newly opened book run its workbook_open macros
3. then copies a sheet from the original workbook into the newly opened one(sheets will have the same name)
4. Closes the original workbook
but wait theres a twist,
the macros in the second workbooks open event create a new workbook with filename entered into an inputbox, so the macro in the first workbook would need to copy the sheet to this newly created workbook.
help on this would be much appreciated
1. Opens an existing workbook
2. Lets the newly opened book run its workbook_open macros
3. then copies a sheet from the original workbook into the newly opened one(sheets will have the same name)
4. Closes the original workbook
but wait theres a twist,
the macros in the second workbooks open event create a new workbook with filename entered into an inputbox, so the macro in the first workbook would need to copy the sheet to this newly created workbook.
help on this would be much appreciated