C cribeiro Oct 31, 2003 #1 How to use Jet Oledb Provider to read data from a protected Excel workbook? Thanks in advance.
T Tom Ogilvy Oct 31, 2003 #2 See Mr. Erlanden's page for some example code: http://www.erlandsendata.no/english/vba/adodao/index.php
See Mr. Erlanden's page for some example code: http://www.erlandsendata.no/english/vba/adodao/index.php
O onedaywhen Oct 31, 2003 #3 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
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
T Tom Ogilvy Oct 31, 2003 #4 Missed the qualification that the workbook was protected. Regards, Tom Ogilvy
