Your sample document is full of framed text all anchored to the same paragraph so the concept of 'in front of' is not exactly clear in vba terms. However since your content is created through automation the order of the framed paragraphs should be consistent.
Looking at the order of the content, which of these paragraphs is the variable you want to use?
EMP No.
Mr. R.P.A.S. Abeywickrama
30662
20.00
Grand Total
Does 'Grand Total' always have two spaces between the words?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|