Hi Pk Thanks in advance Could you please tell excel to ppt based on Excel data that data I will choose from drop down list different types of charts I will select any kind chart or table in that drop down it when running the that input data convert to chart or table paste into power point
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 Word 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.e shown after hitting F8, and showing Run-time error '5' invalid procedure call or argument, End debug, help. 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.
Hi, thanks for you help!! but im getting a run time error '' 9 '' in the line Set sh = ThisWorkbook.Sheets("Sheet1") Could you guide me how to fix it or what is the error, Greetings from Chile!
Sir when I converting the file and opening the ms word file one pop is opening that the office open XML file can not be opened because there are problems with the contents...please resolve my problem sir...while VBA coding SAVEAS2 is not showing only save as is showing in my VBA
In your case, it seems that the "FileSystemObject" object is not properly declared or referenced. This object is part of the Microsoft Scripting Runtime library, which needs to be added as a reference in your VBA project. To add the reference, follow these steps: 1-Open the VBA Editor in Excel by pressing Alt + F11. 2-Click on Tools in the menu bar, then select References. 3-In the References window, scroll down and look for "Microsoft Scripting Runtime" in the list. 4-Check the checkbox next to "Microsoft Scripting Runtime" to add the reference. 5-Click OK to close the References window.
Sir meri excel file koi bhi folder me dali he usi folder me sheet name se folder ban jaye or sheet pdf me cheng ho jaye please vba code bataiye plz plz plz sir
sir ye coding excel 2010 me work nahi kar rahi. please give solutions. the line in which error occurred is doc.SaveAs2 (word_path & "\" & Replace(f.Name, ".pdf", ".docx"))
Hi PK, Good afternoon. I have been trying to run this module to test if this work for me. When I open the immediate window to check ?.path following error msg comes up, run time error 424 Object required Can you please advise on this error? Kind regards, Khalil
Dear sir I require for How to convert Outlook Email to PDF with VBA code without any third party application(We are using Windows 7 Microsoft Office 10)
Hi sir I m flowing you since long time Can you please make one on convert to notepad to excel I have note pad data so i want to convert in excel Please
FILE PDF TO EXCEL OR WORD DONO CONVERT HO JATI HAI LEKIN CONVERT HONE KE BAD EXCEL OR WOD DONO HANG HO JATA HAI GREEN COLOUR DOT GHUMTA RAHTA HAI VBA ME LAST LINE NEXT KE BAD
Neumím anglicky, ale máte to super. Thank you.
Děkujeme za vaši zpětnou vazbu.
Thanks man you saved us hell of a time!
Thanks for your valuable feedback
You saved me a lot of time.
but, it cannot convert from Khmer Script. Please tell me how to. thanks.
Beautiful work. Thanks for the share.
Thanks for your valuable Feedback.
Excellent work
Thanks for your valuable feedback
Excellent!
Thanks for your valuable feedback
Thank for your share,but I find it format will run away when PDF file have more pages
Its working Thank you
Most welcome
Thank you
You're welcome
fantastic PDFconver word, super Thank you, friend
Most welcome🙏
sir i am using xl 2013. the code has stopped on the fwg line
Dim wa as New word.application
Hi Pk
Thanks in advance
Could you please tell excel to ppt based on Excel data that data I will choose from drop down list different types of charts I will select any kind chart or table in that drop down it when running the that input data convert to chart or table paste into power point
Thanks for your valuable comments. I will try to make such video very soon.
@@PKAnExcelExpert Thank you very much Pk
Thank you !
You're welcome!
What if the pdf doc as image data? If possible explanation please. U promised u r going to do outlook series. When can we expect pk?
It will work on Image data also. It will create outlook series very soon. Working on the content.
You saved me a lot of time, thank you so much! Would it be possible to adapt this code to convert files into folders and subfolders?
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 Word 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.e shown after hitting F8, and showing Run-time error '5' invalid procedure call or argument, End debug, help. 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.
I am getting a run time error '5'. Invalid procedure or argument. can you tel, me what went wrong.
Hi
Can you please upload a video for
Converting multiple pdf in a folder into JPG OR PNG and save in a different folder via VBA
Hi, thanks for you help!! but im getting a run time error '' 9 '' in the line
Set sh = ThisWorkbook.Sheets("Sheet1")
Could you guide me how to fix it or what is the error, Greetings from Chile!
Sir, there is a error msg in run time error 76 -path not found in
Set fo= fso.getfolder(pdf-path)
Blank word file generated
Sir, your videos are amazing and very informative. Can you help create a video on how to extract data from SAP to Excel using Excel VBA.
Thanks for your valuable feedback. I will definitely try to make video.
@@PKAnExcelExpert thank you soo much sir....
Sir,
I tried but getting some error regarding file Type and one word file is creating but corrupted wordings. Please help
Sir when I converting the file and opening the ms word file one pop is opening that the office open XML file can not be opened because there are problems with the contents...please resolve my problem sir...while VBA coding SAVEAS2 is not showing only save as is showing in my VBA
Toppp!!! Thanks!
Thanks for your valuable feedback
I'm getting compile error... Variable not declared like that
I m getting user defined error in Dim fso as new filesystem object
In your case, it seems that the "FileSystemObject" object is not properly declared or referenced. This object is part of the Microsoft Scripting Runtime library, which needs to be added as a reference in your VBA project.
To add the reference, follow these steps:
1-Open the VBA Editor in Excel by pressing Alt + F11.
2-Click on Tools in the menu bar, then select References.
3-In the References window, scroll down and look for "Microsoft Scripting Runtime" in the list.
4-Check the checkbox next to "Microsoft Scripting Runtime" to add the reference.
5-Click OK to close the References window.
Thanks Sir for this video. I' m facing issue while converting .JPEG file to .pdf. could you help me to proceed on this
Sir meri excel file koi bhi folder me dali he usi folder me sheet name se folder ban jaye or sheet pdf me cheng ho jaye please vba code bataiye plz plz plz sir
sir ye coding excel 2010 me work nahi kar rahi. please give solutions. the line in which error occurred is
doc.SaveAs2 (word_path & "\" & Replace(f.Name, ".pdf", ".docx"))
Sir,, is there any way to convert multiple pdf files to tiff.... For scanning and upload purpose? Please.. And thank you for this work..
Thank
Thanks for watching
i got an error here Set doc = wa.documents.Open(f.Path) and it says that the excel file are corrupted
I got the same error. Do you have a solution yet?
how can i use this vba for Ms Access sir?
I will create video on this topic very soon
@@PKAnExcelExpert THANK YOU SIR
What if the pdf to zip same with PDF to word??Can you make video pdf to zip macro in excell VBA sir???
Hi PK,
Good afternoon. I have been trying to run this module to test if this work for me. When I open the immediate window to check
?.path following error msg comes up,
run time error 424
Object required
Can you please advise on this error?
Kind regards,
Khalil
Hi Khalil, In the immediate window you use use "?f.path" wherein f was the variable for file in my video.
sir please tell me solution
Dear sir I require for How to convert Outlook Email to PDF with VBA code without any third party application(We are using Windows 7 Microsoft Office 10)
Sir plzzz make vba for pdf (scanned documents) to excel high mb pdf file
I will create such video very soon.
महोदय, आपके वीडियो अद्भुत और बहुत जानकारीपूर्ण हैं। लेकिन क्या आप मुझे एक्सेल फाइल को प्रदान कर सकते हैं सर जी. प्लीज ..................
Excel download link has been given in videos discretion box. Please download this excel file from there.
Hi sir
I m flowing you since long time
Can you please make one on convert to notepad to excel
I have note pad data so i want to convert in excel
Please
FILE PDF TO EXCEL OR WORD DONO CONVERT HO JATI HAI LEKIN CONVERT HONE KE BAD EXCEL OR WOD DONO HANG HO JATA HAI GREEN COLOUR DOT GHUMTA RAHTA HAI VBA ME LAST LINE NEXT KE BAD
Bullshit! Unusable file.