Modify the code to consolidate files in same order as saved in source folder

**Masa1989** · 08-07-2015, 10:35 AM

Hi Guys
I have this code which consolidates the files from fpath into master file.
i have 20 files in fpath and i have numbered it from 1 to 20.
Everytime i run the macro it picks the file in radom order and consilidates it, how to modify it pick in the same order as its being put in the fpath.

Please Login or Register  to view this content.

Thanks for any assistance

**6StringJazzer** · 08-07-2015, 10:47 AM

The order that files are stored in a Windows folder is undefined. There is no guarantee about how they will be ordered when you retrieve them using Dir.

If the order is important then you should capture all the file names in an array first, then sort the array by whatever criteria you want to use. Even better, if you have files numbered from 1 to 20, why not just loop through all the file names in that order, instead of using Dir? Do the file names change each time you run this? Using Dir suggests that you don't already know what files are going to be there.

**Masa1989** · 08-07-2015, 11:31 AM

Hi i really possess basic knowledge about vba, can you illustrate an example of how i could use an defined array in that code?
Thanks a lott..

**Masa1989** · 08-07-2015, 11:43 AM

File names remains same. it doesn't change everytime i run the macro

**6StringJazzer** · 08-07-2015, 12:49 PM

If you show me what the file names look like I can provide the code changes.

**Masa1989** · 08-07-2015, 12:55 PM

My file name looks like something like this
1)1.ModelA.Xlsm
2)2.ModelB.Xlsm
3)3.ModelC.Xlsm

and so on till 20th

**Masa1989** · 08-08-2015, 12:50 PM

Hi

Could you show a syntax change?
I would be really grateful.

Thnks for your assistance..

**6StringJazzer** · 08-12-2015, 01:49 PM

I have not tested this. It would take some effort to replicate your setup. Please let me know if there are any problems and be specific if something doesn't work.

Please Login or Register  to view this content.

**Masa1989** · 08-13-2015, 01:05 AM

Hi Bro
Thanks for your help buddy

I am not able to run this code, its not giving me any error though, nothing happens either when i run it.

**6StringJazzer** · 08-13-2015, 05:44 PM

I tested a simplified version and found a bug. Please make the change shown.

Please Login or Register  to view this content.

**Masa1989** · 08-16-2015, 12:35 AM

Thanks a lot for getting back!!

It works perfectly fine..thank you soo much!

Best Regards

**6StringJazzer** · 08-17-2015, 09:21 AM

You're welcome and thanks for the rep! Please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

Modify the code to consolidate files in same order as saved in source folder

LinkBack

Thread Tools

Rate This Thread

Display

Modify the code to consolidate files in same order as saved in source folder

Re: Modify the code to consolidate files in same order as saved in source folder

Re: Modify the code to consolidate files in same order as saved in source folder

Re: Modify the code to consolidate files in same order as saved in source folder

Re: Modify the code to consolidate files in same order as saved in source folder

Re: Modify the code to consolidate files in same order as saved in source folder

Re: Modify the code to consolidate files in same order as saved in source folder

Re: Modify the code to consolidate files in same order as saved in source folder

Re: Modify the code to consolidate files in same order as saved in source folder

Re: Modify the code to consolidate files in same order as saved in source folder

Re: Modify the code to consolidate files in same order as saved in source folder

Re: Modify the code to consolidate files in same order as saved in source folder

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Copy certain files from Source folder to Destination folder

[SOLVED] How can I modify this code so that I can only consolidate certain columns?

[SOLVED] How to modify the macro wich summarize all the files from the particular folder?

Macro to export excel files from outlook folder and consolidate

How to Send automated mails with attachment files saved in a folder?

copying data from excel files in a source folder to target folder

modify ALL files in a folder

Bookmarks

Bookmarks

Posting Permissions