PDF to Excel Converter in Excel VBA

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

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

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

[@Josivis]

Thank you it helped me a lot extracting Data from PDF

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@piotrbyrski7095]

You are a genius!

[@PKAnExcelExpert]

Thanks🙏

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

[@hannesswart3451]

Awesome! Works perfectly thanks!

[@PKAnExcelExpert]

You're welcome!

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

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

[@prasenjitmandal5486]

Excellent Sir

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

[@kashifkhanspecial]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ibraheemmshezad400]

very nice sir it is very amazing video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MK-jn9uu]

THIS IS LIKE MAGIC! THANK YOU SO MUCH

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

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

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

[@Omshanthiom9]

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

[@pankajsinghal4590]

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

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

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

[@LoneIcon]

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

[@rapascoo]

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

[@Tat-cx1lr]

Merci beaucoup. C’est génial. Amicalement

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

[@wmnkmr]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anoopbisht1]

very useful code....thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@wkchow492]

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

[@nicolasv7549]

me too

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

[@GUSPM7]

Great, thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@ayeshasarwar615]

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

[@aceace4917]

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

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

[@thiagoleite1220]

Excellent!!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shrachichaudhary3791]

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

[@sandeshramaswamy9576]

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

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

[@rezmun]

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

[@toufiktn5347]

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

[@SD-gx7uk]

Awesome works great for me. Thank you for sharing!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Mekos1214]

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

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

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

[@bannochang]

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

[@ORANGEPICTURESOFFICIAL]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shoryaarora1464]

It’s nice 👍🏻

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shoryaarora1464]

PK: An Excel Expert always sir

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

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

[@vasavajaykar5521]

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

[@minhnguyennhat3547]

works perfectly, thanks a lottt!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@karishmachauhan7641]

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

[@rajadolisitumorang1095]

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

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

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

[@agrisreppo9001]

Thank you, you Pro Bro :D

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@ashutoshkaslikar1695]

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

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

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

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

[@parthgoswami8681]

Thank you for the code🙏🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mayurbari4346]

Pdf file ko filter laga sakte hai kya?

[@priyanthagamini3860]

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

[@satyamsharma4663]

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

[@mohamedzeed2129]

Could you please work on a VBA series for beginners

[@durgesh91tomar]

Awesome....

[@PKAnExcelExpert]

Thanks for your valuable feedback

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

[@mohdshahbax1432]

Sir where will get the file

[@MalinaC]

Nice :) Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ameerpatait2066]

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

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

[@anmoljethanandani2279]

i need to convert some files can you help me

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

[@k4b6stuff85]

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

[@rupeshhadimani894]

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

[@mallikasahana7244]

What is vba and how to.download. i m a beginner..pls assist

[@PKAnExcelExpert]

Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com

[@mallikasahana7244]

@@PKAnExcelExpert is this free sir

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

[@luismoreira9833]

Hello, I am having Run-time error '5132': Word cannot start the converter Can you give a hand with this? Thank you in advance.

[@philemonmano4929]

Can you clarify on this Error

[@ShINy_783]

Dear sir it is possible to convert PDF to txt

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

[@gbharadwaja9621]

Thank you :) This code works

[@khaledsaleh8604]

dear mr pk i want to know how can input path input file and output file

[@khaledsaleh8604]

dear mr pk i still waet you

[@pavankumar-mm7kp]

Hi Sir thank you for this code but when I run in my system. Language and format is not coming correctly

[@pavankumar-mm7kp]

Hi sir can I call u

[@hariomgupta4677]

How can create own shortcuts key in excel

[@roobjustforfun]

Dzięki wielkie:-)

[@ashwinisg7012]

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

[@Hanan_athaya]

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

[@pramodml2725]

how can I convert scanned PDF file in to excel?

[@basithyusuf5817]

Helo Sir How to Make setting Sheet first please tell me

[@anjaligoorha3180]

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

[@agk1109]

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

[@Omshanthiom9]

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

[@ravishekharsingh178]

I am not able to open pdf file word 2010. Its showing some symbol after conversion. Pls Help

[@Thunderin11]

It doesn't work in Word 2010. I tried it also and there is a problem with the encoding. But I tested with Word 2016 and it worked, although the conversion process is extremely slow.

[@velusamyd9319]

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