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

    Automation (2000/SR-1)

    I am using GetObject() to open a Word document for processing. What I'd like to do is disable Word's enable/disable macro prompt at startup.

    Each time I make the GetObject() call, Word start's and before it opens the document, Word displays the "Would you like to disable macros" prompt.

    Any ideas?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Automation (2000/SR-1)

    Are you opening a document that contains macros?

    If you turn your Word security settings to "Low" you won't get the warning - but you probably don't want low security.
    Regards
    John



  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, UK, Berkshire, England
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automation (2000/SR-1)

    If I create a Word object I don't get the warning about macros, but my security level is set to Medium. Are you getting the warning when you create the Word object, or when you try to create a document - wondering if your Normal.dot has macro's ?

  4. #4
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automation (2000/SR-1)

    It sounds like there may be some macros in one of your startup templates (Normal.dot or a template in your startup directories).

    I open Word and Word Docs from Access all the time and the docs have macros and I have yet to get that prompt.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

Posting Permissions

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