Consulting

Results 1 to 3 of 3

Thread: What is the code to open access file

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Contributor
    Joined
    Nov 2009
    Posts
    114
    Location

    What is the code to open access file

    How to open the mdb file with password by using the excel vba. Then ask the access to export the form as excel file. Any reference library is needed❔Thanks!

  2. #2
    [VBA]
    Getobject("G:\OF\example.mdb").visible=true
    [/VBA]

  3. #3
    VBAX Tutor mohanvijay's Avatar
    Joined
    Aug 2010
    Location
    MADURAI
    Posts
    268
    Location
    Use ADODB library and connect mdb file by using connectionstring

    for connection string see below link

    http://www.connectionstrings.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •