Change code of Macro that joins CSV files

[rpinxt]

Hi All,
Lets try it different.
So this is the code I have to join data from several CSV files:

Please Login or Register  to view this content.

Now I want to change this part:

Please Login or Register  to view this content.

I do not want to browse for the folder but I want to tell the macro were to look.
With code like this:

Please Login or Register  to view this content.

But just swap one piece of code with the other just won't do it.
Can someone please assist in how to do this? Thanks!
I included some CSV files to test with.

[rpinxt]

Ok....adter 1,5 day I seem to have fixed it.
And, as usual, the solution looked to be very simple.....
I changed the part of code which lets you browse to a folder with this:

Please Login or Register  to view this content.

So block (or remove) the set oApp and the set oFolder lines and make the 'foldername' statement variable (or fixed but I will make it variable later).

Hope this helps others with a similar problem