Copy a range from closed workbooks (ADO)

First off, thank you in advance for any help. I love this site:

I am trying to pull data from a few hundred workbooks in a single folder. Each workbook has a sheet labeled "Output" with normalized data in the range A2:KB2. the Header row is A1:KB1.

I am working with a ADO Macro which I obtained from the site below:
http://www.rondebruin.nl/ado.htm

Everything is working fantastic with one exception. The Data table does not pull for all columns. Instead of pulling the range A2:KB2 it pulls A2:IU2. The souce code I am using is below:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Adapt the path (c01) to your specific situation.

I wonder if there is an issue with the maximum number of fields Ado can handle.

Perhaps I should have said it's a limit of the MS Jet provider

If your folder is: S:\Postsales\approvals this code should work without any adaptation.

Please Login or Register  to view this content.