Saving tabs into separte books

D

Darin Kramer

Hi There,

I have a single excel File with 20 sheets. I want to move each sheet to
a new book, so that I have 20 books (ie 20 Excel Files instead of one).

Is there VB out there to achieve this...?

Regards

Darin



*** Sent via Developersdex http://www.developersdex.com ***
 

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

Breaking One workbook into many Tabs 0
Merge two sheets into third sheet 0
Relative Refs 4
If sheet exists, then... 9
Command Bar - make it go away when you change sheets 5
TESTING FOR ARRAY "EMPTYNESS" OR "NULLNESS"? 3
VB to copy a sheet to active workbook 4
Copy and paste contents of one sheet into another 1

Top