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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.