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?
@drlu6094 жыл бұрын
Excellent!
@PKAnExcelExpert4 жыл бұрын
Thanks for your valuable feedback
@abdulhamidalhaddadi2255 Жыл бұрын
Thank you
@PKAnExcelExpert Жыл бұрын
You're welcome
@harishsagar3443 жыл бұрын
Its working Thank you
@PKAnExcelExpert3 жыл бұрын
Most welcome
@ursvenky63945 жыл бұрын
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?
@PKAnExcelExpert5 жыл бұрын
It will work on Image data also. It will create outlook series very soon. Working on the content.
@ProviderKnowledge2 жыл бұрын
You saved me a lot of time. but, it cannot convert from Khmer Script. Please tell me how to. thanks.
@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 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.
@maddinenirajeshbabu31435 жыл бұрын
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
@PKAnExcelExpert5 жыл бұрын
Thanks for your valuable comments. I will try to make such video very soon.
@maddinenirajeshbabu31435 жыл бұрын
@@PKAnExcelExpert Thank you very much Pk
@romainserien73484 жыл бұрын
Thank you !
@PKAnExcelExpert4 жыл бұрын
You're welcome!
@super.comiczhub5 жыл бұрын
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.
@PKAnExcelExpert5 жыл бұрын
Thanks for your valuable feedback. I will definitely try to make video.
@super.comiczhub5 жыл бұрын
@@PKAnExcelExpert thank you soo much sir....
@AnnnSysCorram4 жыл бұрын
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!
@CuriousJessy2 жыл бұрын
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
@JackPeng-v9g2 жыл бұрын
Thank for your share,but I find it format will run away when PDF file have more pages
@AbhishekSingh-xo5cx4 жыл бұрын
Thanks Sir for this video. I' m facing issue while converting .JPEG file to .pdf. could you help me to proceed on this
@ak-47khandare4 жыл бұрын
महोदय, आपके वीडियो अद्भुत और बहुत जानकारीपूर्ण हैं। लेकिन क्या आप मुझे एक्सेल फाइल को प्रदान कर सकते हैं सर जी. प्लीज ..................
@PKAnExcelExpert4 жыл бұрын
Excel download link has been given in videos discretion box. Please download this excel file from there.
@nullhas3 жыл бұрын
Sir,, is there any way to convert multiple pdf files to tiff.... For scanning and upload purpose? Please.. And thank you for this work..
@vikaskumar-wr3bz5 жыл бұрын
sir i am using xl 2013. the code has stopped on the fwg line Dim wa as New word.application
@RaquelLamas5 жыл бұрын
Toppp!!! Thanks!
@PKAnExcelExpert5 жыл бұрын
Thanks for your valuable feedback
@super.comiczhub5 жыл бұрын
I am getting a run time error '5'. Invalid procedure or argument. can you tel, me what went wrong.
@diya29095 жыл бұрын
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
@Sigitbuddyprakoso4 жыл бұрын
What if the pdf to zip same with PDF to word??Can you make video pdf to zip macro in excell VBA sir???
@rkexcel26865 жыл бұрын
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
@melodylagrama98795 жыл бұрын
how can i use this vba for Ms Access sir?
@PKAnExcelExpert5 жыл бұрын
I will create video on this topic very soon
@melodylagrama98795 жыл бұрын
@@PKAnExcelExpert THANK YOU SIR
@nullhas4 жыл бұрын
Sir, I tried but getting some error regarding file Type and one word file is creating but corrupted wordings. Please help
@sdash10574 жыл бұрын
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
@medkari5 жыл бұрын
Thank
@PKAnExcelExpert5 жыл бұрын
Thanks for watching
@sridharpadhy7653 Жыл бұрын
I m getting user defined error in Dim fso as new filesystem object
@PKAnExcelExpert Жыл бұрын
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.
@hariomgupta46775 жыл бұрын
Sir plzzz make vba for pdf (scanned documents) to excel high mb pdf file
@PKAnExcelExpert5 жыл бұрын
I will create such video very soon.
@kanthvalluru54245 жыл бұрын
I'm getting compile error... Variable not declared like that
@rohinpal97525 жыл бұрын
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
@vikaskumar-wr3bz4 жыл бұрын
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"))
@khalilrahman77315 жыл бұрын
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
@PKAnExcelExpert5 жыл бұрын
Hi Khalil, In the immediate window you use use "?f.path" wherein f was the variable for file in my video.
@selvarasan.v72462 жыл бұрын
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)
@marieaguilar96504 жыл бұрын
i got an error here Set doc = wa.documents.Open(f.Path) and it says that the excel file are corrupted
@mariusfurst48983 жыл бұрын
I got the same error. Do you have a solution yet?
@vikaskumar-wr3bz4 жыл бұрын
sir please tell me solution
@hasmukhnirmal12635 жыл бұрын
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