Open Ms Access File

R

Ronald Dodge

Dim acApp as Access.Application
Set acApp = CreateObject(<FileFullName>,Access.Application)

Notes:

<FileFullName> needs to include the full path name to the file, the file
name and including the file's up to 3 letter extension.

Before running this code, you will need to be sure that you have in your
Excel VBA a reference to Access, which can be gotten to by Tools>References
within your VBE window.

To refer to the Access application/file, you will need to use the acApp
variable to prequalify your Access objects, unless the code is using a
variable that already reference to the object(s).
 

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