Compile Error

mcfly

Board Regular
Joined
May 15, 2002
Messages
162
I wrote some code on excel XP and when I try to use it on excel 2000 I keep getting a compile error 'can't find project or library.
Can anyone please point out why I am having the problem.
Thanks in advance for any replies.

Public Sub userform_initialize()
MultiPage1.Value = 0

'Clear Contents
Worksheets("Sheet1").Cells(14, 2) = Clear
Worksheets("Sheet1").Cells(15, 2) = Clear
Worksheets("Sheet1").Cells(16, 2) = Clear
Worksheets("Sheet1").Cells(17, 2) = Clear
Worksheets("Sheet1").Cells(13, 2) = Clear
Worksheets("Sheet1").Cells(13, 3) = Clear
Worksheets("Sheet1").Cells(13, 4) = Clear
Worksheets("Sheet1").Cells(5, 1) = Clear
Worksheets("Sheet1").Cells(8, 2) = Clear
Worksheets("Sheet1").Cells(8, 5) = Clear
Worksheets("Sheet1").Cells(8, 6) = Clear
Worksheets("Sheet1").Cells(5, 6) = Clear
Worksheets("Sheet1").Cells(9, 5) = Clear
Worksheets("Sheet1").Cells(10, 5) = Clear
Worksheets("Sheet1").Cells(19, 6) = Clear
Worksheets("SHEET1").Cells(11, 2) = Clear
Worksheets("SHEET1").Cells(11, 3) = Clear
Worksheets("SHEET1").Cells(11, 4) = Clear
Worksheets("SHEET1").Cells(12, 2) = Clear
Worksheets("SHEET1").Cells(12, 3) = Clear
Worksheets("SHEET1").Cells(12, 4) = Clear
Worksheets("sheet1").Cells(14, 6) = Clear
Worksheets("sheet1").Cells(15, 6) = Clear
Worksheets("sheet1").Cells(16, 6) = Clear
Worksheets("sheet1").Cells(17, 6) = Clear
Worksheets("sheet1").Cells(26, 2) = Clear



updatecontrols
End Sub
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

mcfly

Board Regular
Joined
May 15, 2002
Messages
162
If that is the case then Microsoft is not to smart. Why would anyone want to buy office XP if it's not compatible with any previous versions of Excel?
Doesn't make much sense to me!
 

mcfly

Board Regular
Joined
May 15, 2002
Messages
162
Juan thank you for the reply, That's a relief.
Now as for your question when I look under Tools-references I see MISSING: ctv OLE control module
and MISSING:Blue sky software active popup.
And that is all, I hope this is what you are talking about because I've never even went in that section.
Thanks for the help!!
 

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
Wow, that's a reference I've never heard of. Try unchecking it. You're getting this error because the old computer had that library (A .dll or something similar), and the "new" computer, with Office XP, doesn't.

I don't see why you should need that reference at all... so, try unchecking it, resaving the workbook, and try again.
 

gplhl

Board Regular
Joined
Feb 23, 2002
Messages
152
On 2002-10-21 18:17, mcfly wrote:
If that is the case then Microsoft is not to smart. Why would anyone want to buy office XP if it's not compatible with any previous versions of Excel?
Doesn't make much sense to me!

They write new and improved bits to their programs, which aren't in earlier versions. You said you wrote the code in XP which is NEWER than 2000 and the code won't run on 2000.

Try talking to a caveman or a chimp, they won't understand you, as you are a newer improved model.
 

Forum statistics

Threads
1,181,333
Messages
5,929,365
Members
436,664
Latest member
plobo4

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