jay said:
How do you run an application in vba?
The program I want to execute from a simple button:
c:\program files\winzip\winzip32.exe
Can this be done?
I found a simple example.
Answer: From your Access database, you can launch any application that you
wish.
For example:
Private Sub Command1_Click()
Dim stAppName As String
stAppName = "C:\Program Files\Adobe\Photoshop 6.0\Photoshp.exe"
Call Shell(stAppName, 1)
End Sub
In this example, we've created a button called Command1. When the user
clicks this button, the VBA code will create and open a session of
PhotoShop 6.0. Simply set the stAppName variable to the path of the
application that you wish to open.
