Hi,
I have tried all versions of Mr. Erlandsen's examples (Import data from a
closed workbook using ADO) and found none that will work in my case.
1- the workbooks I have to import from contain one single sheet with a named
range that incudes all the data but with no column (fields names) headers.
2- the workbooks are all password protected.
For the field names, i loose the 1rst row of data and for the password, I
get to type it for every workbook.
Does any one know a way out of this problem. Any suggestion?
Thanks.
--
Jac Tremblay