PDF to RTF in Access VBA

[vaughn79]

Hello,
Can anyone post VBA code for MSAccess to open a PDF file from Access
then save it out to a RTF file? I'm going to use this code to loop
through a table with 100's of paths to PDF's and save them as RTF's.

Thanks in advance for any help.

Vaughn

[Rick Wannall]

You might start at Adobe site to see if they post enough info about their
object model to tell you whether it supports that or not, and what the
operations would be. Something along this line, except that I don't know
Adobe's object model
dim aa as adobe.application
set aa = new adobe.application

(use your directory crawling loop here)
For each directory in path
for each file in directory
aa.open file
aa.????????? (maybe aa.export acFormatRTF, strMyOutputPath
next file
next directory

Obviously all this is pseudo code, big time. I don't know adobe's object
model, consants, or methods, but you're looking to do something along this
line. It'll be interesting to learn if adobe supports something like this.
It must.

Would you post back any links you find that offer details?

[Stephen Lebans]

If you need to preserve the formatting of the original PDF then you would be
better off purchasing a 3'rd party tool that converts from PDF to RTF. I
must note that I have not yet found a converter that is 100% accurate in the
conversion process.

If you simply need the plain text of the PDF document then you can purchase
a VB compatible PDF Library or even an ActiveX control that exposes methods
to access the text of the PDF doc.

A Web search will yield a host of solutions from third party vendors. If you
decide to use an ActiveX control make the sure the vendor affirms that the
control will work on a Access form.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
<va******@msn.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...

Hello,
Can anyone post VBA code for MSAccess to open a PDF file from Access
then save it out to a RTF file? I'm going to use this code to loop
through a table with 100's of paths to PDF's and save them as RTF's.

Thanks in advance for any help.

Vaughn

[vaughn79]

Rick Wannall wrote:

You might start at Adobe site to see if they post enough info about their
object model to tell you whether it supports that or not, and what the
operations would be. Something along this line, except that I don't know
Adobe's object model
dim aa as adobe.application
set aa = new adobe.application

(use your directory crawling loop here)
For each directory in path
for each file in directory
aa.open file
aa.????????? (maybe aa.export acFormatRTF, strMyOutputPath
next file
next directory

Obviously all this is pseudo code, big time. I don't know adobe's object
model, consants, or methods, but you're looking to do something along this
line. It'll be interesting to learn if adobe supports something like this.
It must.

Would you post back any links you find that offer details?

Thanks for your response. I'm getting pretty close to what you
referenced above. It has been a pain working with Adobe's methods and
properties. Once I have it 100% I'll post it on here.

[Rick Wannall]

That would be great.