Add-in problem

[Leslie Isaacs]

Hello All

I am running Office2000 under Windows 2000 professional.

Until recently I have been using an excel add-in without a problem, but then
on Tuesday it stopped working - whenever I load excel I get a pop-up window
headed 'Microsof Visual Basic' and the message is "Automation Error -
Unspecified Error". The options are OK or Help - but clicking Help gives no
further info at all! Clicking OK load the 'Microsof Visual Basic' window,
which, when I close it, tells me that this will stop the debugger. I am then
returned to excel, which works fine except without the add-in.

I know that the add-in file itself is OK, because many other workstations
use it with no problems. Also my registry keys look OK - same as at other
workstations where the add-in works, and my list of references match those
at the other worstations. I have uninstalled and reinstalled the add-in a
number of times, same result.

The "Automation Error - Unspecified Error" message error occurs at the
follwing times:

at the very end of running the installation of the add-in
when initially loading excel (at which time the add-in is ticked in the list
under tools > addins
when I click on Tools > Synergy Reporting Path (this appears as the first
item under tools)
when I click OK after deselecting the add-in (in the list under tools >
addins)

Having deselected the add-in, excel works fine.

I hope someone can suggest what the problem might be - it's got me (and more
significantly the author of the add-in) stumped!

Many thanks
Leslie Isaacs

[Jan Karel Pieterse]

Hi Leslie,

No real idea's, except this one:

Try cleaning out your temp folder. Excel stores a temporary file for each
control used on a worksheet. Those files sometimes get corrupt, causing
trouble with one file on just one single machine.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com


> Until recently I have been using an excel add-in without a problem, but then
> on Tuesday it stopped working - whenever I load excel I get a pop-up window
> headed 'Microsof Visual Basic' and the message is "Automation Error -
> Unspecified Error". The options are OK or Help - but clicking Help gives no
> further info at all! Clicking OK load the 'Microsof Visual Basic' window,
> which, when I close it, tells me that this will stop the debugger. I am then
> returned to excel, which works fine except without the add-in.
>
> I know that the add-in file itself is OK, because many other workstations
> use it with no problems. Also my registry keys look OK - same as at other
> workstations where the add-in works, and my list of references match those
> at the other worstations. I have uninstalled and reinstalled the add-in a
> number of times, same result.
>
> The "Automation Error - Unspecified Error" message error occurs at the
> follwing times:
>
> at the very end of running the installation of the add-in
> when initially loading excel (at which time the add-in is ticked in the list
> under tools > addins
> when I click on Tools > Synergy Reporting Path (this appears as the first
> item under tools)
> when I click OK after deselecting the add-in (in the list under tools >
> addins)
>
> Having deselected the add-in, excel works fine.
>
> I hope someone can suggest what the problem might be - it's got me (and more
> significantly the author of the add-in) stumped!
>
> Many thanks
> Leslie Isaacs
>

[RB Smissaert]

My guess is that this has to do with the references in that add-in.
I would run Regsvr32 on all the references under Tools, References in that
project, except
the Excel reference.
The main possible culprit is probably comdlg32.ocx if that is referenced.

If that fails to solve it I would replace the actual files one by one with
files from a machine
where it works fine. Make sure you get the right version.
Again I would start with comdlg32.ocx if that is indeed referenced.

RBS


"Leslie Isaacs" <[email protected]> wrote in message
news:O8%[email protected]...
> Hello All
>
> I am running Office2000 under Windows 2000 professional.
>
> Until recently I have been using an excel add-in without a problem, but
> then
> on Tuesday it stopped working - whenever I load excel I get a pop-up
> window
> headed 'Microsof Visual Basic' and the message is "Automation Error -
> Unspecified Error". The options are OK or Help - but clicking Help gives
> no
> further info at all! Clicking OK load the 'Microsof Visual Basic' window,
> which, when I close it, tells me that this will stop the debugger. I am
> then
> returned to excel, which works fine except without the add-in.
>
> I know that the add-in file itself is OK, because many other workstations
> use it with no problems. Also my registry keys look OK - same as at other
> workstations where the add-in works, and my list of references match those
> at the other worstations. I have uninstalled and reinstalled the add-in a
> number of times, same result.
>
> The "Automation Error - Unspecified Error" message error occurs at the
> follwing times:
>
> at the very end of running the installation of the add-in
> when initially loading excel (at which time the add-in is ticked in the
> list
> under tools > addins
> when I click on Tools > Synergy Reporting Path (this appears as the first
> item under tools)
> when I click OK after deselecting the add-in (in the list under tools >
> addins)
>
> Having deselected the add-in, excel works fine.
>
> I hope someone can suggest what the problem might be - it's got me (and
> more
> significantly the author of the add-in) stumped!
>
> Many thanks
> Leslie Isaacs
>
>