PDA

View Full Version : data fram pdf



oleg_v
04-28-2010, 01:28 AM
hi

is there a way to poll data from pdf file with vba?

thanks

Aussiebear
04-28-2010, 02:58 PM
"poll" or "pull" data?

What have you tried so far?

oleg_v
05-01-2010, 10:34 PM
hi

i need to pull data.
i tried to get file open with excel and when the data is brought to excel sheet i get jibrish.

thanks

Aussiebear
05-02-2010, 01:30 AM
What have you tried to do?

oleg_v
05-02-2010, 01:39 AM
I am trying to bring the pdf data to
excel sheet like i am doing with text file
so far not without successes.

mdmackillop
05-02-2010, 03:28 AM
I don't think scanned documents will ever work. If it is a pdf print document, there are third party applications which say they will export to text format, but unless the data layout is very simple, I would not think you'll get a usable result.

oleg_v
05-02-2010, 03:37 AM
So

if i need to pull the data out of pdf file to excel sheet.

i am stuck and need to do this manually.

mdmackillop
05-02-2010, 04:14 AM
Depending upon the third party export, you could use code to assist. Can't tell without seeing what you have.

oleg_v
05-02-2010, 04:19 AM
I understand

but i am sorry i can not post the drawing because confidentiality

i do not know what to do!

Thanks for your support


Oleg

hardlife
05-02-2010, 06:01 AM
http://www.vbaexpress.com/kb/getarticle.php?kb_id=977 (http://www.vbaexpress.com/forum/../kb/getarticle.php?kb_id=977)

sunny day :hi: