Excel 2007 : Copy Range From Closed Workbook

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. Please see the below module i used, anyone can help to solve this

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Added this time