Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Worksheet to a new Workbook creating if it doesn't exist and add more Worksheets if it does exist
Help Please with VBA
I would like to copy a worksheet from an active workbook creating a new workbook if it does not exist. If it exists just to add the worksheet to it. Also need it to overwrite a sheet with the same name. I am using code to save the sheet by cell references and can get as far as saving to a new workbook, but cannot get to add a sheet, only to overwrite the file. Sounded so simply when i started!! All help greatly appreciated. Regards and Thanks Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
does a value exist in another workbook | Excel Worksheet Functions | |||
Does worksheet exist | Excel Discussion (Misc queries) | |||
Does a worksheet exist? | Excel Programming | |||
Command Line. How to tell to XL : If the xls file exist : Open it, if it does not exist : Create it. | Excel Programming | |||
Does worksheet exist | Excel Programming |