| 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 | |||
| Restrict Access upon Opening? | Excel Discussion (Misc queries) | |||
| When opening Excel - get Access (Read-Only) file and error | Setting up and Configuration of Excel | |||
| user cannot access his share workbook after opening network path. | Excel Discussion (Misc queries) | |||
| Opening Access From Excel | Excel Discussion (Misc queries) | |||
| opening access database using macro | New Users to Excel | |||
Linear Mode
