Opening a Specific File When Using Shell Function 1

[HMJ]

We are trying to setup a button that would open a specific application (MSAccess) and a specific file. According to my reference books, this can't be done - but we all know books are not perfect.

Our current command line is:

    Call Shell(stAppName, 1)

Where stAppName = "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"

This works good so far, but we need the specific MDB (C:\MSAccess Files\Project 15698.MDB) to open. Anyone know how we can do this?

Thanks.

Harry Jessen
HMJessen@Yahoo.com

 

[PHV]

Have you tried this ?
stArgs=" ""C:\MSAccess Files\Project 15698.MDB"""
Call Shell(stAppName & stArgs, 1)

Hope This Help
PH.

 

[HMJ]

PH:

THANK YOU!! It works great!



Harry Jessen
HMJessen@Yahoo.com