Morshed_Dhaka
New Member
- Joined
- Dec 16, 2016
- Messages
- 42
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
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
