Excel 2007 : Consolidate data from Workbook

[marzook]

Hi,

Can you please assist, I am trying to collate data from one workbook to onother. i used below ADO Module and its collating the data. But the issu its not tracking all the Columns i need, if the column range exceed "Column IV" i am getting error.

I got the data in Range A1 : ACF390 and i need to track all the data in this range. i used the sample code from bleow site

http://www.rondebruin.nl/ado.htm

Thanks,

[JBeaucaire]

Let's see your macro.