Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Thanked 0 Times in 0 Posts

    Open Document in Macro (Office 2002)

    I have a macro made in Office 97 that still works in Office 2000. If basically open the list of files in a certain folder for the user with the *.* in filename. At that point they could scroll down and double click on the file they wanted to open. In office 2002 this macro works up to the point of listing the files, but when the user double clicks on the file they want, no file shows on the screen. Can anyone tell me what I need to put in the macro to let them open a file to their screen.

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Silicon Valley, USA
    Thanked 94 Times in 90 Posts

    Re: Open Document in Macro (Office 2002)

    Does the code look like this? If not, can you substitute this?

    Sub myFileOpen()
    ' Display File>Open... dialog filtering to all files; let user do what he/she wants to
    With Dialogs(wdDialogFileOpen)
    .Name = "*.*"
    End With
    ' Macro has no idea whether the user opened a file or not
    End Sub

Posting Permissions

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