Importing from multiple workbooks

Question

I have completed some code to open multiple workbooks and copy data into one master workbook. I can't figure out how the code "chooses" which workbook to open first to import. Anybody have any ideas what is the method excel uses to select the files?

it most likely follow the order of which you defined in the code.. — J Bom, Feb 04 '16 at 12:25
i Could see that it is taking in the Alphabetical order of the file name — Siva, Feb 04 '16 at 13:29

score 0 · Answer 1 · edited May 23 '17 at 11:52

0

Take a look at this post over here. There is a link in the responses to a blog which talks about Window natural sorting method. Unless you specify in the code which files to open, VBA will normally open the files based on the natural sorting method.

edited May 23 '17 at 11:52

Community

1
1

answered Feb 04 '16 at 13:57

Sorcefyre

204
2
2

Importing from multiple workbooks

1 Answers1