xlDialogSaveAs - default file name

[bajaru]

In a macro I'm using the following text:

Application.Dialogs(xlDialogSaveAs).Show

to bring up the Save As dialog box. I'd like to suggest a file name to the user when the box pops up. Do you know if there's a way to do this?

Also - how about the path the Save As box shows?

-thanks

 

[Visions_Fugitive]

Try using the Application.GetSaveAsFileName method. The help file will tell you the exact syntax.