+ Reply to Thread
Results 1 to 7 of 7

MISSING: Microsoft Windows Common Controls-2 6.0

  1. #1
    Forum Contributor
    Join Date
    08-02-2007
    Location
    Panama & Austria
    MS-Off Ver
    2003 & 2010
    Posts
    186

    MISSING: Microsoft Windows Common Controls-2 6.0

    I have windows XP and Excel 2003. In Visual Basic Editor, References, I have missing the Microsoft Windows Common Controls-2 6.0. How can I enable it?
    When opening the file, excel prompts Error compiling some modules. Opening the file in another pc with this common controls enabled, it works fine.

    Thanks a lot fot the help.
    Attached Images Attached Images

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Try running a Repair from your Office CD
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    08-02-2007
    Location
    Panama & Austria
    MS-Off Ver
    2003 & 2010
    Posts
    186

    Not working

    Thanks Roy. I try it, but still Missing.
    What else could I do?
    It is prompting "Compile Error in Hidden Module".
    Attached Images Attached Images

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    What controls are on your form?

  5. #5
    Forum Contributor
    Join Date
    08-02-2007
    Location
    Panama & Austria
    MS-Off Ver
    2003 & 2010
    Posts
    186
    I unprotect the file, and opened the Visual Basic Editor to see exactly where the problem was. I ran random modules and it points errors where there are variables.
    For example, if I use: "For each C in range("B4:B100")", it marks the "C" and prompts the error message: "Cant find Project Library".
    The same occurs where I use variables. For example, I create a variable called "COUNTR". I use that variable to count how many times a loop has been run (before the loop ends, I added the line "COUNTR=COUNTR +1").
    Now, when running the macro, it prompts the "Cant find Project Library" error and marks the "COUNTR" variable.
    In those cases I did not use Set, nor DIM to for the variables ("COUNTR"; "C"; etc).

  6. #6
    Forum Contributor
    Join Date
    08-02-2007
    Location
    Panama & Austria
    MS-Off Ver
    2003 & 2010
    Posts
    186

    Smile

    Solution Found.

    Solution:
    I'm not quite sure why this problem occurs, but it has to do with the Excel version. The original file was creates in Excel 2003 and I was running it on Excel 2003 on a different computer. Looks like one was version 10 and the other was version 11, even though both are Excel 2003.
    To solve the problem, I had to copy the file "Mscomct2.ocx" into the "\System32" folder. Then go to the VBA editor and there, Extras->Reference and select the "Microsoft Common Controls....." selected.
    I got that file from the computer wher I made the original file.

    Good Luck
    Last edited by Wizz; 03-17-2008 at 06:23 PM.

  7. #7
    Registered User
    Join Date
    04-28-2015
    Location
    eq
    MS-Off Ver
    2007
    Posts
    1

    Re: MISSING: Microsoft Windows Common Controls-2 6.0

    good thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1