How do you copy saved excel sheets to a new workbook

  • Thread starter Thread starter chrisnsmith
  • Start date Start date
C

chrisnsmith

I'm using Ron De Bruin's code to copy worksheets to a folder. How can I copy
these
sheets to a new workbook?
 
I'm using Ron De Bruin's code to copy worksheets to a folder.  How can I copy
these
sheets to a new workbook?
Click to expand...

A simple way could be to copy the file, name it and then delete the
extra sheets you don't need.
 
You can't save just a sheet to a folder so you must be mis-interpreting the
function of Ron's code.

His code probably copies one sheet from a workbook to a new workbook before
saving to a folder.

Post the URL for the code from Ron's site.


Gord Dibben MS Excel MVP
 

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

Similar Threads

exporting modules with created workbook 4
Merge Multiple workbook sheets into one workbook 0
VBA Copy values only onto new workbook 1
Excel Move or Copy Stopped Working? 0
Macro Assistance (Splitting into new workbook by value) 4
Excel 2003 VBA problem - extracting and emailing worksheets 2
problems getting this macro to work 23
Formatting problem copying sheet 3

Back
Top