View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Daniel is offline
external usenet poster
 
Posts: 354
Default 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