Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving sheets to another workbook
Hi!
I have a source workbook which creates 25 to 30 worksheets, each one's name ends with "P1" I want to move these sheets to an existing destination workbook, through a vba sub residing in the source workbook BUT : if one or the source worksheet exists in the destination workbook, it should be replaced by the new one I've tried to code that, but Excel generates an error and closes. Any idea for coding that ? Thanks by advance, Herve+ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
moving data between workbook sheets | Excel Discussion (Misc queries) | |||
Moving Sheets within a workbook | Excel Worksheet Functions | |||
Moving Macros with Sheets to New Workbook | Excel Programming | |||
Moving a variable number of Sheets to another Workbook | Excel Programming |