 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
VB Forum / Database Access / October 2003How to open password protected excel workbook through VB-6 ?
How to open password protected excel workbook through VB-6 ? I can open workbooks having no passwords through microsoft jet provider, but I don't know how to open password protected workbook ? Best Regards, Luqman ¤ How to open password protected excel workbook through VB-6 ? ¤ ¤ I can open workbooks having no passwords through microsoft jet provider, but ¤ I don't know how to open password protected workbook ? ¤ Password protected Excel Workbooks are unsupported by the OLEDB and ODBC data providers. Paul ~~~ pclement@ameritech.net Microsoft MVP (Visual Basic) You cannot use ADO to read a password-protected Excel workbook. The reason is that protecting it with a password actually encrypts the workbook on disk and ADO 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 > How to open password protected excel workbook through VB-6 ? > [quoted text clipped - 4 lines] > > Luqman Thanks for your help, I have finally did it using excel object library in VB-6. Best Regards, Luqman > You cannot use ADO to read a password-protected Excel workbook. The > reason is that protecting it with a password actually encrypts the [quoted text clipped - 13 lines] > > > > Luqman |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.