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

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

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" wrote in message
...
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