Consulting

Results 1 to 2 of 2

Thread: Fix to 'ClassFactory cannot supply requested class' Error

  1. #1
    VBAX Newbie
    Joined
    Mar 2007
    Posts
    1
    Location

    Fix to 'ClassFactory cannot supply requested class' Error

    I had written a VBA routine to create Word Documents from an Excel Spreadsheet. When executing the CreateObject("Word.Application") statement, the routine aborted with the following error:

    Run-time error '-2147221231 (800440111)':

    Automation error

    ClassFactory cannot supply requested class

    ... This just about ruined my morning... after much searching, I found an obscure reference on microsoft.public.access. There is a registry key that is set by some versions of Norton Anti-virus.

    [HKEY_CLASSES_ROOT\CLSID\{000209FF-0000-0000-C000-000000000046}\InProcServer
    32]
    (Default)="C:\\Program Files\\Common Files\\Symantec Shared\\Script
    Blocking\\ScrBlock.dll"

    Once this key is deleted, the problem goes away.

    May not help everyone, but it worked for me!!

  2. #2
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,488
    Location
    Thanks Curry
    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'

Posting Permissions

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