Macro Actions need HELP

[alienscript]

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 !

 

[FoFa]

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

Seems to be incorrect syntax, at least on a Microsoft network.
You used the same syntax in your runapp statement.

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

Seems to be a proper UNC, is the Planning folder a shared folder?
Is Amat-asia-ams1 the proper server name?
I use UNC's all the time in transfer text, but you have to have the proper permissions.
What error are you getting?