can't find project or library

Tarheel

Board Regular
Joined
Jul 30, 2002
Messages
158
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
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Tarheel

Board Regular
Joined
Jul 30, 2002
Messages
158
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
 

Forum statistics

Threads
1,144,510
Messages
5,724,774
Members
422,576
Latest member
kayth891

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top