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. |
Opening Access Only Question
If you use ActiveX automation to launch MS Access, instead of SHell(), then
it does not matter where msaccess.exe is located. Better yet, with automation, you can use your code to let Access do many things a user can do manually. While using Shell, after Access started, your code have little control to the Access it started. Dim asc as Access.Application Set asc=New Access.Application asc.Visible=True .... 'Do something with Access .... 'If you are done, yo can choose to close it programmatically asc.Quit "Launchnet" <u20911@uwe wrote in message news:75a9e7edcc537@uwe... 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. |
All times are GMT +1. The time now is 07:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com