getsaveasfilename

[philfer]

Is there a way using the above to suggest a filename to save.



I know it is possible with Application.FileDialog(msoFileDialogSaveAs) but when I use this I cannot get the path to be a default path I want to set.



I can set the default path with GetSaveAsFilename but dont know how to fill the Dailog with a suggested filename

 

[PHV]

Press the F1 key when the cursor is inside the GetSaveAsFilename word in your code and look at the first parameter of this method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[philfer]

Sorry, got it the wrong way around!!!

I can set the path for FileDialog but not GetSaveAsFileName.

But I cant set a suggested filename with FileDialog

Thus I want to either :-

1) Find a way to give a suggested filename for FileDialog

OR

2) Find a way to set the path for GetSaveAsFileName (I have tried ChDir etc - but it wont work!)

 

[PHV]

Use a full pathname with the GetSaveAsFilename method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[philfer]

How?

 

[PHV]

Please, post your actual code with the ChDir attempt.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886