Opening an ACCESS db from the VBE in EXCEL "Doctorjones_md" <xxxDoctorjones_mdxxx[ at ]xxxyahoo.com> 4/17/2007 4:56:11 PM 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.

Re: Opening an ACCESS db from the VBE in EXCEL merjet <merjet[ at ]comcast.net> 4/17/2007 4:59:42 PM http://www.erlandsendata.no/english/index.php?t=envbadac Hth, Merjet

RE: Opening an ACCESS db from the VBE in EXCEL Jim Jackson 4/17/2007 7:48:04 PM ActiveWorkbook.FollowHyperlink Address:="C:\MyFolder\ _ MyDatabase.mdb", _ NewWindow:=True -- Best wishes, Jim "Doctorjones_md" wrote: [Quoted Text] > 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. > > >

Re: Opening an ACCESS db from the VBE in EXCEL "Doctorjones_md" <xxxDoctorjones_mdxxx[ at ]xxxyahoo.com> 4/17/2007 8:12:11 PM Many Thanks Jim -- your code worked BRILLANTLY! :) Shane "Jim Jackson" <JimJackson[ at ]discussions.microsoft.com> wrote in message news:E262FB37-A64E-4A6C-BA3E-04A95A20ECC2[ at ]microsoft.com... [Quoted Text] > 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. >> >> >>

Re: Opening an ACCESS db from the VBE in EXCEL "doctorjones_md" <doctorjonesxxxxx_mdxxxxx[ at ]yahoo.com> 4/20/2007 6:35:13 PM 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" <merjet[ at ]comcast.net> wrote in message news:1176829182.803370.241800[ at ]y5g2000hsa.googlegroups.com... [Quoted Text] > http://www.erlandsendata.no/english/index.php?t=envbadac > > Hth, > Merjet > >