Compile Error

[mcfly]

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

 

[gplhl]

Not used XP but I guess it's not backwards compatible.

 

[mcfly]

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]

Someone please tell me this is not true.

 

[Juan Pablo González]

It is not true.

 

[Juan Pablo González]

What project is missing under Tools | References ?

 

[mcfly]

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]

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]

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.

 

[mcfly]

Thanks Juan, that did it!