Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import/export netCDF files to Excel | Excel Discussion (Misc queries) | |||
Import/export excel macros between two computers | Excel Discussion (Misc queries) | |||
Export Userforms to Access | Excel Programming | |||
excel.exe error when adding controls to userforms | Excel Programming | |||
import- export XML in excel without loosing XML format | Excel Programming |