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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
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,567
Messages
6,114,344
Members
448,570
Latest member
rik81h

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