Hi Ron,
I have got completley lost now...
I have no idea what code I am meant to put where and do what with it...
ahhhhhhhh this is so frustrating when I have no idea what to do...and
things are so close with you RDBMERGE programme....
Help again please.
Mark
"Ron de Bruin" wrote:
I will add this option in the add-in in the next version but until then you must use code
Use a macro from this page
http://www.rondebruin.nl/copy3.htm
Copy the code in "Funnel OP Master.xls"
And have the sheet active where you want the data
For example in the first macro change
'Add a new workbook with one sheet
Set BaseWks = Workbooks.Add(xlWBATWorksheet).Worksheets(1)
To
'Point to the activesheet
Set BaseWks = ActiveSheet
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Mark Allen" wrote in message ...
I used your tool that you supplied....RDBMERGE...
Regards
"Ron de Bruin" wrote:
Which code example have you try ?
I will not change the add-in for this but can show you how to change the code
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Mark Allen" wrote in message ...
RDBMERGE works great...does what I need...
Now how do I get it to populated an exsiting workbook...
Star man...
Regards
Mark
"Ron de Bruin" wrote:
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