Pat shared this with us in microsoft.public.excel.programming:

Hi,

I try to via vba-code to get fields value of a Excel-workbook without
open. It seem to work. But when i try to do it with an
Excel-workbook it is protect by a password, it doesn't work anymore.
Because i don't want to open the workbook first and close it against.
In case i want to generate a summary of 500 workbooks, and need to
open all the workbook one for one, then it affect the performance.

Hope that some people can help me!

Best regards,

Pat

I assume you are familiar with this page?
http://www.rondebruin.nl/ado.htm

I suppose the password should go somewhere in the connection string.
That's where you have to put it when connecting to an SQL or LDAP
server, in my experience. Alas, I wouldn't know the syntax for Excel.

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way
http://www.catb.org/~esr/faqs/smart-questions.html
How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
o-answers.html