xlDialogSaveAs - default file name

bajaru · Apr 17th, 2002, 04:18 PM

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 · Apr 17th, 2002, 04:31 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 04:18 PM	#1
bajaru New Member Join Date: Apr 2002 Location: Brian Branch Posts: 1	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

Apr 17th, 2002, 04:31 PM	#2
Visions_Fugitive New Member Join Date: Apr 2002 Location: Milwaukee, WI Posts: 18	Try using the Application.GetSaveAsFileName method. The help file will tell you the exact syntax.