Compile error on a PC other than my own

[svmac]

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

[Penfold]

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

[svmac]

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

[Penfold]

Stuart, have sent you a private message...