ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Standard "Open" and "Save As" Buttons (https://www.excelbanter.com/excel-programming/308732-standard-open-save-buttons.html)

Paulo de Arruda Borelli[_2_]

Standard "Open" and "Save As" Buttons
 
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[_2_]

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.





Kurt[_6_]

Standard "Open" and "Save As" Buttons
 
Check out this link:

http://www.bmsltd.ie/DLCount/DLCount...eForFolder.zip

"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.






All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com