PDA

View Full Version : Standard open/save file forms in VBA



shankar
11-24-2009, 01:37 AM
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
11-24-2009, 01:49 AM
Look at GetOpenFilename and GetSaveAsFilename in VBA help.

shankar
11-24-2009, 02:23 AM
Thanks! That worked.

RolfJ
11-24-2009, 02:46 PM
You can use the Show method of the Application.Dialogs property to show almost any of the Excel-intrinsic dialogs using VBA, e.g.


Application.Dialogs(xlDialogOpen).Show


Check out http://msdn.microsoft.com/en-us/library/aa196438(office.11).aspx for more details.