Merging Unshared Excel Workbooks?

[firebirdta84]

I have a system in place where multiple users send me an Excel spreadsheet containing the same columns of information, just different data. I need to take those files and merge them into one Master Workbook, which will basically append each user's spreadsheet into one main one. Due to the current set up, I cannot do the Shared Workbook feature, so I am looking for an alternative. I've found programs out there (like DigDB) that do the job, but it costs a bit more money than I want to spend. Is there a FREE or LOW COST program that can take care of this for me? It doesn't seem like I can do this in Excel without sharing the workbooks. Thanks.

 

[SkipVought]

Hi,

You can use NS Query. faq68-5829.

However, it will take a macro (VBA code) to bring everything together.

If you wish to pursue this approch, please repost in Forum707.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}