Open an application

[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

 

[SteveD]

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

 

[Dirk Goldgar]

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

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

 

[TIML]

never mind, my question was answered by fusion_z. Sorry!!

shell("Path to program")

 

[TIML]

Thanks Steve, I did not see your response.

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]

Thanks Dirk, I did not see your response.

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


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)