Microsoft ActiveX Data Objects 2.9 Library

Where can I download this from??? I have been searching for the past couple of hours and all I can find is 2.8.

I was told the following macro requires it:

http://goo.gl/F29hxR

Original Thread:

http://www.excelforum.com/excel-prog...rworkbook.html

Originally Posted by Izandol

I have never heard of 2.9 version. I think change was from 2.8 to 6.0 with Windows Vista.

So if I am stuck on XP SP3 with Office 2010... How can I get the following: http://goo.gl/F29hxR

to stop throwing this error:

Noname.jpg

Originally Posted by Izandol

Do you have Sheet1 in your workbook?

Originally Posted by Norie

That error doesn't look as if it would be caused by not having the correct version of a library.

Why not use late-binding anyway?

I fixed it by changing

SQL = "SELECT * FROM [YIELD_FORMATTED$C1:BC100000

to
SQL = "SELECT * FROM [YIELD_FORMATTED$C1:BC10000

But I really want to copy from B1-IV80. Any tips?

Originally Posted by Norie

You could return all the data from the worksheet then delete the columns/rows you don't want.

Well the point is to copy and paste the columns from my 300+ workbooks into one workbook (each new paste will be done sequentially)....