export multiple sheets to multiple excel files

T

Tanya

I have a workbook with approx 30 sheets. I am trying to figure out how to
save each sheet as it's own workbook (using the name of the worksheet as the
file name) without having to go through the save as dialog box for each
tab....

Thanks for any help you can give me!
 

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

export sheets to multiple new files 3
Unhiding multiple sheets 2
Merge Multiple workbook sheets into one workbook 0
Automate sheets list 1
Unhide Multiple Sheets 2
Excel help please, Button to export data 6
PDF multiple sheets 2
PROTECT MULTIPLE SHEETS IN EXCEL WORKBOOK SIMULTANEOUSLY? 1

Top