Open Progran From Access

D

DS

I want to Open another Program from Access and can't quit figure it out.
I'm not sure about the Syntax and the order that things need to happen in.

Private Sub Command0_Click()
'Close Current Form
DoCmd.Close acForm, "Form1"
'Quit Access
DoCmd.Quit
'Open Program
Set rShell = CreateObject("WScript.Shell")
rShell.Run """C:\ProServ\Utility\ProServBackUp.exe"""
End Sub

Any help appreciated.
Thanks
DS
 
G

Guest

This works to launch Excel

Shell "C:\Program Files\Microsoft Office\OFFICE11\excel.exe", vbMaximizedFocus

simply modify it to suit your needs.

Daniel
 

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

Top