Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
  #2   Report Post  
Posted to microsoft.public.excel.programming
JNW JNW is offline
external usenet poster
 
Posts: 480
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 354
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import/export netCDF files to Excel Piet Jongejan Excel Discussion (Misc queries) 1 July 22nd 08 12:32 PM
Import/export excel macros between two computers mick Excel Discussion (Misc queries) 3 May 13th 08 11:40 AM
Export Userforms to Access Jmbostock[_15_] Excel Programming 1 April 8th 04 10:45 AM
excel.exe error when adding controls to userforms Brian Excel Programming 0 February 20th 04 10:55 PM
import- export XML in excel without loosing XML format Edwin[_2_] Excel Programming 0 January 31st 04 12:31 AM


All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"