New Forum | Previous | Next | (P-PDF) Beginners
Topic: VB Automation
Conf: (P-PDF) Beginners, Msg: 71759
Date: 9/4/2002 04:23 PM
We receive a monthly PDF pdf report of products that we must enter into a database for analysis. The source format is fixed so we must investigate options for extracting the information.
The report has 3 columns who's widths vary from page to page. I have tested various extraction plugins and am able to extract the data as text but am still required to split and import the pages individually due to the column widths not being fixed.
A preferred alternative is to highlite each page using the "Table/formatted text select tool" and from the context menu select "Save As" and save the page as RTF, this way tab chars are used as delimeters and the pages are simple to import.
I would like to code these 3 steps using VB so that the process can be automated:
1) Goto page X
2) Hilight text
3) Save highlited text as RTF
So far I have been able to open the DOC, select the correct tool and go to the required page but am not sure of how to highlite the text and save it as RTF.
Any help would be greatly appreciated.