Password protected Workbook

[sukumar.vb]

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]

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]

Thanks for solving this. I am not able to mark this thread as "Solved".