Open Ms Access File

  • Thread starter Thread starter milo
  • Start date Start date
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).
 
Back
Top