• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 43. Building Custom Applications... > Displaying Office-Standard Dialog Bo...

Displaying Office-Standard Dialog Boxes

Word and Excel let you display, alter, and retrieve data from any of their built-in dialog boxes. (There is no comparable capability in Outlook, PowerPoint, FrontPage, or Access.) These techniques can come in handy if you just want to tweak a built-in dialog box and you don't want to go through the considerable hassle of trying to completely re-create the dialog box.

Using Built-In Excel Dialog Boxes with VBA

Say you want to write a VBA/Excel macro that displays the Open dialog box, but instead of the default list of various Excel file types, you only want to look for Web pages (those with an .htm extension). Here's how:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint