Saving sheets as their own workbooks?

N

notDave

I get an xls file with about 25 sheets in it. I have to save each sheet
using the sheet name in the filename, along with the date. For example, one
sheet name I got today was "720 Log", and I copied it to its own workbook,
and saved it as "20060203_720_Log.xls" Then I repeat those steps for the
other 25 sheets I get! Woohoo! Can anyone offer any suggestions as to how I
might automate this task? I should mention that the date isn't today's date,
I would need to specify each time I ran this process what date to use.

If anyone can guide me in the right direction for learning how to set up
such a process that would be wonderful.

~notDave
 

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

VBA - exporting serial letters to single documents 0
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
Emailing a sheet from a workbook with VBA 0
Unprotect sheet when Saving As 2
Export Sheet Values to new workbook 20
using two cell references to make up the save as file name 3
MACRO to save current worksheet with variable filename 1
Copy two sheets from workbook & create new workbook 8

Top