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

You can repeat this line with a different range and dest cell

GetData ThisWorkbook.Path & "\test.xls", "Sheet1", _
"A1:C5", Sheets("Sheet1").Range("A1"), True, True

Tell me in which example you want to use it in the example workbook if
you can't make it work.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DarnTootn" wrote in message ...
opps wrong reference below.. the correct link
ishttp://www.rondebruin.nl/ado.htm

"DarnTootn" wrote:

I am using Ron DeBruins code to accomplish my original task. (works great)
http://www.rondebruin.nl/copy1.htm#workbook
But recently more data is needed from a second sheet within the same
workbook(s) that I am retreiving my data from. Is there a way to add code
to this example to include a second range of data from the same workbook?

Thank you in advance for the help....