VBA Macro to bring file from pdf to excel

Is it possible to bring in pdf into excel using a VBA macro?
AiyshaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
You really need conversion software to this and the result is not usually very good. Able2Extract is one of the better ones.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AiyshaAuthor Commented:
To avoid third party software maybe I should import pdf to word and then to excel..write a macro to include these two steps.
0
GrahamSkanRetiredCommented:
The problem is that the objectives of .pdf, and that of .wkb  and .doc files are completely different. Pdf files are only concerned with presentation, i.e. what it looks like. Conversion to another format does not know how to respect the original format. Word and Excel does the same thing when printing, but does a dynamic conversion when actually printing, so maintaining the original source for modification, reformatting and reprinting as necessary.

I have used OCR packages to convert .pdf documents to Word where the source must have comprised a number of  tables. The result will print almost as well as the .pdf but cannot be easily used as a new data source. While the data is presented in position, it is in multiple text boxes. They are placed accurately, but are very difficult to bring back to their original table(s).
0
aikimarkCommented:
What does your PDF look like?
0
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.