Jet Ole DB With Excel
 

How to use Jet Oledb Provider to read data from a protected Excel workbook?

Thanks in advance.

Jet Ole DB With Excel
 

See Mr. Erlanden's page for some example code:

http://www.erlandsendata.no/english/...odao/index.php

--
Regards,
Tom Ogilvy

cribeiro wrote in message
...
How to use Jet Oledb Provider to read data from a protected Excel
workbook?

Thanks in advance.

Jet Ole DB With Excel
 

You cannot use ADO/DAO to read a password-protected Excel workbook. The
reason is that protecting it with a password actually encrypts the
workbook on disk and ADO/DAO has no way of decrypting it. See the
following MSDN article:

Microsoft Knowledge Base Article - 211378
XL2000: "Could Not Decrypt File" Error with Password Protected File
http://support.microsoft.com/?KBID=211378

"cribeiro" wrote in message ...
How to use Jet Oledb Provider to read data from a protected Excel workbook?

Thanks in advance.

Jet Ole DB With Excel
 

Missed the qualification that the workbook was protected.

Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
See Mr. Erlanden's page for some example code:

http://www.erlandsendata.no/english/...odao/index.php

--
Regards,
Tom Ogilvy

cribeiro wrote in message
...
How to use Jet Oledb Provider to read data from a protected Excel
workbook?

Thanks in advance.