| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Mar | May » | |||||
| 1 | 2 | |||||
| 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| 17 | 18 | 19 | 20 | 21 | 22 | 23 |
| 24 | 25 | 26 | 27 | 28 | 29 | 30 |
Excel allows us to get hold of many builtin dialogs via it's object model. For example:
Sub OpenDialog()
Application.Dialogs(xlDialogOpen).Show
End Sub
Shows the open file dialog. More infomation can be found here:
http://support.microsoft.com/?kbid=213371#E6ACAAA
A lot of the time, what Excel is doing is using API layers to get hold of these diologs (i.e. the common dialogs), it then allows [...]