Compile error on a PC other than my own

svmac

Board Regular
Joined
Feb 16, 2002
Messages
182
I am currently using an office and PC other than my own (that's another complaint for another messageboard at another time) and am getting a compile error on some code that has worked faultlessly in the past.

The message is as follows:

Compile error
Can't find project or library

The highlighted (and therefore erroneous) code is:

chr

This is in use for chr(13) to place a character return in a message box that has worked for the past 6 months, until I use this different PC. The different PC is the same make, model etc, also same version of Excel (97) and OS is NT.

Can anyone please point me to the answer?

Thanks in advance
Stuart
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
I've had similar problems in the past, and it has always been related to Excel VBA object references. It has happened because on once PC the objects are located in a different place to the other.

To fix it, hit Alt-F11 to bring up the Visual Basic Editor and click on Tools, References. You will probably see one or more errors in the list here and you'll need to Browse to find the right location of the object you're missing. Once you've found it, save the spreadsheet and it should be ok from that point on.

Hope this helps,

Penfold
 
Upvote 0
Thanks Penfold.

I performed task as you said, and have a missing reference:
Microsoft Windows Common Control 6.0 (SP4)

I am now embarking on a voyage of discovery as I try and find the bloody thing.

Thanks again for your help.
Stuart
 
Upvote 0

Forum statistics

Threads
1,213,564
Messages
6,114,334
Members
448,567
Latest member
Kuldeep90

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
Back
Top