Opening an External Program with access vba

[maXim]

Hello i have to open an external program.but the problem is that i dont have
to open the executable itself. i have shape files and using arcview explorer
to view it. i m using the following command


Dim stAppName As String

stAppName = "C:\ESRI\ESRIDATA\visionpakistan.apr"
Call Shell(stAppName, 1)

but when i run this command an error occurs "invalid procedure call or
argument".
i put this file in command prompt and then run it the file succesfully
opened in its program.
any idea??

 

[Roger Carlson]

The Shell function requires an executable program (.exe, .bat, and so forth)
as an argument. Apparently, there is an application associated with the
..APR extention, so you should be able to use that. Something like:

stAppName = "C:\Program Files\ESRI\ESRI.exe
C:\ESRI\ESRIDATA\visionpakistan.apr"

This assumes the program is called ESRI.exe and is in the Program Files
folder.


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Albert D. Kallal]

just use:

application.FollowHyperlink "C:\ESRI\ESRIDATA\visionpakistan.apr"

The above will open the file based on its extension (pdf, word,
execl...etc...will ALL work).

You don't need the path to the executable part...

 

[Roger Carlson]

Good tip, Albert. Always learning something new...

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[maXim]

Application.fllowhyperlink works fine. but still there is a little problem. a
pop appears, which says
"
Openinig c:\....
Some Files can Contain Viruses or otherwise be harmful to your computer. It
is import..........
would you like to open this file?
ok/Cancel"
can you please tell me how to disable this dialog box. i tried to use
setwarnings= false. but its not working here

 

[Albert D. Kallal]

I thought if you set macro security to low, you would not receive this
prompt.....

If not, you could try the winapi shell here:

http://www.mvps.org/access/api/api0018.htm