Saving sheets as their own workbooks?

[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

[Ron de Bruin]

Hi notDave

http://www.rondebruin.nl/copy6.htm

You can add the date time (DateString ) in the file name also


--
Regards Ron de Bruin
http://www.rondebruin.nl


"notDave" <notDave@discussions.microsoft.com> wrote in message news:C2A83D0B-63DF-497E-8E68-137D78558B0D@microsoft.com...
>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