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
 

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

Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
VB to copy a sheet to active workbook 4
Copy Sheet Into New Workbook 1
Button looses Macro setting when running Macro 1
perform the same calculation in several spreadsheets 3
Fix multiple 'assign macro' references broken due to moving sheet 1
Extracting data on multiple files from one folder 11
Trying to Learn Code to Copy Charts 2

Top