PDF to Excel Converter in Excel VBA

Подписаться 270 тыс.

Просмотров 112 тыс.

50% 1

#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-anexcelexpert.com/pdf-...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
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-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
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-matic.com/refer/...
Laptop: amzn.to/2PlFFFz

Опубликовано:

4 авг 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 204

@saikarlsass710 4 года назад

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

@demetriusoatis8474 4 года назад

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 4 года назад

Thanks for your valuable feedback

@sajidrahim4910 11 месяцев назад

how ... its not working with me

@MK-jn9uu 4 года назад

THIS IS LIKE MAGIC! THANK YOU SO MUCH

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@JinBad09 3 года назад

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 3 года назад

Thanks for your valuable feedback

@sardarali3737 2 года назад

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

@mohamedel-hanfy9140 4 года назад

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

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@analy5280 4 года назад

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

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@rodrigorossi3613 4 года назад

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

@grsnoliveira77 2 года назад

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

@sankarganeshk23 3 года назад

Definitely you are 💯% genius in Excel

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@wmnkmr 3 года назад

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

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@Tat-cx1lr 3 года назад

Merci beaucoup. C’est génial. Amicalement

@lwmoffice5499 Год назад

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

@PKAnExcelExpert Год назад

Most welcome🙏

@Josivis 3 года назад

Thank you it helped me a lot extracting Data from PDF

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@p.n.unnikrishnan6659 3 года назад

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

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@131HITOMI 3 года назад

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

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@kashifkhanspecial 4 года назад

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

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@rrawat9026 4 года назад

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 4 года назад

Thanks for your valuable feedback

@rrawat9026 4 года назад

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

@ORANGEPICTURESOFFICIAL 4 года назад

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

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@roobjustforfun 4 года назад

Dzięki wielkie:-)

@ankitrahaman593 4 года назад

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 4 года назад

perfect thanks a lot mannnn!!!

@SD-gx7uk 4 года назад

Awesome works great for me. Thank you for sharing!

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@bradleyjohnson3624 4 года назад

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.

@hannesswart3451 2 года назад

Awesome! Works perfectly thanks!

@PKAnExcelExpert 2 года назад

You're welcome!

@DZ-fc1lo 4 года назад

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?

@minhnguyennhat3547 4 года назад

works perfectly, thanks a lottt!!!

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@piotrbyrski7095 2 года назад

You are a genius!

@PKAnExcelExpert 2 года назад

Thanks🙏

@gbharadwaja9621 4 года назад

Thank you :) This code works

@rapascoo 2 года назад

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

@Max-qu7pr 4 года назад

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 4 года назад

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

@angelom.9818 4 года назад

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.

@sandeshramaswamy9576 4 года назад

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

@thiagoleite1220 4 года назад

Excellent!!!!

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@parthgoswami8681 4 года назад

Thank you for the code🙏🙏

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@mohamedzeed2129 4 года назад

Could you please work on a VBA series for beginners

@ibraheemmshezad400 4 года назад

very nice sir it is very amazing video

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@LoneIcon 2 года назад

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

@prasenjitmandal5486 3 года назад

Excellent Sir

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@ayeshasarwar615 3 года назад

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

@anjaligoorha3180 4 года назад

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

@MalinaC 4 года назад

Nice :) Thank you!

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@GUSPM7 2 года назад

Great, thanks

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@agrisreppo9001 2 года назад

Thank you, you Pro Bro :D

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@anoopbisht1 3 года назад

very useful code....thanks

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@blooomoon1299 2 года назад

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.

@bannochang 2 года назад

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

@vasavajaykar5521 4 года назад

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

@shrachichaudhary3791 3 года назад

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

@shoryaarora1464 4 года назад

It’s nice 👍🏻

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@shoryaarora1464 4 года назад

PK: An Excel Expert always sir

@m.carrby8883 4 года назад

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.

@sudsn1532 3 года назад

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

@lucascollantes4385 4 года назад

Nice Job bro!

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@lucascollantes4385 4 года назад

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

@karmegammariappan9115 4 года назад

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

@aceace4917 3 года назад

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

@khengloonglim9299 2 года назад

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 2 года назад

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

@pankajsinghal4590 3 года назад

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

@vinodwaghmare1111 2 года назад

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?

@toufiktn5347 4 года назад

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

@durgesh91tomar 4 года назад

Awesome....

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@ashutoshkaslikar1695 3 года назад

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

@hariomgupta4677 4 года назад

How can create own shortcuts key in excel

@vasavajaykar5521 4 года назад

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

@praveenkishor4396 4 года назад

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"

@k4b6stuff85 3 года назад

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

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

@Anmoljeevan1819 4 года назад

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

@satyamsharma4663 4 года назад

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

@sidharthpattanayak1066 4 года назад

Please sir explain the code We.WholeStory

@pramodml2725 4 года назад

how can I convert scanned PDF file in to excel?

@subhasisbera26 10 месяцев назад

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 9 месяцев назад

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

@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

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

@jeevasankar5390 2 года назад

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.

@ameerpatait2066 2 года назад

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

@rajadolisitumorang1095 11 месяцев назад

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

@piusokoh4267 4 года назад

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 4 года назад

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

@aperson1181 3 года назад

@@PKAnExcelExpert How do you do this?

@rupeshhadimani894 4 года назад

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

@karishmachauhan7641 Месяц назад

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

@velusamyd9319 3 года назад

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

@vladster8236 7 месяцев назад

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?

@jenimerlin1907 2 года назад

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

@priyanthagamini3860 Год назад

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

@wkchow492 4 года назад

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

@nicolasv7549 4 года назад

me too

@smf4399 3 года назад

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

@anmoljethanandani2279 Год назад

i need to convert some files can you help me

@mohdshahbax1432 Год назад

Sir where will get the file

@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

@mayurbari4346 2 года назад

Pdf file ko filter laga sakte hai kya?

@nicolasv7549 4 года назад

run time error 9, could u pls help?

@aravindanu9998 4 года назад

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

@basithyusuf5817 2 года назад

Helo Sir How to Make setting Sheet first please tell me

@apurvamaheshwari8025 2 года назад

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

@MrTosha43 2 года назад

Would of been nice to see it in action.

@PKAnExcelExpert 2 года назад

Thanks.

@sudhakarb1390 4 года назад

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

@ShINy_783 3 года назад

Dear sir it is possible to convert PDF to txt

@juliencoquin3306 4 года назад

Bonjour, pouvez-vous communiquer le code. Merci par avance

@raghavendrayemineni55 4 года назад

Please send that PDF_excel converter workbook which you have developed

@PKAnExcelExpert 4 года назад

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

@nidnac1 4 года назад

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

@nagavalliss 3 года назад

Getting error method paste object worksheet failed. Please help

@pavankumar-mm7kp 4 года назад

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

@pavankumar-mm7kp 4 года назад

Hi sir can I call u

@jazyhappy5018 3 года назад

Can I get file