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?
=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?