Hi All

Can anyone tell me which library does the Format function come from?

E.g.: MsgBox Format(Date, "dd/mm/yy")

I am having troubles with it compiling on some colleagues computers.

How do I find this out for myself?

Cheers
Chrisso

It's in VBA.Strings

Temporarily you get probably get it to work by fully qualifying

MsgBox VBA.Strings.Format(Date, "dd/mm/yy")

however if you need to do that it strongly suggests you've either got a
missing reference (Tools, References) or a reference has been saved against
a newer ref but the file is being used with an older one.

Regards,
Peter T


"Chrisso" wrote in message
...
Hi All

Can anyone tell me which library does the Format function come from?

E.g.: MsgBox Format(Date, "dd/mm/yy")

I am having troubles with it compiling on some colleagues computers.

How do I find this out for myself?

Cheers
Chrisso