Opening an ACCESS db from the VBE in EXCEL
 

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
 

http://www.erlandsendata.no/english/...php?t=envbadac

Hth,
Merjet

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.

Opening an ACCESS db from the VBE in EXCEL
 

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
==================================
"merjet" wrote in message
ups.com...
http://www.erlandsendata.no/english/...php?t=envbadac

Hth,
Merjet