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

    Unanswered: TransferText and RunApp

    Hi,

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

    First,
    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



    Second,
    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
    Posts
    161
    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
    Location
    Chicago, IL
    Posts
    1,312
    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

    To

    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
  •