PDF files & Excel using VBA


S

Saleh

hi,
my name is Saleh
My question is
I have over 100 PDF files with the same format ,I want a
VBA code that can read a specific data line in these
files say at line 100 and output the data into an EXCEL
sheet. any help

please let me know if you need more data, by the way I
have full access to these PDF files,it's just I'm trying
to find a way to utomate the work.
 
Ad

Advertisements

M

Myrna Larson

AFAIK, VBA has no commands that can interpret (i.e. "read") a PDF file. Have you searched the
Internet/Google to see if there are other translators available?
 
Ad

Advertisements

L

Lynn Schauer

Saleh,

it is possible to do this type of thing using macros and the SendKeys
statement to copy the text back to excel. If you could send me a couple of
the files I could create the macro for you for a small fee.
Lynn S - OutOfNoWare
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top