MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Consolidation of Excel Files

  Asked By: Franklin    Date: Jan 17    Category: MS Office    Views: 1303

Do you have a script on consolidating of multiple Excel files on a specfic



3 Answers Found

Answer #1    Answered By: Ibtihaj Akhtar     Answered On: Jan 17

I don't but someone may have.

You would probably need to use the FileSystemObject to iterate through the
folder and append each sheet of each file to a master file. I have not got
the time at the moment to write this for you, sorry.

Answer #2    Answered By: Leonardo Costa     Answered On: Jan 17

i just need some research on this........

Answer #3    Answered By: Camille Garrett     Answered On: Jan 17

Have a look in Google Newsgroup search for "consolidate folder
multiple", without quotation marks.

Resulting page address below:

First few hits should satisfy all your needs.

Didn't find what you were looking for? Find more on Consolidation of Excel Files Or get search suggestion and latest updates.