The company I work for has a large knowledge base of work instructions, manuals, specifications, and general information all stored in a customized Document Library that uses meta tags to organize word (well, mostly word, but there are some excel files and pdf entries too) files into libraries and assign them a pre set document control number that always begins with a two letter prefix, followed by a dash and then 6 other numbers, followed by a second dash and then two more digits. (IE: XX-000000-00
This system works really well if the document you need has all of the relevant information self contained within the file. However, we are discouraged from repeating information twice in the efforts of normalization and removing the chance of conflicting information in multiple documents. Because of this, we are forced to make references between files, which the system does not support hyperlinking from within documents.
To better serve our internal customers that are growing frustrated with the system (and therefore relying on intuition and old documents to perform detailed work instructions) I am pursuing an intranet site where everything is interlinked within a browser interface.
I would like to automate a system (via macro or any other solution that works) that:
-Parses through a document and finds references to another document
-Hyperlinks that reference to the other document based on a URL prefix and the reference ID of the document
-Saves the document in an HTML format using the reference ID as the title and file name
Simple enough? If so, please help me. The next step is to automate this to run through multiple documents.
The final piece of relevant information is that this MUST be a fully automated process, as we currently have about 5,000 documents within the company that change at a rate of about 30 to 40 a week.
Start Free Trial
