Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help Using the Shell Function

Status
Not open for further replies.

BobLoblaws

Programmer
Nov 20, 2001
149
0
0
CA
I have an Access database on a shared network drive. There is another vb application in the same folder.
In the Access App, when a user clicks on a button, I want to open the vb app. I can't hard code the location because the shared folder is mapped differently on each pc that opens the database.
Ideally, I would like the Shell() to look in the same folder as the database.
I have tried Shell("vbApp.exe"), Shell("\vbApp.exe"), Shell(".\vbApp.exe") and none of it seems to work.
 
I figured it out.
Shell( CurrentProject.Path & "\vbApp.exe")
 
Do you have the slashes confused? I have used the syntax "./App.exe" although not in the Shell function.
 
Using Shell("./vbApp.exe") gives me a file not found.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top