Export data from closed workbook to active workbook with ADO connection

Hi all,

I just want to export data from closed workbook to active workbook via ADO connection. can anyone help on this?

It takes VBA coding but here is a good read to assist

http://support.microsoft.com/default...b;en-us;278973
hope that helps

Given link doesn't works.

Try this
Dim strSQL As String, conStr as String
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset


conStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" & path & "';" & _
"Extended Properties=""Excel 12.0;HDR=YES;IMEX=1;"";"

strSQL = "SELECT [Field1], [Field2] FROM [Worksheet$] WHERE [Thing1] > 1"

cnn.open conStr
rs.Open query, cnn, adOpenStatic, adLockOptimistic, adCmdText

Yeah that's working.

Also, how to Paste some range of cells to Closed workbook. can anyone?