View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Launchnet Launchnet is offline
external usenet poster
 
Posts: 25
Default Opening Access Only Question

Hi . . .
I currently use the following code to open a new instance of Access on my PC.
It works fine.

What I need is to have the code open Access from any location that the .EXE
file may be located at. Some of my users have it with different paths.

Sub NewAccessOnly()
Shell "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE",
vbNormalFocus
End Sub

Can someone give me a hand please?

Thanks
Matt@Launchnet

--
Please take a look at www.openoursite.com Click on: "Keywords" and then
Click on "Matt's Story" and if you are a man, you should be very happy that
you read my story. God Bless for everyones help.