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

[@mohamedel-hanfy9140]

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

[@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

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

[@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

[@sankarganeshk23]

Definitely you are 💯% genius in Excel

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MK-jn9uu]

THIS IS LIKE MAGIC! THANK YOU SO MUCH

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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!!!

[@Josivis]

Thank you it helped me a lot extracting Data from PDF

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

[@hannesswart3451]

Awesome! Works perfectly thanks!

[@PKAnExcelExpert]

You're welcome!

[@wmnkmr]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kashifkhanspecial]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@piotrbyrski7095]

You are a genius!

[@PKAnExcelExpert]

Thanks🙏

[@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

[@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

[@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?

[@SD-gx7uk]

Awesome works great for me. Thank you for sharing!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rapascoo]

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

[@GUSPM7]

Great, thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@bannochang]

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

[@minhnguyennhat3547]

works perfectly, thanks a lottt!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@prasenjitmandal5486]

Excellent Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pankajsinghal4590]

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

[@agrisreppo9001]

Thank you, you Pro Bro :D

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Tat-cx1lr]

Merci beaucoup. C’est génial. Amicalement

[@thiagoleite1220]

Excellent!!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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)",

[@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

[@LoneIcon]

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

[@toufiktn5347]

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

[@rezmun]

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

[@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

[@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?

[@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

[@sandeshramaswamy9576]

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

[@wkchow492]

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

[@nicolasv7549]

me too

[@rajadolisitumorang1095]

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

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

[@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

[@parthgoswami8681]

Thank you for the code🙏🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@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?

[@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

[@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,

[@gbharadwaja9621]

Thank you :) This code works

[@MalinaC]

Nice :) Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@roobjustforfun]

Dzięki wielkie:-)

[@shoryaarora1464]

It’s nice 👍🏻

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shoryaarora1464]

PK: An Excel Expert always sir

[@mohamedzeed2129]

Could you please work on a VBA series for beginners

[@mayurbari4346]

Pdf file ko filter laga sakte hai kya?

[@ayeshasarwar615]

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

[@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?

[@shrachichaudhary3791]

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

[@karishmachauhan7641]

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

[@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?

[@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")"

[@priyanthagamini3860]

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

[@anjaligoorha3180]

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

[@Hanan_athaya]

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

[@vasavajaykar5521]

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

[@nicolasv7549]

run time error 9, could u pls help?

[@smf4399]

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

[@durgesh91tomar]

Awesome....

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@jenimerlin1907]

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

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

[@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

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

[@ParadiseRS1234]

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

[@apurvamaheshwari8025]

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

[@Anmoljeevan1819]

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

[@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"

[@ashutoshkaslikar1695]

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

[@ameerpatait2066]

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

[@anmoljethanandani2279]

i need to convert some files can you help me

[@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

[@k4b6stuff85]

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

[@ashwinisg7012]

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

[@ShINy_783]

Dear sir it is possible to convert PDF to txt

[@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?

[@nidnac1]

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

[@raghavendrayemineni55]

Please send that PDF_excel converter workbook which you have developed

[@PKAnExcelExpert]

Download link has been given in videos discretion box. Please download this excel file from there

[@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

[@rupeshhadimani894]

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

[@SKS_learn]

Hi dear, is there any opportunity so you can share files also with us

[@PKAnExcelExpert]

File download link has been given in videos discretion box. Please download this excel file from there.

[@basithyusuf5817]

Helo Sir How to Make setting Sheet first please tell me

[@aravindanu9998]

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

[@Uday123ch]

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

[@agk1109]

Hello sir, I am getting this error ,i m not clear about it. Set fo = fso.GetFolder(pdf_path)

[@fishfoot123]

Hi, have you got the solution for this..?

[@velusamyd9319]

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