Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Form "Component Not Registered"
I am using several excel spreadsheet that are working on many other machines
but they all of a sudden started giving me a "component not registered" error. I don't know of any changes to my workstation environment. In order to debug, I stripped down the excel spreadsheet to the bare minimum. I noticed that when all the forms were removed from the spreadsheet that the problem disapeared. I removed everything in the spreadsheet except for one form and a Workbook_Open() procedure. No problem occurs if I have an empty procedure but as soon as I even put a comment in the procedure, the "component not registered" error appears as soon as I open the spreadsheet on the problem workstation. On a workstation in which I was able to work with the form, I removed all code and widgets. So it is basically an empty form. I also created a duplicate form in the spreadsheet such that all the properties are the same except the name. On the problem workstation, I get an error when the skeleton of the old form is in the worksheet but not when a manually created copy is there. I've done a diff on both the frm files and frx files of the skeleton and the manually created file. The frm files differ as one would expect since they have different names. The frx files on the other hand have a few unprintable differences. Actually there are probably about 2 dozen people who are able to use these spreadsheets without a problem. And there are two workstations that don't. I'm wondering if there is a compatability problem between forms created several years ago and the software on my workstation now. However, other question is why this problem only affects two people. I believe we are all on the same version of excel which for me is 11.8316.8221. Vincent |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA fails with Run-time Error 429 "ActiveX component can't create object" | Excel Programming | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Hyperlink generates "no program registered" | Excel Discussion (Misc queries) | |||
Excel RTD with DCOM -- "Class not registered" error | Excel Programming | |||
"Library not registered" message accessing an HTMLDocument object | Excel Programming |