Thread: Standard "Open" and "Save As" Buttons
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
  
Posts: 575
Default Standard "Open" and "Save As" Buttons
Paulo,

this should do it...

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

Robin Hammond
www.enhanceddatasystems.com

"Paulo de Arruda Borelli" wrote in message
...
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.




Reply With QuoteReply With Quote