can't find project or library

[Tarheel]

Hi all,

I created a spreadsheet in Excel 97 running on Windows 98, and I have also tested it in Excel 2000 running on Windows 98. In my macros, I do a lot of date manipulation because I wrote my own date & time picker. I have now gotten a laptop running Windows 2000 so that I could test my application in Excel 2000 running on Windows 2000. Those same macros don't work, can anyone tell me why?

For instance, here is some code that is giving an error.

Sheet1.ComboBox1.Text = Year(Date-1)
Sheet1.ComboBox3.ListIndex = Month(Date-1) -1
Sheet1.ComboBox4.ListIndex = Month(Date-1) -1


The error I receive is "Compile error: Can't find project or library"

What gives? Is there just some advanced option that needs to be installed for excel to execute this macro?

Thanks in advance for the help.
Richard

 

[Juan Pablo González]

And have you looked under Tools | References to see what's missing in there ?

 

[Tarheel]

Hi Juan, (and all)

I just now looked in the Visual Basic Editor on the Windows 2000 machine, and under Tools -- > References, there is only one missing.

MISSING: Microsoft Windows Common Controls-2 6.0(SP3)

Location : C:WINDOWSSYSTEMMSComCtl2.TWD
Language : Standard

What does this mean? I am running Windows 2000 on this machine, and there is no WindowsSystem folder. Also, I searched my machine's hard drive, and there is no MSComCtl2.TWD file on the hard drive.

I looked in the Visual Basic Editor for the spreadsheet on my Windows 98 machine with Excel 97, and I found the Microsoft Windows Common Controls-2 6.0 (SP3) reference, but it says it's located at C:WindowsSystemMSCOMCT2.OCX. What can I do to get this fixed?

I am new to excel programming, so I appreciate your help.

Thanks,
Richard
This message was edited by Tarheel on 2002-10-18 11:00