Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Sep 2001
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automation Error (XL 2002 SP2)

    I've got someone using a macro I wrote which is working fine for 180+ people but this one guy says that as soon as he double clicks on the shortcut to the .xls file that he gets "Automation Error" "Unspecified Error". This appears to be from XL itself as I have line numbers in my macro and this is not a msg box from my code.

    Where can I start looking for this? The error msg is useless in terms of helping me find the problem. Thanks MSFT for some great coding! Sheesh!

    Thanks to any of you kind folks that can offer some pointers!!

    dingo

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Automation Error (XL 2002 SP2)

    Does this Knowledgebase article, help ID the problem?

    Steve
    http://support.microsoft.com/default.aspx?...kb;en-us;186063

  3. #3
    Star Lounger
    Join Date
    Sep 2001
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automation Error (XL 2002 SP2)

    Sorta and thanks for the response.

    My problem is I don't know what section of code to put that api call in and if it will even let me intercept it since I don't know what line it was generated on. Plus there was no error number in the msgbox - just what I noted in my original msg.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automation Error (XL 2002 SP2)

    This is a default list of things-to-do when Excel exhibits startup problems.

    Try opening Excel without any addins or hidden workbooks:

    Start, Run,
    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Automation

    Quotes mandatory, Note you may have to change the path.

    If your error disappears, there is either an add-in or a (hidden) workbook that is loaded upon XL's start, which bothers you.

    - Try locating the XLSTART directory, move everything from there.
    - In XL: Tools, Addins, note the ones checked and uncheck them one at the time, each time restarting XL
    - In XL, Tools, options, general. Check if a path is entered after "Alternate startup file location". Clear it.

    Another option is to open XL in Safe mode:

    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Safe

    Also, you might try:

    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Regserver

    Yet another possible problem is a corruption of your toolbar customisation file. Locate all files with extension .xlb and rename the extension(s) to something like .old
    Now try and start XL again.

    Also, NAV has shown to cause "Excel caused an invalid page
    fault in module VBE6.DLL".
    You might try disabling the Office plug in of NAV.

    Other causes may be a full TEMP folder:

    In Windows 95/98 and ME

    Delete all files in C:WindowsTemp

    In Windows NT/2000/XP

    Find and Select Cocuments and Settings<user>local settingstemp
    and delete all files in there.

    They are often left behind by installing programs but Excel needs the space.



    This is what MS has to say about startup problems:

    http://support.microsoft.com/default.aspx?...b;en-us;Q280504

    And this about startup switches:

    http://support.microsoft.com/default.aspx?...B;en-us;q211481
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Star Lounger
    Join Date
    Sep 2001
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automation Error (XL 2002 SP2)

    MOST EXCELLENT response!

    Beaucoup and Zwanzig thanks!

    d

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automation Error (XL 2002 SP2)

    It is not a new text, it is a boilerplate answer I use for problems like these.

    If you do a search in Google groups on the sentence "Quotes mandatory, Note you may have to change the path." you get 224 hits <vbg>
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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