Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create workbook, copy sheets
Hi experts,
I would like to - create a new workbook called "vpldb" from VBA code (if the workbook does not already exist) - if the workbook already exist, i would like to replace sheet1 and sheet2 in "vpldb" with sheeta and sheetb (including all data, not linked) of my existing workbook called "vplprog". - if the workbook does not exist, i would like to create workbook "vpldb" and copy 2 sheets (sheeta and sheetb, including al data, not linked) from my current workbook into the new workbook Can anybody help me please? thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200510/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to create new workbook and sheets | Excel Discussion (Misc queries) | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How to create workbook with multiple sheets | Excel Discussion (Misc queries) | |||
Create New Workbook - Name book - 4 Sheets - Name Sheets | Excel Programming | |||
VBA to create an Array of all Sheets in workbook | Excel Programming |