Which library does the Format function comes from?
 

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

Which library does the Format function comes from?
 

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