ron de bruin merge data

  1. S

    Merging all in folder to ACTIVE/CURRENT XLS - I am sure its straight forward - but its baffling me.

    Morning all, I have searched for an 'all files in a folder merge to 1 doc' code and found this brilliant piece of code (below) I am struggling to get it to merge into the current excel doc. (I know the 'Set BaseWks = Workbooks.Add' line is what I need to change but I am struggling to get the...
    • splreece
    • Thread
    • active document merge data newbee ron de bruin merge data
    • Replies: 1
    • Forum: Excel Questions
  2. O

    Ron de bruin merge data browse - set destination help

    I am using Ron De Bruin code to merge files into one data set, however this code is creating a new workbook with a sheet called combined. I would like the destination to be in A1 of the active worksheet. I don't want a new workbook. Please advise

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top