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:
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-m...
Laptop: amzn.to/2PlFFFz

[@demetriusoatis8474]

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!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sajidrahim4910]

how ... its not working with me

[@saikarlsass710]

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 :-).

[@JinBad09]

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! :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sardarali3737]

Please solove the error (microsoft Excel is waiting for another application to complete an OLE action) please solove this error

[@lwmoffice5499]

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

[@PKAnExcelExpert]

Most welcome🙏

[@analy5280]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@p.n.unnikrishnan6659]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sankarganeshk23]

Definitely you are 💯% genius in Excel

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mohamedel-hanfy9140]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MK-jn9uu]

THIS IS LIKE MAGIC! THANK YOU SO MUCH

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rrawat9026]

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..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rrawat9026]

@Abdallah khairy have u paste a code in VBA enabled excel... Make sure excel file extension should be ".xlsm" And reference Library should checked...

[@Josivis]

Thank you it helped me a lot extracting Data from PDF

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@131HITOMI]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@piotrbyrski7095]

You are a genius!

[@PKAnExcelExpert]

Thanks🙏

[@hannesswart3451]

Awesome! Works perfectly thanks!

[@PKAnExcelExpert]

You're welcome!

[@ankitrahaman593]

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

[@minhnguyennhat3547]

perfect thanks a lot mannnn!!!

[@kashifkhanspecial]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@wmnkmr]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ORANGEPICTURESOFFICIAL]

Thank you for accepting my request and done video. Tq u so much sir.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ibraheemmshezad400]

very nice sir it is very amazing video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@GUSPM7]

Great, thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@karmegammariappan9115]

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

[@rodrigorossi3613]

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

[@grsnoliveira77]

Boa tarde!
Deu certo o código? Funciona?
Tentei e deu erro no caminho

[@prasenjitmandal5486]

Excellent Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@angelom.9818]

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 %PDF-1.4.....%忏嫌.....4 0 obj..... 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.

[@SD-gx7uk]

Awesome works great for me. Thank you for sharing!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@DZ-fc1lo]

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?

[@Tat-cx1lr]

Merci beaucoup. C’est génial. Amicalement

[@agrisreppo9001]

Thank you, you Pro Bro :D

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@thiagoleite1220]

Excellent!!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@minhnguyennhat3547]

works perfectly, thanks a lottt!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anoopbisht1]

very useful code....thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@aceace4917]

Hi! I am encountering a problem with "Paste of object worksheet failed" for nsh.Paste. Can somebody help me please?

[@toufiktn5347]

but does not work with excel 2010 and pdf Adobe Acrobat Reader DC

[@pankajsinghal4590]

Sir, how to convert PDF to Excel without loosing formatting. Could you suggest

[@subhasisbera26]

Liked the impossible video. Thanks a lot for uploading such an instructive video. But there is one thing that is a little difficult for me to understand, that is how to do the PDF path and excel path that is showing the code such as E drive or F drive. Another thing is that it is better if the tool reference codes are separated, it is a little convenient. After giving the code the run time error is being seen. I know you may be very busy, it is better if you clear it with the reply. It would be great if you could explain a little bit please.

[@fernandomorales3864]

you found the solution?, i have a erro in the part of the code "Set nsh = nwb.Sheets(1)",

[@lucascollantes4385]

Nice Job bro!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@lucascollantes4385]

@@PKAnExcelExpert I need your help.
I was able to turn a PDF into an excel spreadsheet using its method. But in the PDF there is a header and because of this the 2 lines below the header are coming as an image. How can I adjust?

[@bradleyjohnson3624]

Awesome! Is there a way to set certain areas on the pdf to copy from? I'm trying to copy and paste from numerous pdf files that are the exact same format.

[@sudhakarb1390]

Code not Running showing massage as"Runtime error 1004 _ Microsoft Excel cannot past the data"

[@premgjakka2700]

Hello
Did u get the solution for this. If yes then pls share
Hi all
Pls anyone can help on above error

[@bannochang]

Sir , do u take any class to teach VBA . I need to learn Macro and VBA .Please let know.

[@shoryaarora1464]

It’s nice 👍🏻

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shoryaarora1464]

PK: An Excel Expert always sir

[@rapascoo]

Excellent Sir! Can I ask a question. Can the same be done through One note (desktop) as the OCR is better?

[@roobjustforfun]

Dzięki wielkie:-)

[@wkchow492]

Hello i having problem, run time error 9, subscript out of range. Kindly help on this error. Thx

[@nicolasv7549]

me too

[@gbharadwaja9621]

Thank you :) This code works

[@Pencil-drawing1214]

Hello, I would like to thank you alot for your effort, but I have a problem with the code. "Set fo = fso.GetFolder(pdf_path)
"

[@PKAnExcelExpert]

This error usually occurs when the "fso" object is not properly initialized or when the "pdf_path" variable is not set to a valid folder path

[@priyanthagamini3860]

Sir, great job, 👍 👌 👏 please explain how to rename pdf files using content in files as Invoice number, ID number ect.. vba or other methord

[@PKAnExcelExpert]

Will upload soon

[@priyanthagamini3860]

@@PKAnExcelExpert Thank Sir

[@LoneIcon]

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

[@rajadolisitumorang1095]

Sir, so it doesn't convert the scanned image into table?

[@parthgoswami8681]

Thank you for the code🙏🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@md-mohammed8455]

Sir , in my case , I have scanned PDF file ,
I want to copy specific text to excel from each page of scanned PDF/ PDF.
Text sample: xxxxx-xxx-xxx-IR-xxxxx
I know only IR is fix for each page text, before and after I don't know text, but I want complete text copy to excel.
Hope you understand sir
Thanks,

[@rezmun]

thank you for the nice work. i have a query. what is needed to convert a specific pdf not all.

[@MalinaC]

Nice :) Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sandeshramaswamy9576]

good approach.. I need to know who to extract particular table value from PDF to excel sheet.?

[@vladster8236]

Converter is working perfect, but when it gets big pdf with like 300 pages "microsoft excel is waiting for another application to complete an ole action" error appears. I've tried to do something with settings and it didn't help. Application.wait and Application.DisplayAlerts = False didn't help also.
Is there anything that I can do or these files just too big?

[@blooomoon1299]

Dear sir, Thanks for your video. (1)But it is not clear how to link my folders of input & output folders. What to change in VBA module? (2) Where to save this VBA file? please give little details.

[@priyanthagamini3860]

sir i try this but after converting data not set with original format in the excel file how solve this issu.

[@karishmachauhan7641]

But I cannot link settings sheet with created vba code can you please upload formatting video as well

[@mayurbari4346]

Pdf file ko filter laga sakte hai kya?

[@mohamedzeed2129]

Could you please work on a VBA series for beginners

[@Max-qu7pr]

nice video, do u have any idea how to convert specific sites of the pdf to excel? like if the pdf has 10 sites, but i only need 4-6 for example. ive already been struggling all day with this, but couldnt get it to work still

[@ayeshasarwar615]

What is the accuracy rate of this functionality? There are 0 errors in spellings and data conversion from pdf to text?

[@durgesh91tomar]

Awesome....

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vinodwaghmare1111]

I just want to know , How do I copy a specific text from a PDF and paste it in Excel - specific cell using VBA macros?

[@vasavajaykar5521]

Sir. Without open word file.. Can we open pdf and directly copy from pdf and past in excel? Please help sir.

[@shrachichaudhary3791]

Can we specify the page that we want to convert if it is a large PDF?

[@vasavajaykar5521]

Sir. I want to know that if it is possible that without opened we can convert pdf into excel. What will be the vbs cords for that.. Please help.. Sir

[@khengloonglim9299]

Thanks for the great tool! But it doesn't work some time when it comes to the script part of "Set fo = fso.GetFolder(pdf_path)", "Path not found" error message, my PDF did store under "C:\Users\12345\OneDrive - XXX Company\Desktop\Test", could it be due to one drive impacting the performance?

[@fishfoot123]

Same error here i have got it, have you got the solution for this...? Please share if you got the solution

[@mineshsoni6126]

Sir, you have prepared exactly what i was looking for... Thank you for your help.. But Sir.. I am facing one problem while debug, i found that it creates word doc and copy all the data of PDF file into Word doc file, but after that it shows the error of -"RUN TIME ERROR - 424 " OBJECT: REQUIRED" Can you please guide how can i resolve this issue Please guide .. Thank you.

[@sudsn1532]

Thank you for your video. However, I'm getting an "Subscript out of range (Error 9)" and the line code is on this line, "Set setting_sh = ThisWorkbook.Sheets("Setting")"

[@smf4399]

I am getting an error "Object doesn't support this property or method" . please help. Thanks!

[@jeevasankar5390]

Hi sir,
I use this file. Some file is probably convert to excel and some files not convert please support how to convert all pdf files.

[@Hanan_athaya]

why is it still a pdf file after using this VBA formula?

[@anjaligoorha3180]

Thnaks for uploading so much knowledge , could you please help me in coding to extract data from mainframe to excel via vba..

[@waisbaraki9614]

It doesn't work properly. I converted a normal PDF, not an image, and it converted to strings, not values in cells. While Adobe converter converted it totally fine, so I could use the Excel file for further analysis.

[@ParadiseRS1234]

it's not complete
how to create (start converter)

[@nicolasv7549]

run time error 9, could u pls help?

[@ashutoshkaslikar1695]

Hello I am using Excel 2013 and MS office 2010 msg occur Microsoft Excel waiting for another application to complete an OLE action

[@praveenkishor4396]

Hi ,
I am using this code but getting error in "Dim aApp As Acrobat.AcroApp" And added reference "Scripting Runtime" also ..please suggest me ....error Type "User-Defined type not defined"

[@apurvamaheshwari8025]

How to convert pdf with comments to excel using VBA? Please help urgently if possible

[@satyamsharma4663]

i m using ms2007, but its not working here , does it require 10 or 13?
need help

[@mohdshahbax1432]

Sir where will get the file

[@Anmoljeevan1819]

Hi sir how to change code if I want only the first page to be converted to excel

[@ameerpatait2066]

for me the converter giving images table, could you please solve it?

[@anmoljethanandani2279]

i need to convert some files can you help me

[@ashwinisg7012]

Hello Sir, I'm getting error in wa.Visible = True. Please help me to fix this

[@jenimerlin1907]

Can i convert image text pdf file into excel???

[@k4b6stuff85]

Hello can you also teach us how to convert scan pdf to excel please
Thank you in advance

[@Uday123ch]

its not coming properly .. Bro can you please help me out on this

[@nidnac1]

Working... But output is an image.. How to resolve this

[@basithyusuf5817]

Helo Sir How to Make setting Sheet first please tell me

[@nagavalliss]

Getting error method paste object worksheet failed. Please help

[@m.carrby8883]

I really like the explanation of this VBA project. What would be the VBA code if I want to convert a PDF file with just a specific number of columns to an excel file where the column headings may not be the same as in the PDF file? Can the source column and destination columns be determined? Looking forward for your reply.

[@piusokoh4267]

I tried running this macro on a 2016 Excel but it didn't work: error message " user- defined type not defined". For
Dim fso As New FileSystemObject

[@PKAnExcelExpert]

Make sure you have added reference "Scripting Runtime" in your VBA project

[@aperson1181]

@@PKAnExcelExpert How do you do this?

[@rupeshhadimani894]

HELLO SIR
HOW SHOULD CREATE INPUT PATH AND OUTPUT PATH IN EXCEL FILE
THANKS

[@aravindanu9998]

Showing the error "user-defined type not defined plz give the solution

[@jeganraju1372]

Good work, would you pls share the code of the same

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please download this excel file from the link given vedio's description box or visit our website Www.pk-anexcelexpert.com

[@jeganraju1372]

Iam getting an Runtime error 5 , Invalid procedure call or argument. How to get rid of this. Pls explain. Iam using MS excel 2016

[@ShINy_783]

Dear sir it is possible to convert PDF to txt

[@joycegarcia8666]

There is an error saying "Object require"

[@velusamyd9319]

Working good In newodel excel, butnot in 10, please do for that also

[@MrTosha43]

Would of been nice to see it in action.

[@PKAnExcelExpert]

Thanks.