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!
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/