Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
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
VBA fails with Run-time Error 429 "ActiveX component can't create object" [email protected] Excel Programming 1 June 4th 09 11:43 AM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
Hyperlink generates "no program registered" JustLearning Excel Discussion (Misc queries) 0 October 14th 06 03:37 AM
Excel RTD with DCOM -- "Class not registered" error Mike K[_4_] Excel Programming 0 December 5th 05 03:24 PM
"Library not registered" message accessing an HTMLDocument object Mike S.[_2_] Excel Programming 2 April 7th 04 12:01 PM


All times are GMT +1. The time now is 08:11 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"