Launch a file using a program other than the one associated throug

  • Thread starter Thread starter TexWolf
  • Start date Start date
T

TexWolf

Is there a way to program a button in Access to launch a known file into a
program other than the one associated to the file in Windows XP?
 
The only way that comes to mind would be to use the Shell function. That
will, of course, require that you know the complete path to the executable
you want to use to launch the file.
 
I know how to get ths Shell function to launch a program, but how do I get it
to open the file?
 
ShellExecute will use whatever application's associated with the file
extension, which isn't what TextWolf's asking for.
 
Depends on the executable.

Many allow you to pass the name of the file as an argument:

Dim strExecutable As String
Dim strFile As String

strExecutable = "C:\Program Files\SomeApp\app.exe"
strFile = "C:\Documents\MyFile.xyz"

Shell """" & strExecutable & """ """ & strFile & """"

That's four double quotes in a row at the beginning and end, and two sets of
three double quotes in the middle. The intent is to create

"C:\Program Files\SomeApp\app.exe" "C:\Documents\MyFile.xyz"

to handle embedded spaces in the path.
 
Awesome! It works great.
You rock!

Thanks.

Douglas J. Steele said:
Depends on the executable.

Many allow you to pass the name of the file as an argument:

Dim strExecutable As String
Dim strFile As String

strExecutable = "C:\Program Files\SomeApp\app.exe"
strFile = "C:\Documents\MyFile.xyz"

Shell """" & strExecutable & """ """ & strFile & """"

That's four double quotes in a row at the beginning and end, and two sets of
three double quotes in the middle. The intent is to create

"C:\Program Files\SomeApp\app.exe" "C:\Documents\MyFile.xyz"

to handle embedded spaces in the path.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NEXTINSPACE read all about it ------------ 0
Creating a File 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access hyperlinks ignore file associations 4
Launch mde from another mde: fine tuning 1
Mozilla launched Firefox Send 0
calling sql loader from vba 1
Launch Program from Access 4

Back
Top