Hi
I have a macro in which you push a button and it automatically pops up the save as, however my problem is that I don't get to choose what type of format I want to save it as. It only gives me the option of ALL FILES.
So my code is application.saveasfile. - how can I change this so it will give me the option to save it as an excel document (give me the dropdown of choosing what type of format I want)
Thank you for your help.
Bookmarks