Consulting

Results 1 to 9 of 9

Thread: VB Macro error when exiting Outlook 2003

  1. #1

    VB Macro error when exiting Outlook 2003

    Every time I close Outlook 2003, I get the error:
    Microsoft Visual Basic
    The macros on this project arer disabled. Please refer to the online help or documentation of the host application to determine how to enable macros.

    So far I have:
    Gone to the MS web site & downloaded any patches
    Gone into About Outlook/ Disabled items - no items disabled
    Changed the Macro security - I have tried high, medium and low, with no effect

    Any ideas?


  2. #2
    VBAX Master TonyJollans's Avatar
    Joined
    May 2004
    Location
    Norfolk, England
    Posts
    2,291
    Location
    I think this may be Word rather than Outlook. Are you using Word as your editor in Outlook? If so, check to see if it - or an AddIn - is trying to do something on shutdown.
    Enjoy,
    Tony

    ---------------------------------------------------------------
    Give a man a fish and he'll eat for a day.
    Teach him how to fish and he'll sit in a boat and drink beer all day.

    I'm (slowly) building my own site: www.WordArticles.com

  3. #3
    Good shout.

    Using Word 2003.
    Tools \options \security \macro security
    - set High - Outlook exit gives the error message above
    - set Medium (which prompts macros) - message - "c:\ program files\ microsoft office \office11\ startup\f inereader6.sprint.dot" contains macros - Disable /Enable /Exit?
    - set Low - no messages

    I am a bit concerned that Ihave to leave Word 2003 with Macro Security set to Low.

  4. #4
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Hi Ernie,
    Welcome to VBAX.
    You could look at digitally signing your macros.
    http://www.vbaexpress.com/forum/arti...rticle&artid=3
    Regards
    MD
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  5. #5
    I haven't written any macros (but see what you mean if I did)..... I assume finereader6.sprint.dot is one that is installed as part of the standard Word installation.

  6. #6
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    I don't see this file as a standard word file. Looks like something from an ABBYY OCR package
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  7. #7
    VBAX Master TonyJollans's Avatar
    Joined
    May 2004
    Location
    Norfolk, England
    Posts
    2,291
    Location
    Hi Ernie,

    Before I forget my manners again, Welcome to VBAX!

    I agree completely that you don't want to have your security set to Low, but there is a way round this.

    I don't know what finereader6.sprint.dot is - it certainly isn't a standard part of Word - but if you trust it, you couls move it to a trusted location.

    There are two startup locations for global templates in Word - one in the install root directory (where your template is at the moment) which is not trusted, and one of your own (see where under Tools > Options > File Locations tab > Startup) which is trusted. Templates in the trusted area can run even when security is set to High I think.
    Enjoy,
    Tony

    ---------------------------------------------------------------
    Give a man a fish and he'll eat for a day.
    Teach him how to fish and he'll sit in a boat and drink beer all day.

    I'm (slowly) building my own site: www.WordArticles.com

  8. #8
    Thanks for the information and advice. I do have an ABBYY OCR package, which I haven't used for several months. I have chosen the easy option and de-installed it. Problem sorted (until I need to use OCR software...). I guess I could have just moved the macro file.....

    Thanks also for the welcome. My first experience on this site has been very useful!

  9. #9
    VBAX Master TonyJollans's Avatar
    Joined
    May 2004
    Location
    Norfolk, England
    Posts
    2,291
    Location
    Glad we could help!
    Enjoy,
    Tony

    ---------------------------------------------------------------
    Give a man a fish and he'll eat for a day.
    Teach him how to fish and he'll sit in a boat and drink beer all day.

    I'm (slowly) building my own site: www.WordArticles.com

Posting Permissions

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