Standard open/save file forms in VBA

[shankar]

Are there standard functions in VBA which essentially perform the standard open/save file functions through user forms (as shown in the attached screenshot) and enable any file to be opened/saved from within VBA?

I don't want to reinvent the wheel in terms of implementing these user forms.

Thanks.

Shankar

[Bob Phillips]

Look at GetOpenFilename and GetSaveAsFilename in VBA help.

[shankar]

Thanks! That worked.

[RolfJ]

You can use the Show method of the Application.Dialogs property to show almost any of the Excel-intrinsic dialogs using VBA, e.g.

[vba]
Application.Dialogs(xlDialogOpen).Show
[/vba]

Check out http://msdn.microsoft.com/en-us/libr...ffice.11).aspx for more details.