Hi I manage to convert the file but my output is a funny character even i have included the Microsoft Scripting Runtime as shared. I am using excel 2016. Can you advise?
@@Exceltrainingvideos Hi Dinesh, I had tried the code but not able to copy the content of the footer. Sorry that I did not make myself clear in the previous posting . I had attempted the code but not successful.
Great code, but Adobe Reader throws an error complaining that it cannot find my files. I have tried several, in different locations. I am sure the paths are correct and that the files are named correctly. I am using the most up-to-date version as of today. Continuous Release Ver 2021.005.20048 / File Version 21.005.20048.43252. Do you have any suggestions? Thanks!
hi sir, thank you for your educational videos it has really helped me to make a small application for my school but right now i've one issue if you could help me with that it will really help my school a lot. - i have a form made using VBA, now before saving that data to the database i would like to print the same data using a pre-formatted page in excel how can i do that? the data from the VBA textbox should be assigned to the activex textbox in a different excel sheet of the same workbook. please let me know on this thanks.
Hello Sir, I enjoyed all your very helpful videos. May I ask if there is any chance to assign the windows navigation start sound to a button in excel when it is clicked. Thanking you in advance.
I am getting an error in the last line of macro " windows ("pdf-to-excel using send keys.xlsm").Activate" its getting highlighted in yellow what is this plz help
What you did is great, creative. All respect for you from Egypt
So nice of you! Please share the VBA idea with your buddies too.
Thanks very much sir for the information videos
Definitely a new addition to my Excel VBA toolkit! Thanks
Great to hear! Share the Excel video tutorial with your friends too.
Hi I manage to convert the file but my output is a funny character even i have included the Microsoft Scripting Runtime as shared. I am using excel 2016. Can you advise?
for 2nd step, i have an error. when i click run the excel file will crash. i didn't get the same way as yours. what happens?
Sir, many thanks to you my friend. I will definitely add the code to my bag of s/w tricks. Again, thanks
Great!
Thanks Dinesh
You're welcome! Please share the Excel VBA video with your friends too.
It will be for sure in my library. Thank you Sir
So nice of you. Please share with your friends.
Thank you very much Sir. Very helpful video. 😎🙏🏻
Glad it was helpful! Please share the Excel VBA tutorial with your friends.
Thank you for this video tutorial
You are welcome 😊
Hello sir
Thanks for sharing! It's really helpful
I am unable to convert specific pdf to excel using this program will you please guide on this?
Please search the channel for more solutions.
Sir,
Macro is working but output is not
readable and format also not match with original pdf file.
Try again
Hi Dinesh, Excellent work! I have a question. Is that possible to copy the content including the content of the footer ?
Try it out!
@@Exceltrainingvideos
Hi Dinesh, I had tried the code but not able to copy the content of the footer. Sorry that I did not make myself clear in the previous posting . I had attempted the code but not successful.
Thank you very much Sir.
Welcome! Please share with your friends too.
Great code, but Adobe Reader throws an error complaining that it cannot find my files. I have tried several, in different locations. I am sure the paths are correct and that the files are named correctly. I am using the most up-to-date version as of today. Continuous Release Ver 2021.005.20048 / File Version 21.005.20048.43252.
Do you have any suggestions? Thanks!
Thanks for sharing!
How i use late binding of FileSystemObject in this example.
Works with early binding.
@@Exceltrainingvideos
Dim obj as object
Set obj=CreateObject("Scripring.FileSystemObject")
hi sir, thank you for your educational videos it has really helped me to make a small application for my school but right now i've one issue if you could help me with that it will really help my school a lot. - i have a form made using VBA, now before saving that data to the database i would like to print the same data using a pre-formatted page in excel how can i do that? the data from the VBA textbox should be assigned to the activex textbox in a different excel sheet of the same workbook. please let me know on this thanks.
Query is not clear.
Sir I need to paste into one excel as transpose. Can I get the code alone?
These links will help:
ua-cam.com/video/-fFTW4If-Jw/v-deo.html
ua-cam.com/video/D4xLJ4Celnc/v-deo.html
Hello Sir, I enjoyed all your very helpful videos. May I ask if there is any chance to assign the windows navigation start sound to a button in excel when it is clicked. Thanking you in advance.
Yes, you can
@@Exceltrainingvideos Hi Sir, may I ask you to send the vba ?
Macro is working but output is not in text its in object.....Not in all pdf in few pdf it showing Object
What do you mean by 'output is not in text its in object'?
Thank for the video,
Sir can share VBA code for combine or merge multiple PDF files
Not available at present. You may find this link useful: pdfsam.org/
Thanks Dinesh !
You're welcome. Feel free to share the Excel VBA lesson with your friends too.
Dinesh Kumar Takyar okey Dinesh ! I have been following you for a very long time. Thank you for the very useful lessons
I am getting an error in the last line of macro " windows ("pdf-to-excel using send keys.xlsm").Activate" its getting highlighted in yellow what is this plz help
Check your filename carefully and you'll notice the error if you are using the same filename as in my code.
Can i contact you in anyway? I need to discuss and show u the error
Sir it's not working for me.. means not in good format.. please help me out on this
For very specific needs you may have to change the approach.
For very specific needs you may have to change the approach.
True, how can fix this
Not Worked In MS Office 2007
Will work if your VBA coding and references are correct.
Anyone can add Chinese subtitle? Could you help share your code to me?
Check out the description accompanying this video!
I have a problem on this line "nsh.Paste"
Check your code.
@@Exceltrainingvideos
PathToPDFFiles = "C:\exceltrainingvideos\MyPDFs\"
PathToExcelFiles = "C:\exceltrainingvideos\PDFToExcel\"
changes here only