Excel 2007 : Import bulk CSV into 'Sheet2' based on list in 'Sheet1'

Hi Guys
I want to import (over 100) files from a folder (MyFolder) into 'Sheet2'
But I need to force the import order (Using Dir() messing up the Ascending )

In 'Sheet1' I'm creating a list of all files from 'MyFolder'
Macro must then, import the files following the order-list.

Thanks for your kind help.
A.C.

So instead of DIR() you will be using the filename listed in your worksheet instead.

Please Login or Register  to view this content.

....something along those lines.

Hi JBeaucaire
Thanks for that!
Please allow me to ask if you can suggest with code?
('the rest of your code)
The code I'm using, is too complicate to manipulate and use here..

Thanks
A.C

So far you've asked how to evaluate files in a specific order based on a list, I've shown you one way to do that.

I can't suggest other code based on criteria you haven't provided.

Hi JBeaucaire
Many thanks for your kind help.

Glad to help.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)