Hi Mark

My code and the add-in create a new workbook with the data
You can change the code to copy it in a existing workbook but first
try the code and see if it is working.

If it is working post back and post your code so I can change it

--

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


"Mark Allen" wrote in message ...
Ron,

I have now completely lost myself...

I have managed to fetch some data back but may be I have not explained
correctly what I am looking to do:

All the following files are in a folder "c:\OP Funnel"
I have one master file called "Funnel OP Master.xls"
I have six additional files called "Funnel OP 1.xls, 2.xls, 3.xls, 4.xls,
5.xls, 6.xls"
I need to merge the data from "A36:E36" through to "A300:E300" if there is
data there from the above six files
I need to merge all this data in the file "Funnel OP Master.xls" into the
range "A36:E36" through to "A10000:E10000".

I am really not sure how to do this looking at your formulas in Visual
basic..

I would very much appreciate your help on this subject

Regards

Mark

"Ron de Bruin" wrote:

Hi Mark

See
http://msdn.microsoft.com/en-us/library/cc837974.aspx

Or check out my website

--

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


"Mark Allen" wrote in message ...
I need to gather information from multiple files that all have the same
layout but different information.

Is it possible to update this information into one master excel file from
the other files???

Regards

Mark Allen