Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Find Dialog (All)

    When you do an Application.GetOpenFileName or Application.Dialogs(xlDialogFindFile).Show, there is a Tools drop-down in the upper-right that contains a Find... selection. When Find... is selected, another Find Dialog box is displayed. Is it possible (1) to display this dialog directly, (2) add a hook procedure to this dialog box? TIA --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Find Dialog (All)

    In Excel 2002 and 2003, Application.Dialogs(xlDialogSearch).Show activates the Advanced Search task pane which has more or less the same functionality. But how to use it is not documented.

    The Application.FileSearch object lets you search for files using code. It has been discontinued in Office 2007, however.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •