MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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