I am trying to use the command “@URLOpen” in a button on a form. I want it to open an Excel document when clicked.
Seems that whatever I do, the '' characters come into the explorer as “/” instead of "" which I think is why it is not working.
When I manually paste the following into explorer, it works fine: \Wtors001\Dat
But when the button does it with the @URLOpen, it comes in as “//Wtors001/Dat”
I’ve tried putting the '' characters fwd, backward and in single and double (ex: // or \) but nothing seems to work.
It also seems that the “http://” messes it up. When I paste in manually without the “http://” it works, but if I leave that in, it does not work. Is there any way to supress this?
Please help!
Subject: @URLOpen Problem - Please Help!
If you are trying to open an application you may want to look into this @Command:
@Command( [Execute] ; application ; fileNames )
Subject: RE: @URLOpen Problem - Please Help!
Thanks for the response - but what I actually want it for this Excel doc to open through Internet Explorer.
It works fine when I specify the drive letter designation (i.e. “X:\folder\filename”). The problem is that different users can name this drive with different letters.
When I try to use the drive designation (“Wtors001\Dat\folder\filename”) it does not work.
Subject: RE: @URLOpen Problem - Please Help!
You can do that with the @Command that I mentioned. I tried it and I was able to open an excel file on a network drive in IE.
Remember you have to use “\” to get a single "" in the browser, and then you have to add one to the front as I did below.
Here is the code that I put behind a button in the client
url := “\xyz.com\data\Home\IT\myfolder\myfile.xls” ;
@Command( [Execute]; “iexplore.exe”; “\” + url )
Subject: RE: @URLOpen Problem - Please Help!
That worked perfectly! Thanks so much for taking the time to help me out 
Tim