Prompting user for filename in Excel ...

[TheBionicOrange]

Hi.

I have the following code to prompt a user to save an Excel spreadsheet (when I have finished building it !) :

Do
        fname = Application.GetSaveAsFilename
    Loop Until fname <> ""

What I need is someone to tell me how I change the default path of the SaveAs box, as it is defaulting to the 'My Documents' folder, and I need 'S:MARGIN'.

Looking under the various properties for 'APPLICATION', but haven't found what I need yet !

Thanks.