Opening an ACCESS db from the VBE in EXCEL

D

Doctorjones_md

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.
 
J

Jim Jackson

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

doctorjones_md

I ended up using this code -- can't find the exact thread (or recall who
offered it), but it works GREAT!

ActiveWorkbook.FollowHyperlink Address:="\\Fileserver\Products.mdb", _
NewWindow:=True

Shane
==================================
 
Top