Open an application

  • Thread starter Thread starter TIML
  • Start date Start date
T

TIML

Is there a way to open an application (call on an .exe) from within access
vba?

Reason: I create a text file with Access and then have to open a VB
application that I built to convert to the text file into a different
(format) file.

I am using Access 2000.

Tim
 
try using the wizard when adding a button to a form. It
walks through a series of steps to connect your
application. Then see the code behide it.

Hope that helps
 
TIML said:
Is there a way to open an application (call on an .exe) from within
access vba?

Reason: I create a text file with Access and then have to open a VB
application that I built to convert to the text file into a different
(format) file.

I am using Access 2000.

Tim
Click to expand...

See help for the Shell function. Also, since you may need to wait for
the shelled application to finish, see this link:

http://www.mvps.org/access/api/api0004.htm
 
Thanks Steve, I did not see your response.

SteveD said:
try using the wizard when adding a button to a form. It
walks through a series of steps to connect your
application. Then see the code behide it.

Hope that helps
Click to expand...
 
Back
Top