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
|