Hi programmers
I am a project manager who has to deliver an important project for my client here in UK. The project is to do the following:
- Business areas are to write documents to be supplied electronicaly for an external agency to inspect.
- The documents will contain a large number of hyperlinks to supporting evidence.
- The hyperlinks are to be inserted once the content has been approved by senior management
- the info will be burned to CD so relative rather than absolute pathnames will be used
- the document writers are to ensure the proposed hyperlinks are formatted differently to the other text in the document
- looking at the material there are 50 documents each containing 50 - 100 hyperlinks
Easily this project lends itself for vba. The formatting of the proposed hyperlinks (format is hyperlink word in a colour <document.doc> in red) allows vba to find and insert hyperlinks allowing my support team to check the accuruacy of the CD. The structure of the folders in which the reports and supporting materials are placed is simple and self contained - report1 should have all the supporting materials in the same folder. I need help in identifying a method for these elements:
1. A script that will read a report and copy the proposed hyperlink documents into a text file. It will then look through the reports folder (and subfolders) and produce a list of what is there also. Comparison between the two will identify missing documents and is referred back to the author
2. Once all is available - the report is scanned and the hyperlinks inserted automatically into the report. Any unresolvables are saved to a text file for when the reports are checked for hyperlink accuracy
Is there anybody that can supply assistance in the form of code or ideas as to how these two elements are achieved. I have short timescales to deliver the CD to the inspectors so all help really appreciated
Hargy
I am a project manager who has to deliver an important project for my client here in UK. The project is to do the following:
- Business areas are to write documents to be supplied electronicaly for an external agency to inspect.
- The documents will contain a large number of hyperlinks to supporting evidence.
- The hyperlinks are to be inserted once the content has been approved by senior management
- the info will be burned to CD so relative rather than absolute pathnames will be used
- the document writers are to ensure the proposed hyperlinks are formatted differently to the other text in the document
- looking at the material there are 50 documents each containing 50 - 100 hyperlinks
Easily this project lends itself for vba. The formatting of the proposed hyperlinks (format is hyperlink word in a colour <document.doc> in red) allows vba to find and insert hyperlinks allowing my support team to check the accuruacy of the CD. The structure of the folders in which the reports and supporting materials are placed is simple and self contained - report1 should have all the supporting materials in the same folder. I need help in identifying a method for these elements:
1. A script that will read a report and copy the proposed hyperlink documents into a text file. It will then look through the reports folder (and subfolders) and produce a list of what is there also. Comparison between the two will identify missing documents and is referred back to the author
2. Once all is available - the report is scanned and the hyperlinks inserted automatically into the report. Any unresolvables are saved to a text file for when the reports are checked for hyperlink accuracy
Is there anybody that can supply assistance in the form of code or ideas as to how these two elements are achieved. I have short timescales to deliver the CD to the inspectors so all help really appreciated
Hargy