Standard "Open" and "Save As" Buttons

[Paulo de Arruda Borelli]

Where can I find standard "open" and "save as" buttons? I mean: when the
user clicks on them, a dialog box appears letting the user navigate through
his/her file system. I'm using Excel 2002 VBA.

Thank you
Paulo.

 

[Robin Hammond]

Paulo,

this should do it...

application.Dialogs(xlDialogSaveAs).Show
application.Dialogs(xlDialogOpen).Show

Robin Hammond
www.enhanceddatasystems.com

 

[Kurt]

Check out this link:

http://www.bmsltd.ie/DLCount/DLCount.asp?file=BrowseForFolder.zip