Auto saving sheets from a workbook as separate files.

C

Colin Hayes

Hi

I need some help with some VBA code.

My workbook has 50 sheets. Numbered 1 - 50.

I'd like to have a macro save each sheet as a separate file to a path
and in a format specified by response to a popup.

Can someone assist with this?

Grateful for any help.
 

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

Save all sheets in a new workbook 7
Auto filling separate sheets in a workbook 2
Merge Multiple workbook sheets into one workbook 0
Reducing numbers by one in defined areas over several sheets 12
macro to sum select columns in all workseets within a workbook 2
Copying Worksheets From Different Workbooks using Marco 4
How do I save a page in a workbook as a separate file? 4
Collapsing all groups 0

Top