Ray,

Activeworkbook.SaveAs FileName:= "myFile" & Format(NOW,"dd mmm yyy
hh:mm:ss") & ".xls"



--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks


"Ray Morton" wrote in message
...
I am converting .csv data files from a SCADA system for
historical data. Once the .csv files have been converted,
I have created and run a macro that sorts out all of the
information and averages things out with nice and neat
formatting. I would like to help my work mates out and
speed things up by adding a "save as" function withing the
macro. My question for all of you is, is there a way
possible to save a timestamp of the day so that you don't
have to manually type in the date and change the name
after the macro has already saved it as a .xls file?

Anything suggestions would be greatly appreciated!!!

Ray Morton
Springfield, Oregon