Consulting

Results 1 to 3 of 3

Thread: What is the code to open access file

  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
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,635
    [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
  •