Thread: Can you open Access Database through Excel VBA?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Don Wiss Don Wiss is offline
external usenet poster
  
Posts: 300
Default Can you open Access Database through Excel VBA?
On Mon, 8 May 2006 16:41:00 -0500, amrezzat
wrote:

Set dbnorthwind = OpenDatabase(dbpath)

You will also need to set a VBA Tools - References... to Microsoft DAO 3.6
Object Library.

Don <www.donwiss.com (e-mail link at home page bottom).
Reply With QuoteReply With Quote