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