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

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" wrote in message ...
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