ExcelBanter - excel db, but because password

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - excel db, but because password (https://www.excelbanter.com/excel-programming/353073-excel-db-but-because-password.html)

tom taol

excel db, but because password

the following code is not working... because the password format....
please

Set db = OpenDatabase(ThisWorkbook.Path & "\" & szFileBase, 0, 0, "EXCEL
8.0;PWD=1111")

*** Sent via Developersdex http://www.developersdex.com ***

Tim Williams

excel db, but because password

See he
http://support.microsoft.com/?id=257819

It seems you must first open the workbook in Excel before using DAO to query
it.

Tim

"tom taol" wrote in message
...

the following code is not working... because the password format....
please

Set db = OpenDatabase(ThisWorkbook.Path & "\" & szFileBase, 0, 0, "EXCEL
8.0;PWD=1111")

*** Sent via Developersdex http://www.developersdex.com ***

tom taol

excel db, but because password

thanks, tim
but i wonder the password setting only in excel db.

*** Sent via Developersdex http://www.developersdex.com ***

All times are GMT +1. The time now is 10:12 PM.