excel macro from mac to windows

[Lars50]

I am converting a macro from mac to windows. I am having trouble with the following command
=SAVE.AS(TEXT(!C3,"m/d/yy"))
this command saves the current document with the date in cell C1

I get the following error message
"cannot access the file 'C:\new folder\4/14' " (4/14 being the date in C1)
I am not sure why it is refering to a new folder I think my problem might be in some type of file directory info I am missing?

the following is a little more of the command lines leading up to the problem


=ACTIVATE("Daily Summary")
=SAVE()
=SAVE.AS(TEXT(!C3,"m/d/yy"))

Any Suggestions?

 

[Aftab]

First try removing the forward slash (/) from the filename, use a hyphen (-) instead. Windows thinks the slash is a directory separator.