VBA to access data from closed workbooks
 

Hi,
I am looking for a VBA code that will do the following:

I have several files within one workbook (maybe fifty) that I would like to summarize all the data into another master workbook. Each file has data in the "summary" tab in cells A1 thru A76. I would the macro to extract the data into one worksheet column A,B,C etc. Can it automatically extract data from all files in a certain folder?

thanks for your help

VBA to access data from closed workbooks
 

hi,

look the example at the following link
Copy a range from closed workbooks (ADO)
http://www.rondebruin.nl/win/s3/win024.htm

isabelle

VBA to access data from closed workbooks
 

On Friday, March 27, 2015 at 2:28:51 AM UTC-4, isabelle wrote:
hi,

look the example at the following link
Copy a range from closed workbooks (ADO)
http://www.rondebruin.nl/win/s3/win024.htm

isabelle

I might be able to get this working for me, thanks so much for your help.