PDA

View Full Version : What is the code to open access file



clif
10-04-2012, 05:26 PM
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!

snb
10-05-2012, 01:09 AM
Getobject("G:\OF\example.mdb").visible=true

mohanvijay
10-05-2012, 01:26 AM
Use ADODB library and connect mdb file by using connectionstring

for connection string see below link

http://www.connectionstrings.com/