Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Hawaii
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    wdDialogMailMergeOpenDataSource (2000/SP-3)

    I would like to limit the filetype to "*.xls" when using the Dialogs collection to open a wdDialogMailMergeOpenDataSource option. I have tried the following, to no avail:

    With Dialogs(wdDialogMailMergeOpenDataSource)
    .Name = "*.xls"
    .Show
    End With

    I am using this in Autonew in a template.

    Please help.

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: wdDialogMailMergeOpenDataSource (2000/SP-3)

    If you don't find anything better, you might find this to be reliable 95% of the time:

    With Dialogs(wdDialogMailMergeOpenDataSource)
    SendKeys "*.xls{ENTER}"
    .Show
    End With

Posting Permissions

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