Opening an ACCESS db from the VBE in EXCEL
 

ActiveWorkbook.FollowHyperlink Address:="C:\MyFolder\ _
MyDatabase.mdb", _
NewWindow:=True
--
Best wishes,

Jim


"Doctorjones_md" wrote:

What is the VBA code for opening an existing ACCESS database from the VBE ?
I can't find any specific reference to this when I google it.

Thanks in advance for any assistance.

Opening an ACCESS db from the VBE in EXCEL
 

Many Thanks Jim -- your code worked BRILLANTLY! :)

Shane
"Jim Jackson" wrote in message
...
ActiveWorkbook.FollowHyperlink Address:="C:\MyFolder\ _
MyDatabase.mdb", _
NewWindow:=True
--
Best wishes,

Jim


"Doctorjones_md" wrote:

What is the VBA code for opening an existing ACCESS database from the VBE
?
I can't find any specific reference to this when I google it.

Thanks in advance for any assistance.