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
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