I cannot express enough kudos to such a precisely perfect code. It worked like a charm, not only working with the long file path on a cloud drive, but exactly naming the output PDFs to the exact names set in the bottom of the Excel Workbook. Two things that perhaps was not clearly stated, or I did not hear - 1) The file perhaps needs to be saved as a Macro, given the VBA script running (I am no coder but I just think that is needed), and 2) At the top of the VBA window, "Option Explicit" appeared to be pre-entered in your version, and not in mine, so, I had to type that in. Very useful in the end. THANK YOU Mr. Takyar. You obviously are excellent in your field.
The 'Option Explicit' is entered automatically when you insert a module. For that, you select 'Tools', 'Options...' and finally check the option 'Require Variable Declaration' in the Visual Basic Editor (VBE). As the option name suggests, the VBE editor warns the user if he forgets to declare a used variable.
Thank you thank you thank you! So easy and straightforward. I know nothing of Visual Basic. As I added the code, I wasn’t expecting it to actually work. I for sure thought I would get some error. But it worked!! Thank you again sir!
Hi Dinesh, I got so excited about your video as your code can help me a lot. However, I keep getting the 1004 runtime error. Tried to fix settings etc. as per online advice, but still not working. The error seems to be pointing to the ws. Selection line and says "method select worksheet failed". Do you perhaps have any tips on how to resolve this?
Hi, I wrote the same code you wrote but I get for every pdf the same content which correspond to the open sheet. Do you know where the error comes from?
Hi sir, Can you please make video for sending emails from outlook vba with body of content from word file? ( which contain the signature format as well)
it's good lesson but i suggest if i choose specific sheets maybe i have 10 sheets i would choose sheet2 ,4,6 i know way to do that by array but i don't find it practical , in my mind do that by use tool inputbox where i can get in into input box for instance sheet2 & 4 & 6 it export one time to multiple files i hope to take my suggestion seriously
@@Exceltrainingvideos I would be very interested in understanding how to create only certain worksheets as Abdel-Fattah mentions.. I also would be interested to see how I could use an in-excel recipient list and email subject list for each worksheet. This would mean colleagues not able to use VBA could still easily maintain the process if email addresses changed. Hopefully that makes sense.
Dear sir, can we merge two separate sheets in different excel workbook with Same sheet name into one pdf? Eg: workbook 1 has sheets, a,b,c and workbook 2 has sheets, a,b,c. So we get three pdfs with both workbook data.
How about merging the data first and then converting to three different PDFs? These VBA tutorials will guide: www.exceltrainingvideos.com/how-to-consolidate-data-from-multiple-excel-workbooks-using-vba/ www.exceltrainingvideos.com/how-to-compare-and-merge-multiple-workbooks-to-create-a-master-file/ www.exceltrainingvideos.com/tag/merge-data-from-worksheets-into-master-worksheet-automatically-with-vba/ www.exceltrainingvideos.com/tag/create-summary-sheet-from-multiple-workbooks-with-vba/ For more tutorials relevant to your query please search: www.exceltrainingvideos.com
@@Exceltrainingvideos Dear sir, thank you very much for taking time and sharing the wonderful links. However, in my case two separate work books are prepared with Same worksheet names. Say for example, one is payment done to 5 vendors with payment details of cheque, NEFT or bill no., another is bills of these 5 vendors which is yet to pay... Both work books have different format or columns also rows will differ per vendor. Need to merge them and send one statement instead of two. Please guide.
Dear sir, I need some assistance, where we can take the important data from multiple sheets. then show separately with the Given text in VBA. Is it possible?
There are multiple sheets with some important datas in the selected rows and column. Example, suppose there are 3 sheets Sheet A, Sheet B, Sheet C. I need to merge the some required data from sheet A, Sheet,B and Sheet C in a single click into a new sheet with Path specified. I require this thing in VBA with single click. If required please send me the mail I'd of yours to show some more light on this issue.
These links to the relevant VBA video lessons will guide: www.exceltrainingvideos.com/tag/consolidate-data-from-multiple-worksheets-automatically/ www.exceltrainingvideos.com/automate-excel-to-pdf-and-email-pdf-document-using-vba/
I cannot express enough kudos to such a precisely perfect code. It worked like a charm, not only working with the long file path on a cloud drive, but exactly naming the output PDFs to the exact names set in the bottom of the Excel Workbook. Two things that perhaps was not clearly stated, or I did not hear - 1) The file perhaps needs to be saved as a Macro, given the VBA script running (I am no coder but I just think that is needed), and 2) At the top of the VBA window, "Option Explicit" appeared to be pre-entered in your version, and not in mine, so, I had to type that in. Very useful in the end. THANK YOU Mr. Takyar. You obviously are excellent in your field.
The 'Option Explicit' is entered automatically when you insert a module. For that, you select 'Tools', 'Options...' and finally check the option 'Require Variable Declaration' in the Visual Basic Editor (VBE).
As the option name suggests, the VBE editor warns the user if he forgets to declare a used variable.
Thank you thank you thank you! So easy and straightforward. I know nothing of Visual Basic. As I added the code, I wasn’t expecting it to actually work. I for sure thought I would get some error. But it worked!! Thank you again sir!
This code worked so well. Thank you 🙏🏾
Glad it helped!
Glad it helped!
Thank you so much! Just what I was looking for.
Glad I could help! Please share with your friends too.
Excellent - thank you so much!
You're very welcome!
Hi Dinesh, I got so excited about your video as your code can help me a lot. However, I keep getting the 1004 runtime error. Tried to fix settings etc. as per online advice, but still not working. The error seems to be pointing to the ws. Selection line and says "method select worksheet failed". Do you perhaps have any tips on how to resolve this?
Problem solved by taking the sheets to be printed into a new workbook - your code works perfectly :). Thank you!
I don’t have developer option
Thank you sir 😊
Thank you so much Sir!
Most welcome! Please share my UA-cam channel on Excel with your friends too. Thanks.
hi sir its showing compile error and syntax error please help to resolve this
Hi, I wrote the same code you wrote but I get for every pdf the same content which correspond to the open sheet. Do you know where the error comes from?
Your looping process doesn't seem to be correct. This link will help: www.exceltrainingvideos.com/convert-multiple-sheets-to-multiple-pdf-files/
Thank You So Mutch, Sir.
You are most welcome. Please share the vba video with your friends.
Dear sir,
I need some assistance,regarding excel vba copy and paste from one sheet to another sheet with gap of 2 minutes.
This VBA lesson will guide: www.exceltrainingvideos.com/how-to-follow-multiple-hyperlinks-and-extract-webpage-data/
Hello Sir,
I have tried the above procedure but am getting the error
Run time error 424
Hi sir, Can you please make video for sending emails from outlook vba with body of content from word file? ( which contain the signature format as well)
How about using mail merge?
Can we export to PDF and encrypt the PDF with password?
Sir plz tell me that
1sheet me 100 data hai usko 100 pdf me kaise convert kare ek sath
it's good lesson but i suggest if i choose specific sheets maybe i have 10 sheets i would choose sheet2 ,4,6 i know way to do that by array but i don't find it practical , in my mind do that by use tool inputbox where i can get in into input box for instance sheet2 & 4 & 6 it export one time to multiple files i hope to take my suggestion seriously
Can you make a video on this topic? Sounds interesting. Maybe you can send the file to takyardinesh@gmail.com
@@Exceltrainingvideos I would be very interested in understanding how to create only certain worksheets as Abdel-Fattah mentions.. I also would be interested to see how I could use an in-excel recipient list and email subject list for each worksheet. This would mean colleagues not able to use VBA could still easily maintain the process if email addresses changed. Hopefully that makes sense.
Hi, Did you ever find & make an instruction for this? This is exactly what I'm trying to do.
Dear sir, can we merge two separate sheets in different excel workbook with Same sheet name into one pdf? Eg: workbook 1 has sheets, a,b,c and workbook 2 has sheets, a,b,c. So we get three pdfs with both workbook data.
How about merging the data first and then converting to three different PDFs? These VBA tutorials will guide:
www.exceltrainingvideos.com/how-to-consolidate-data-from-multiple-excel-workbooks-using-vba/
www.exceltrainingvideos.com/how-to-compare-and-merge-multiple-workbooks-to-create-a-master-file/
www.exceltrainingvideos.com/tag/merge-data-from-worksheets-into-master-worksheet-automatically-with-vba/
www.exceltrainingvideos.com/tag/create-summary-sheet-from-multiple-workbooks-with-vba/
For more tutorials relevant to your query please search:
www.exceltrainingvideos.com
@@Exceltrainingvideos Dear sir, thank you very much for taking time and sharing the wonderful links. However, in my case two separate work books are prepared with Same worksheet names. Say for example, one is payment done to 5 vendors with payment details of cheque, NEFT or bill no., another is bills of these 5 vendors which is yet to pay... Both work books have different format or columns also rows will differ per vendor. Need to merge them and send one statement instead of two. Please guide.
Really nice
Thank you! Cheers! Please share the VBA tutorial with your friends too.
Dinesh Kumar Takyar sure Sir
Dear sir,
I need some assistance, where we can take the important data from multiple sheets. then show separately with the Given text in VBA. Is it possible?
Please elaborate.
There are multiple sheets with some important datas in the selected rows and column. Example, suppose there are 3 sheets Sheet A, Sheet B, Sheet C. I need to merge the some required data from sheet A, Sheet,B and Sheet C in a single click into a new sheet with Path specified. I require this thing in VBA with single click. If required please send me the mail I'd of yours to show some more light on this issue.
sir, while export as pdf- run time error 438- showing(object doesn't support this property or method) . kindly guide me...
Check your code again. This VBA tutorial link will help: www.exceltrainingvideos.com/tag/convert-multiple-sheets-to-multiple-pdf-files-with-vba/
@@Exceltrainingvideos THANKS SIR GOT IT
How to adapt this code so it works on mac?
www.rondebruin.nl/mac.htm
Runtime error, have checked code twice,
Object defined error
This link will guide: www.exceltrainingvideos.com/tag/convert-multiple-sheets-to-multiple-pdf-files-with-vba/
Hi sir could show me how to convert excel sheets in to HTML files or pdfs to Html
Will work on this suggestion.
Sir it's not work in excel 2007
Great
Glad you found the VBA tutorial helpful. Please share with your friends too.
I ran this code on Mac and it decided to print instead of creating PDFs. I understand Mac less and less everyday.
Sir, How to get all sheets in single PDF.
These links to the relevant VBA video lessons will guide:
www.exceltrainingvideos.com/tag/consolidate-data-from-multiple-worksheets-automatically/
www.exceltrainingvideos.com/automate-excel-to-pdf-and-email-pdf-document-using-vba/
@@Exceltrainingvideos Thanks Sir, my so many friends have become your fan....