excel macro from mac to windows

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Lars50

Thread Starter
Joined
Apr 19, 2004
Messages
1
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?
 
Joined
Oct 15, 2003
Messages
72
First try removing the forward slash (/) from the filename, use a hyphen (-) instead. Windows thinks the slash is a directory separator.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top