S
scribe
Hi All,
Backround on me: first post (Howdy do!) and many years of computing experience. Have worked with Word macros and scripts before, but it's been a little while.
Software: MS-Word 2000
What I'm trying to do: We receive a file that is in RTF and contains account, name and address information. This file averages 65-75 pages daily. Current procedure is to print entire file, do an eyeball search for the records that don't match, and update our file with new information. There does not appear to be a way to fully automate this due to the software we are using and the capabilities of the people involved. My thought was if we can't automate the entire process, at least automate the matching process and limit the print-out to only those entries requiring action - saving time, toner and paper. The report is so long that it is usually printed out and put into a box with the idea that it will be gotten to when all the other work is done - which is not very often.
The report has headers and footers - easy part already am getting rid of those.
Each set of data to match is on two lines. The first line contains what we had for information and the second line contains 'corrected information' with the first two fields being replaced with one long tab. The tab stops on the two lines are set differently. Often their information and ours matches. These are the ones I want to get rid of. The problem is that while the information to be compared appears on the same place on the printed page, within Word there are two fields at the end of line 1 where there may be 1, both or none listed for each entry and another field often has extraneous tabs in it.
Here's the question: Is there a way to snag the pieces of info to be compared using some sort of function that relies on the ruler? For example, piece one to compare runs from point A to point B on the ruler; piece two runs from point B+1 to point C, piece three runs from point C+1 to D, and piece four runs from point D+1 to E. A, B, C, D, and E would remain constant every time this file is checked. Can I define in the program/macro what unit of measure to use to eliminate the differences in user preferences?
Any ideas?
regards,
scribe
Backround on me: first post (Howdy do!) and many years of computing experience. Have worked with Word macros and scripts before, but it's been a little while.
Software: MS-Word 2000
What I'm trying to do: We receive a file that is in RTF and contains account, name and address information. This file averages 65-75 pages daily. Current procedure is to print entire file, do an eyeball search for the records that don't match, and update our file with new information. There does not appear to be a way to fully automate this due to the software we are using and the capabilities of the people involved. My thought was if we can't automate the entire process, at least automate the matching process and limit the print-out to only those entries requiring action - saving time, toner and paper. The report is so long that it is usually printed out and put into a box with the idea that it will be gotten to when all the other work is done - which is not very often.
The report has headers and footers - easy part already am getting rid of those.
Each set of data to match is on two lines. The first line contains what we had for information and the second line contains 'corrected information' with the first two fields being replaced with one long tab. The tab stops on the two lines are set differently. Often their information and ours matches. These are the ones I want to get rid of. The problem is that while the information to be compared appears on the same place on the printed page, within Word there are two fields at the end of line 1 where there may be 1, both or none listed for each entry and another field often has extraneous tabs in it.
Here's the question: Is there a way to snag the pieces of info to be compared using some sort of function that relies on the ruler? For example, piece one to compare runs from point A to point B on the ruler; piece two runs from point B+1 to point C, piece three runs from point C+1 to D, and piece four runs from point D+1 to E. A, B, C, D, and E would remain constant every time this file is checked. Can I define in the program/macro what unit of measure to use to eliminate the differences in user preferences?
Any ideas?
regards,
scribe