If then statement depending on getopenfilename type

Hi Everyone,

I was hoping someone could help me out with an If - Then statement I would like to make.

I have a macro in excel that finds and replaces text in a powerpoint template. It lets me choose the file and then does the find and replace. I've made it so it lets me choose any file, so i would like to know how to phrase the if then statement to where if the person chooses a powerpoint file it goes through the macro, and if they choose a word document it will run a different set of code.
I already have the code for the powerpoint macro (in research stage for find and replace on word docs).
So the first thing it asks is what i would like to open-

Please Login or Register  to view this content.

How would I write the if then statement to look at the file type chosen so that if newfn = powerpoint it runs that macro and if its a .docx it runs a something else?

Side note: Does anyone know how to find a list of the file filters excel vba is able to run during a getopenfilename or getsaveas? I've tried googling it but cant find anything.

Thanks in advance for your help, this forum has been a great learning tool.

thanks, that helped a ton!