send message/open url steps on server

[carsarecoffins]

I am trying to open a Microsoft Excel Template on our server using a script. The script sorts the records and exports them to a .mer file. The scrip then uses the send message step to open a Microsoft Excel template, which contains a macro to import the data from the .mer file. If I run FileMaker on my machine with the template and .mer file also local the script works beautifully. However when I place the files on our server the script does not find the template file. If I change the send message step from either machine on the network the script will find the file from only that machine (as expected).

I have also tried the open URL step with a slightly different result. It finds the file (I know this because I have a show message step at the end that executes) but does not open the file either on the client machine or on the server.

[Vaughan]

The remote volume needs to be mounted (logged-in) on the guest computer.

[carsarecoffins]

Yes of course. I mapped a network drive to the folder containing the template file and used the same drive letter on all machines and it works wonderfully. Thank You.