Convert from PDF to Excel with macro

[abjac]

HI I have been reading so much about this and tried so many codes, but its like its not working always come up with an error. I need convert a pdf file to excel sheet with a macro. So i hope some have a solution would be really nice if it can be uploaded in a file here. I have attached a test pdf file. My Path for the file are.
C:\Users\IBM_ADMIN\Desktop\Test.pdf

My path to adobe reader is
C:\Program Files (x86)\Adobe\Reader 11.0\Reader\AcroRd32.exe

I have really tried so many macroes uploaded but none are working. So if some have a solution with my test pdf and my version of adobe, it will really be great.-

Below you can see some of the codes i have tried but not working. The first open the pdf file but it paste the macro code into the excel sheet.

So none of them are working.

Please have a look and maybe upload a sheet which are working. Would actually be very good with a openfile dialog for the pdf file. But have a look please.

Thanks in advance

Abjac

My Not working codes.

Please Login or Register  to view this content.

[6StringJazzer]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[abjac]

HI I actually know this. But in some weird way it did not show when i wanted to do it. I even tried also in mozilla and it was the same. So i dont know if some error in the home page.

Thanks

Just tried again and this option dont come up, which it normally have done before.

OK tried on my home pc now it was working. So thanks its done correctly now.

Abjac

HI i have cross posted it here because of no answers. Thanks

http://www.mrexcel.com/forum/excel-q...cel-macro.html