Has anyone found a usefull excel compare tool that works well with the compare functionality in EPDM. We use excel based BOM's currently and it would be very helpfull when checking to see what has changed since the last release.
I'm not sure how well this can be integrated into EPDM, but I made my own tool that compares two Excel files and highlights what has changed. Here's a picture of the comparison result. Let me know if this is what you are looking for and I can send it to you.
We are about to have EPDM installed, but one thing that we want to keep separate are Excel-based BOMs.
Your tool would be ideal for us.
Any chance that you could let me have a copy, please?
Your macro looks helpfull. I may be able to figure out a way to use it with the built in compare feature of EPDM.
Could you please send be a copy as well.
Chris - We keep our Excel Based BOMs within EPDM. The only issue we have is that you can't forget to check out the file before you start working on it. Otherwise it is great. We have updating title blocks that automatically add approval dates and approvers initials as well as updating Revisions that are generated from our workflow. We also automatically generate pdf for our manufacturing group on the release of every Rev.
Also it's always nice to see an older version of a file and roll it back if neccessary.
Derek - The BOMs are generated in Sybiz, which will cause a problem with "The Way It Has Always Been Done", but I will certainly take your suggestion to a few meetings :-)
Some interesting stuff here.
Here is another one I found the other day.
Try Synkronizer Excel Comparison Tool. It will Give you Full functionality to Compare Excel Files.
Synkronizer Excel Compare Tool: Compare Two Excel Files/Spreadsheets for Differences - Synkronizer
Retrieving data ...