Chr() function and Compile error

[mattj63]

I created a spreadsheet with a macro that uses the Chr() function on one PC and when I try to run it on a second PC I get the error

Compile Error: Cant find project or library.

If I create a new worksheet on the new PC and use the Chr() function everything is normal. The error only occurs when I try to run the saved file created on the other computer.

Both PCs are running Excel 2000 with VB for Apps 6.0. I have all the same add-ins loaded.

What could be causing the compile error with the file created on the other PC?

 

[PHV]

Double check the references:
menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mattj63]

Thanks. I was missing the Microsoft Comm Control which I use to read data from the serial port. The error probably wasn't the Chr() function but rather later references to the MSComm control.

Not sure why it stopped at the line with Chr() in it. Must be an idiosyncracy of VB.

I never worried about the "references" list. Now I know a new place to look for possible problems.

Thanks.