1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

excel macro from mac to windows

Discussion in 'Software Development' started by Lars50, Apr 19, 2004.

Thread Status:
Not open for further replies.
  1. Lars50

    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?
     
  2. Aftab

    Aftab

    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.
     
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 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/221944

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice