I tried typing that into visual basic editor to edit the
macro, it gives me run time error '1004' and then it sends
me to debug to code? Am I just not entering it right?

Ray
-----Original Message-----
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


.