Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004

    Unanswered: TransferText and RunApp


    I have 2 Access macro questions I hope somebody can please help me.
    Iam using Access Office XP.

    I am creating Macro Action "TransferText", and under the FileName Action Argument I typed the following LAN directory path but it doesn't work.

    G:\\Amat-asia-ams1\Planning\IPP\Monthly IPP review\Aug2004data.txt

    Because other users may "mapped" their shared directory using other Letters, so I tried even these paths but still to no avail.

    \\Amat-asia-ams1\Planning\IPP\Monthly IPP review\Aug2004data.txt

    I am creating Macro Action "RunApp" and under the Command Line Action Argument I typed the following path but it doesn't work as well.

    "C:\Program Files\Microsoft Office\Office10\excel.exe" "G:\\Amat-asia-ams1\Planning\IPP\Monthly IPP review\Aug IPPreview.xls"

    Can someone please help me?
    Thanks a bunch !

  2. #2
    Join Date
    Sep 2004
    Amat-asia-ams1 is a server name, a directory name ?
    Verify the name of the shared directory on the server....

  3. #3
    Join Date
    Feb 2004
    Chicago, IL
    If you are referencing a mapped drive, then you have too many '\'. Change

    G:\\Amat-asia-ams1\Planning\IPP\Monthly IPP review\Aug IPPreview.xls


    G:\Amat-asia-ams1\Planning\IPP\Monthly IPP review\Aug IPPreview.xls

    I would suggest finding the file using Explorer. Turn on 'Display Full Path in address bar'. Then select the G: drive and find the file. In the addess bar copy and paste the file's path, and then add the filename. You can do the same thing with the network drive. Start by browsing you network, find the computer, the file and copy what is in the address bar.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts