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!
Printable View
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!
[VBA]
Getobject("G:\OF\example.mdb").visible=true
[/VBA]
Use ADODB library and connect mdb file by using connectionstring
for connection string see below link
http://www.connectionstrings.com/