Can't find project or library error on Format function

[abberyfarm]

Hi,

I have this code in a macro and it works on my laptop.

 Randomize
        c = Format(rnd(1), "#0.00")
        c = Round(rnd, 2)

However, when I try run it on my desktop I get an error 'Can't find project or library' with the 'Format' word highlighted.

Could anybody tell me how to find out which library is missing and how I activate it?

Thank you

also posted here http://www.ozgrid.com/forum/showthread.php?t=176680&p=655767#post655767

 

[Norie]

I know preceding with VBA will work but you shouldn't have to do that.

If there any checked references marked as MISSING then you should uncheck them, save the file, reopen it and try the code again.

Unchecked references really don't have anything to do with the problem and you can ignore.

As for MS adding something to check/update references, I've never heard of anything like that.

By the way, are you rewriting your code because it doesn't work in new versions?

If you are you shouldn't need to, in fact you should write the code so that it will work in the earliest version of Excel it will be used in.

 

[Tonkawa Jingles]

However, code written for earlier versions of Excel will not always work in new versions. There are a few calls and declarations in 32bit code which must be rewritten for 64bit execution.