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.