Hello guys, My question is not only for excel but also for microsfot word and microsoft powerpoint.
In a folder I have many .xlsx,.doc .docx, .rtf, .ppt, .pptx files. I need to convert all these files to PDF form. I have installed office 2010 which allows me to save files as pdf. I can also convert them(office files) by using printer(e.g cutepdf).
But I want to have a macro for each type, I should run all macros one by one and files should be converted to pdf. Pdf files should have same name as original and same directory.
In a folder I have many .xlsx,.doc .docx, .rtf, .ppt, .pptx files. I need to convert all these files to PDF form. I have installed office 2010 which allows me to save files as pdf. I can also convert them(office files) by using printer(e.g cutepdf).
But I want to have a macro for each type, I should run all macros one by one and files should be converted to pdf. Pdf files should have same name as original and same directory.
