Date Error in Excel

[Rougy]

I have a macro that uses the

Variable = Format(Variable, "mm/dd/yyyy&quot

function, but for some reason it's not working on the user's computer.

Anybody know the add-in or whatever that I need to install on the user's computer?

Thanks!

Rougy

 

[SkipVought]

Hi,
Try this...

MyDateString = Format(DateVariable, "MM/DD/YYYY&quot

Hope this helps Skip,
metzgsk@voughtaircraft.com

 

[acron]

Thecode you posted should work - could you say eactly in which way it fails to work. Do you get an incorrect value or an error message ?

A.C.

 

[Rougy]

Hi everyone,

Thanks for the posts.

Turns out there was an ActiveX library being referenced that was missing on the client's computer.

All I had to do was remove the reference and everything started working fine again.

Thanks.

Rougy