VBA Excel: Can't show, import or export userforms (error: &H800040
 

Please, help me! I can not find where is the the information I need.

My problem is:
I had Windows 2000 and Office 2000.
Now they installed Windows XP and Office 2000 (serv.pack 3).
And my forms do not work anymore!

The error message says nothing useful, only:
1) the component is not corretly installed (ok! but it's a common form with
only normal windows common buttons and labels, not a single userparty
creative control)

2) error: &H80004005 -2147467259 (???)

3) memory insuficient (ahah, at 256 Mb, only Excel running... )

4) can not set OleObjectBlob property (why?)

The opened file cannot be saved, as Excel insists at error 1 (component not
instaled). This happens with all secure protection states (from low to high,
before or after trying to running code, don't matter).


But if I try to open the same file (excel workbook) at a Windows 98 / Office
2000 (serv.pack1) all works fine: the worksheet is correct and all code and
forms works well.

Please, help me!
yours, Daniel

from Brazil

VBA Excel: Can't show, import or export userforms (error: &H800040
 

I don't know about the forms issue. Running XP with only 256 RAM, however,
is a questionable practice. When I upgraded to XP I had just 256 and it
barely ran. There is a lot going on in the background of XP that requires
much more memory.

You may want to open VBA and check the references (in the tools menu) to see
if there are any missing. Your IT department might not have installed
everything that you use.

Espero que isso ajude. Tudo de bom.

JNW

"Daniel" wrote:

Please, help me! I can not find where is the the information I need.

My problem is:
I had Windows 2000 and Office 2000.
Now they installed Windows XP and Office 2000 (serv.pack 3).
And my forms do not work anymore!

The error message says nothing useful, only:
1) the component is not corretly installed (ok! but it's a common form with
only normal windows common buttons and labels, not a single userparty
creative control)

2) error: &H80004005 -2147467259 (???)

3) memory insuficient (ahah, at 256 Mb, only Excel running... )

4) can not set OleObjectBlob property (why?)

The opened file cannot be saved, as Excel insists at error 1 (component not
instaled). This happens with all secure protection states (from low to high,
before or after trying to running code, don't matter).


But if I try to open the same file (excel workbook) at a Windows 98 / Office
2000 (serv.pack1) all works fine: the worksheet is correct and all code and
forms works well.

Please, help me!
yours, Daniel

from Brazil

VBA Excel: Can't show, import or export userforms (error: &H80
 

"JNW" wrote:
I don't know about the forms issue. Running XP with only 256 RAM, however,
is a questionable practice.

Ops! Computer now has 512 MB... I have mispelled.

You may want to open VBA and check the references (in the tools menu) to see
if there are any missing.

NOTHING is missing, that I know... as I said: it is only an simple form
(buttons and labels!)

Your IT department might not have installed
everything that you use.

Ahah, yes, I will make them do the stuff correctly, reinstall everything,
those *******s.

Espero que isso ajude. Tudo de bom.


Valeu!
abrs, Daniel