Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2002
    Location
    Leicester, UK
    Posts
    5

    Unanswered: Open MS Word Doc Through Macro

    Hi is it possible to make a button that will open a file mad in MS word? I can make it open MS word alone - I need to open a particular document from within the DB - but no option to do so.
    I have been able to use the "run command" open URL and then select it, but that's not the best of ways.
    Cheers.

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Try:

    Dim oApp As Object

    Set oApp = CreateObject("Word.Application")
    oApp.Documents.Open "c:\MyFile.doc"
    oApp.Visible = True

    Don't forget to specify your file instead of "c:\MyFile.doc"

  3. #3
    Join Date
    Apr 2002
    Location
    Leicester, UK
    Posts
    5
    Hi, thanks for that. But I found a way to do it, and it is so simple! Will post my DB up tomorrow and get everyone's opinion on it, and find ways to improve it.
    Cheers,

Posting Permissions

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