export cell value - Date Format
 

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

export cell value - Date Format
 

skip the first line. Just use Format directly

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

--
Regards,
Tom Ogilvy

"John" wrote in message
...
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

export cell value - Date Format
 

thank you sir

"Tom Ogilvy" wrote:

skip the first line. Just use Format directly

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

--
Regards,
Tom Ogilvy

"John" wrote in message
...
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