Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.templates,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.templates,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Opening an ACCESS db from the VBE in EXCEL
|
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.templates,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.templates,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.templates,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening an ACCESS db from the VBE in EXCEL | Excel Discussion (Misc queries) | |||
Opening an ACCESS db from the VBE in EXCEL | Excel Worksheet Functions | |||
Opening Access From Excel | Excel Discussion (Misc queries) | |||
Opening Excel from Access | Excel Programming | |||
Opening Access from Excel | Excel Programming |