How can I call the microsoft 'Save As' box from VBA in an excel macro? Using a userform I can get the user to specify a file name, but that's messy and the whole macro wouldbe a lot cleaner if I could get the Microsoft 'Save As' box to appear.
Any help greatly appreciated.
