Archive of Mr Excel Message Board

Back to Other Office and Excel archive index
Back to archive home

EXCEL APP THAT EXPOSES ACCESS
Posted by ROBERT JACKSON on January 04, 2002 4:16 PM
DOES ANYONE KNOW OF A EXCEL APPLICATION THAT EXPOSES AN ACCESS DATABASE

Re: EXCEL APP THAT EXPOSES ACCESS
Posted by Ivan F Moala on January 04, 2002 4:50 PM
Excel can expose most Applications as long as
you have set a reference to it's Com or Dll or
what ever Library files are required.
If i undertand where your going to then you want
to open an Access data base ??
If so then you can do this via VBA & automation.
eg
Option Explicit
Dim dbAccess As Access.Application
Sub OpenAcessDB()
Set dbAccess = CreateObject("Access.Application")
With dbAccess
.OpenCurrentDatabase _
("E:\mydir\myAccess.mdb")
End With
End Sub
This should get you started.
Ivan

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.