export cell value - Date Format

[Guest]

I am exporting a cell value from excel to another application with the
following code...

Range("t6").Value = Format(Range("t6").Value, "MM/DD/YY")
SendKeys Range("t6").Value

but when the date is imported to the application it types in the text as
"MM/DD/YYYY"

What would help?

thanks in advance

 

[Tom Ogilvy]

skip the first line. Just use Format directly

SendKeys Format(Range("t6").Value, "MM/DD/YY")

 

[Guest]

thank you sir

skip the first line. Just use Format directly

SendKeys Format(Range("t6").Value, "MM/DD/YY")