For anyone who receives error messages when loading Excel add-ins that have worked before, especially in the context of upgrades to Office 2007, may I suggest this excellent site whch addresses the problem in details and in my case, provided the solution:

http://www.add-ins.com/how_to_repair_office.htm

It's all about deleting temporary files and using the Office repair tools.


On Friday, October 12, 2007 6:11 PM Itzi wrote:

Hi,
How do I solve this Error ?


On Friday, October 12, 2007 6:22 PM FSt wrote:

hi
what caused the error? or what were you doing when the error occured?

FSt1

"Itzik" wrote:


On Friday, October 12, 2007 6:35 PM Peo Sjoblom wrote:

LOL! Do you really want any help with this? Don't you think it would be
prudent to be a bit more forthcoming in what caused this error to appear
etc? We should bring back the people that created the Enigma to decrypt
these messages.

--


Regards,


Peo Sjoblom


"Itzik" wrote in message
...


On Friday, October 12, 2007 8:19 PM Dave Peterson wrote:

http://en.wikipedia.org/wiki/Enigma_machine



Peo Sjoblom wrote:

--

Dave Peterson


On Saturday, October 13, 2007 10:49 AM Chip Pearson wrote:

It doesn't take an Enigma machine to decrypt the error message, just a trip
to www.cpearson.com/Excel/FormatMessage.aspx. That page has some VBA code
that wraps up the API functions to get the system-defined error text for a
Windows API error number (Err.LastDLLError, not Err.Number).

Unfortunately, this particular error number is like a VBA 1004 -- it
indicates only that *something* went wrong with no clue as to *what* went
wrong. The system text for this error number is "Unspecified error". You'd
think that MS would give better, more meaningful error numbers, none of this
generic crap. An error is a Long, so you have 4 billion different values.
They could have assigned a unique error number of every single line of code
in all of Windows and still have items left over.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)



"Peo Sjoblom" wrote in message
...


On Saturday, October 13, 2007 1:07 PM Peo Sjoblom wrote:

I meant that the OP could have been more thorough in describing in which
situation the error occurred


--

Regards,

Peo Sjoblom


On Saturday, October 13, 2007 4:48 PM Itzi wrote:

Hi ,

I put all steps, but I see that the title only posted.
I have ab add-in that I use many years. When I start it I get the Error.
"System Error &H80004005 (-2147467259)"
When clicking the help I see :
Excel Developer Home Visio Visio 2007 Automation Reference Visual
Basic for Applications Language Reference Visual Basic Language Reference
Error Messages
System error 'item'

After clicking ok I get :
"Out of memory"
Again help and :
Excel Developer Home Visio Visio 2007 Automation Reference Visual
Basic for Applications Language Reference Visual Basic Language Reference
Error Messages "Out of memory (Error 7)"
I spoke to the programer and said that it works ok in Excel 2007.

Hope it is clear now.

Please help.

itzik

"Peo Sjoblom" wrote: