PDF to Excel Converter in Excel VBA

#PDFtoExcel #VBA
Hello Friends,
In this video, you will learn how to create a PDF to Excel converter using Excel VBA.

Click here to download the practice file:

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

************* Suggested Books *********

************* My Stuff ****************

[saikarlsass]

Hello Sir,


all I can say is that your solution is much better than the most commercial pdf converter on the internet. Most of them converting information using more than one cell or the do use connected cells. Your convertion use always one cell, an that is what I need to have.
Thank you, you are really an expert :-).

[demetriusoatis]

This tool is a LIFE SAVER!!!!. I was burdened to convert signed PDFs into excel...easier said than done. Until now! Thank you. Thank you. Thank you!

[JinBad]

OMG blown away with this! Excellent! I am getting messages saying "Waiting for OLE in WORD" So I have to click "Switch" at the prompt..however the automated conversion worked! I am so impressed! :)

[lwmoffice]

Thanks PK!! this VBA so amazing... almost like OCR and imprint into excel table nicely and properly! Appreciate the sharing!

[ankitrahaman]

Thanks a lot...It works like magic :)


Just as an edit to your code.. I would like to mention that in order to make this work seemlessly without opening the Word application..in the code..change these lines.


wa.Visible = False


doc.Close True
nwb.Close True

[rrawat]

Thanks for sharing such a helpful code.. I was searching this for a long time and I thought.. It's not possible.. Through VBA.. And ur code is working like a charm.. Thanks again..

[mohamedel-hanfy]

What you did is great, creative. All respect for you from Egypt

[p.n.unnikrishnan]

It is wonderful. Thanks for your efforts and skill in explaining. god bless you.

[analy]

Thank you for always making videos about excel. All your videos were awesome and such a BIG help to me.

[Josivis]

Thank you it helped me a lot extracting Data from PDF

[HITOMI]

Thank you SO MUCH! this is really helpful to improve my tasks. also its good to learn for me. Thanks!

[Tat-cxlr]

Merci beaucoup. C’est génial. Amicalement

[ibraheemmshezad]

very nice sir it is very amazing video

[DZ-fclo]

That was very clear. Even a person who don't know coding like me also be able to understand. Can u share video on how to extract image format pdf to excel?

[angelom.]

Thank you for your generosity in sharing these codes in your channel. Congratulations. By any reason I unknow the converted xlsx file has a lot of chinese chars begining with 0 and so on. I tried to uncomment the lines you replace but I did not succed. Searching the net I found that it is concerning to a UTF-8 converting or something like that. Do you have any idea how this can be solved? Thanks again.

[karmegammariappan]

Hi, Macro is working but output is not readable and format also not match with original pdf file.

[rodrigorossi]

Show de bola.
Me ajudou muito...
Seus vídeos estão ajudando até o Brasil.
Valew....

[kashifkhanspecial]

very very good just awesome trick.. Thank you very much for this trick

[wmnkmr]

Great tutorial, very helpful! This is exactly what I needed! Thanks

[LoneIcon]

Thanks...
But i wonder how does it look inside the Excel after converting from PDF -> XLSX