Excel, Active Setup Control Library, MISSING

mbrittb00 · 09-14-2007, 06:56 AM

First of all can anyone explain to me what the "Active Setup Control Library" is in MS Excel?

For some reason this library seems to be missing. When I go to the the Tools->References menu in Excel VBA, I notice that the "Active Setup Control Library" is marked "MISSING".

I can uncheck that reference and all my macros compile and seem to run correctly. However macros I have that run on a windows XP machine (far inferred to my new computer performance wise) in a few seconds (10-30) take upwards of 5 minutes in my new machine running Vista. Since I don't know what the Active Setup Control Library is or what it does, I wonder if that may be part of the problem.

Does anyone know how to restore a MISSING library?

My setup is as follows:

Dell Inspiron E1505
Intel Core2 Duo 2.0 Ghz processor
1 GB RAM
Windows Vista Home Premium
Microsoft Excel 2003

Thanks,

Britt

Zazula · 09-17-2007, 02:25 AM

What you're looking for is Asctrls.ocx. This is part of IE6 (and earlier). I believe if you install VBA it'll show up in case it is actually needed. You'll have to run the Office installation and select to Add components, in order to add the VBA.

mbrittb00 · 10-15-2007, 03:30 PM

VBA is already there, it is just that this library is missing. Maybe reinstalling will solve the problem, but if it wasn't there from the initial install I have my doubts.

Britt

09-14-2007, 06:56 AM	#1 (permalink)
mbrittb00 Registered User Join Date: Jan 2007 Posts: 60 OS: Windows Vista Home Preimum	Excel, Active Setup Control Library, MISSING First of all can anyone explain to me what the "Active Setup Control Library" is in MS Excel? For some reason this library seems to be missing. When I go to the the Tools->References menu in Excel VBA, I notice that the "Active Setup Control Library" is marked "MISSING". I can uncheck that reference and all my macros compile and seem to run correctly. However macros I have that run on a windows XP machine (far inferred to my new computer performance wise) in a few seconds (10-30) take upwards of 5 minutes in my new machine running Vista. Since I don't know what the Active Setup Control Library is or what it does, I wonder if that may be part of the problem. Does anyone know how to restore a MISSING library? My setup is as follows: Dell Inspiron E1505 Intel Core2 Duo 2.0 Ghz processor 1 GB RAM Windows Vista Home Premium Microsoft Excel 2003 Thanks, Britt

09-17-2007, 02:25 AM	#2 (permalink)
Zazula Manager Emeritus, I'm blond, James Blond Join Date: Apr 2006 Location: Athens, Greece Posts: 7,667 OS: Win XP Pro SP2	Re: Excel, Active Setup Control Library, MISSING What you're looking for is Asctrls.ocx. This is part of IE6 (and earlier). I believe if you install VBA it'll show up in case it is actually needed. You'll have to run the Office installation and select to Add components, in order to add the VBA. __________________ "Time is the wisest because it discovers everything" Thales of Miletus (ca.624BC-ca.546BC) "Everything flows, nothing stands still." Heraclitus of Ephesus (ca.535BC-475BC) "One thing I know, that I know nothing" Socrates of Athens (ca.470BC–399BC)

10-15-2007, 03:30 PM	#3 (permalink)
mbrittb00 Registered User Join Date: Jan 2007 Posts: 60 OS: Windows Vista Home Preimum	Re: Excel, Active Setup Control Library, MISSING VBA is already there, it is just that this library is missing. Maybe reinstalling will solve the problem, but if it wasn't there from the initial install I have my doubts. Britt