export cell value - Date Format

[John]

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")

--
Regards,
Tom Ogilvy

"John" <[email protected]> wrote in message
news:[email protected]...
> 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

[John]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>