excel db, but because password

[tom taol]

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]

See here:
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" <tom@yahoo.com> wrote in message
news:%23GMRpT6LGHA.344@TK2MSFTNGP11.phx.gbl...
>
> 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]

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



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