Are there in this macro Forms, in the condition of development, the mouse to click and prepared to edit the Form, VB is also an Error (System Error & amp; H80040111 (2147221231)), don't see the controls on the Form, note: this code is written by someone else, I am the maintenance, thank you,

CodePudding user response:

What is the content of the error message?
You write a "error code", don't know what this is wrong!!!!!!


I checked in Excel 2007 VBE varies, find & amp; H80040111 represents what mistakes,

CodePudding user response:

Don't know if it lacks a ActiveX DLL......

It is possible that the permissions causes, "run as administrator" to start the Excel, you try to open the workbook,

CodePudding user response:

Thank you, I developed this project was 2003 times, I put it in 2007 under the change and development, whether files from in the first place. Convert XLS XLSM format? At present, I did not change, run by pressing the button, can put the mistake, I to the code, want to see what was on the form, click on the form will be submitted to the same mistake, and controls have a relationship? Or with reference library? Thank you very much,

CodePudding user response:

Incompatibility between 2003 and 2007 degree is high, the converted available hope is not big,
Suggest to install a 2003 edit virtual machine can at least know how is the original,
Then the way of artificial redo realize the same function in 2007,

CodePudding user response:

In my own computer jacket EXCEL2003, also there is an error, prompt Could not load an object because it is not available on this machine. The check information, C: \ Windows \ system32 \ mscomctl ocx version is low, I on the computer version is the 6.1.98.46, still low? If it is a low version, where there is a high version? Thank you very much,

CodePudding user response:

What is the operating system version?
If a new form, if there is something wrong?

CodePudding user response:

Operating system is XP SP3, a controls on a form name is progbar, like is to run it out of the question, when I opened the VBA editor, insert a form, to add a control, but can't find, can't add,

CodePudding user response:

May be a ProgressBar, but there are 5.0 (COMCTL32. Ocx), 6.0 (MSCOMCTL. Ocx) two versions,

Can try to form export, save as FRM file,
And then open in a text editor, see the beginning of the Object= and Begin & lt; ProgID> Progbar ,

CodePudding user response:

This problem is MSCOMCTL. Ocx problem? I am using 6.1.98.46 version, the feeling was the result of Windows form has a problem,

CodePudding user response:

Other people's computer is office 365 version, MSCOMCTL. Ocx is 6.1.98.46 version, the normal operation of all,

CodePudding user response:

Don't guess, and began to make!
What is # 6 new forms of test results?
What is # 8 export test results?

CodePudding user response:

If it is MSCOMCTL. Ocx problems
Did you come to find the file on the old machine
Then on the new machine register

CodePudding user response:

In a 64 - bit Windows:
64 exe and DLL in the directory c: \ Windows \ sys tem32 directory.
32 bit exe and DLL in the directory c: \ Windows \ sys wow64 directory.
So pay attention to:
In win64 system registered under 32-bit ocx DLL to 32 ocx or copy the DLL to the c: \ Windows \ syswow64 \ directory,
And registered to c: \ Windows \ syswow64 \ regsvr32 XXXXXXX ocx or DLL