+ Reply to Thread
Results 1 to 3 of 3

Automation Error; Unspecified Error

  1. #1
    Registered User
    Join Date
    08-29-2012
    Location
    Oswego, NY
    MS-Off Ver
    Office 2007
    Posts
    1

    Question Automation Error; Unspecified Error

    I am havign issues with multiple users on Excel 2007. There may have been a recent update that is causing these issues.

    All of them are getting an error either when opening Excel or when working on VBA:


    Microsoft Visual Basic
    ---------------------
    Automation error
    Unspecified error


    One of my users cannot save files either; it throws an error that unfortunately I have not written down.

    Has anyone seen similar behavior and can point me in the right direction?

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    6,508

    Re: Automation Error; Unspecified Error

    Give these tips a try:
    http://www.cpearson.com/excel/StartupErrors.aspx

  3. #3
    Registered User
    Join Date
    08-30-2012
    Location
    New Mexico
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Automation Error; Unspecified Error

    I ran into this problem, and after spending a couple frustrating hours on it (!), found the cause and the fix. Turns out you need to un-register and re-register the mscomctl.ocx file.

    Here's some additional info:

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1