I have the following code in the Excel VBA, however, database is password protected and I cannot export to database. Any ideas how to bypass the password?
Dim db As DAO.Database, rs As DAO.Recordset, r As Long
Set db = OpenDatabase("R:\XXX\MDB.mdb")
' open the database
Thanks.
Bookmarks