Convert Multiple Sheets To Multiple PDF Files

[basu]

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.

[karlabruce]

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!

[dakalonekhavhambe]

This code worked so well. Thank you 🙏🏾

[ZuzanaHegerova-et]

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?

[abdel-fattahmaghari]

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

[joyce.csawyee]

Can we export to PDF and encrypt the PDF with password?

[fatmtb]

Thank you so much! Just what I was looking for.

[AkashMishra-yrpg]

Sir plz tell me that
1sheet me 100 data hai usko 100 pdf me kaise convert kare ek sath

[nitinkhtri]

hi sir its showing compile error and syntax error please help to resolve this

[DCV-ekrl]

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?

[enggsrinivas]

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)

[rayonstonui]

Hello Sir,
I have tried the above procedure but am getting the error
Run time error 424

[arvindiyer]

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.

[modestica]

How to adapt this code so it works on mac?

[abhishekranjan]

Dear sir,
I need some assistance, regarding excel vba copy and paste from one sheet to another sheet with gap of 2 minutes.

[chanukya]

Hi sir could show me how to convert excel sheets in to HTML files or pdfs to Html

[amitbhatt]

Sir, How to get all sheets in single PDF.

[I_KevinEleven]

Runtime error, have checked code twice,
Object defined error

[omathilcharliethomas]

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?

[sachin]

sir, while export as pdf- run time error 438- showing(object doesn't support this property or method) . kindly guide me...