Which library does the Format function comes from?

C

Chrisso

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
 
P

Peter T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Finding Date in an overseas format 21
International Date formatting 6
Date Format - simple question 1
Code with Format(Date, "dd/mm/yy") does not compile anymore! 0
Date formatting 1
Formatting variable problem 2
missing library makes Format() disappear 2

Top