Thread: create workbook, copy sheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre via OfficeKB.com[_2_] Pierre via OfficeKB.com[_2_] is offline
external usenet poster
  
Posts: 122
Default 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 With QuoteReply With Quote