View Full Version : Password protected Workbook
sukumar.vb
09-05-2011, 11:51 AM
Workbook is password protected and I want to read and import contents of its first column using ADO into a different Workbook. Can you please help me?
visible2you
09-05-2011, 01:50 PM
Workbook is password protected and I want to read and import contents of its first column using ADO into a different Workbook. Can you please help me?
I guess that you can't open a password protected workbook through ADO.
Please read kb#257819 (http://support.microsoft.com/kb/257819)
However, I will help you with a VBA program to open password protected workbook. :think:
sukumar.vb
09-05-2011, 02:01 PM
Thanks for solving this. I am not able to mark this thread as "Solved".
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.