VBA-Macro for Converting Multiple Excel files to PDF

[Morshed_Dhaka]

Hello Everyone,

I am looking for advanced VBA Macro for converting multiple excel .xlsm file into pdf files. Below is the scenario :

1. I have a folder called " January" which has 78 excel .xlsm file. Every excel file name is different in that folder. In every excel file, only 1 sheet name is common which is "SUMMARY". The rest sheets name are variable from file to file.

2. I have a macro enabled file which is Called "Convert PDF" which is outside of January folder

3. I need a macro which will be in "Convert PDF" excel file. When I run the macro, it will show a folder pick up dialog box. when I locate the folder, it will hide the "SUMMARY" sheet of every excel file & converting all the excel files into that folder into PDF file separately and save as by the original excel file name into that folder.

It will be really helpful if somebody help me to compile those codes. Thanks

 

[MARK858]

Duplicate of https://www.mrexcel.com/forum/excel...xcel-xlsm-file-into-pdf-file.html#post5016281

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.