Excel VBA to convert files to PDF

[Anandpersad]

Hi All,

I am new to VBA and looking for help. This macro will save me lots of time daily.

In excel 2013, I would like to create the following VBA.
In Cell “A1” I have written of the directory where all the files are saved.
I am now looking for a macro, which open the directory as mentioned in cell “A1”.

Let say the directory mentioned in cell A1 is: U:\Testing Macro\Macro testing
Now on that particular directory, I would like to convert the: *.xlsx; *xls; *.docx; *.doc; *.png and *.jpeg files to .pdf
The converted files should be saved on the same directory and with the same name, only now as a PDF file
I googled a lot and read a lot but cannot find this VBA.

Please please help me out here.

Thanks and regards,

Anand