date to filename

J

jim

I am trying to append the date to a file name during an macro export. I get
an eror that says there is not enough free space to create a temp file??
There is plenty of space on the drive for the file. The file is 67K when I
run it manually. Need help, thanks.

I have the following code in the macro detail for the output file:
"c:\cost reports\Program Cost" & Format(Date(),"mmddyy") & ".snp"
 
Top