create workbook, copy sheets

  • Thread starter Pierre via OfficeKB.com
  • Start date
P

Pierre via OfficeKB.com

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top