Recently, I have been assigned the task of tracking training records used by multiple departments within my company. Before, they would fill out ISO Standard Forms that are built in MS Excel and save them in one folder. This folder held ALL of the documents used by multiple departments, training on multiple topics. The first assignment was to organize this, which I did by building macros in the forms to save these files in a document tree that was built dependent on some data from the form itself. Then they asked me for a program to make it easy to find these files, so I built a program that would populate a series of dropdown boxes that worked their way through the tree. Now they want to add a SQL database to track data from the sheet and add an archiving feature that checks the revision number of the form and moves it to another folder if there are higher revisions.
If they assigned all of this in the beginning, it would have been great. BUT... now I have about 75 documents spread across network locations with macros built into them, being tracked by a very simple program.
Is there (or has there been) a good method for doing all of this work WITHOUT macros. I'd like to get rid of them altogether, and not have to worry about updates not taking effect in all previously saved files. I found something called GemBox.Spreadsheet that would help manipulate data in Excel. Anyone ever heard of it?
I'm not looking for code samples right now, but more a discussion on some good ways to do this. A little brainstorming anyone?...