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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

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

ADVERTISEMENT

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
150
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,144,356
Messages
5,723,887
Members
422,524
Latest member
wirkkarn

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