Save file with last month date on end
Thanks Mike
--
Les
"Mike H" wrote:
Les,
Try this
fname = "myfile_" & DateSerial(Year(Date), Month(Date) + 1, 0)
Mike
"Les" wrote:
Hi all, i am wanting to save a file "myFile.xls" as "myFile_Apr-08.xls".
It must always be the last month to present date.
Any help would be much appreciated.
--
Les
|