I want to pass date from excel to active window using autoit

[Hemanth]

Hi All,

While I'm trying to pass date from excel, in window its getting effected to day only(D-M-YYYY), can u please suggest the other way

Local $aResult1 = _Excel_RangeRead($oWorkbook, Default, $oWorkbook.ActiveSheet.Usedrange.Columns("B"), 1)

I'm calling this by

send($aResult1 & @CRLF)

 

while trying to pass Time from excel, in window its getting effected to Hrs only(h:m:ss).

 

I'm totally new to the AutoIT, recently i started to explore it.

[JLogan3o13]

Moved to the appropriate forum.

[Hemanth]

Sorry I didn't get u....

[Deye]

Try $iReturn = 3 only allows to get the displayed text of a single cell. That's an Excel limitation.

[Hemanth]

Hi All,

While I'm trying to pass date from excel, in window its getting effected to day only(D-M-YYYY), can u please suggest the other way

while trying to pass Time from excel, in window its getting effected to Hrs only(h:m:ss).

To go to that Date filed tab order is not working properly for my active window, here its getting highlighted only Day in Date and Hrs in Time

I'm totally new to the AutoIT, recently i started to explore it.

 

Local $aResult1 = _Excel_RangeRead($oWorkbook, Default, $oWorkbook.ActiveSheet.Usedrange.Columns("B"), 1)

send($aResult1 & @CRLF)

 

[JLogan3o13]

Stick to one thread per topic please. Also, please read the header on each forum so you know where to post your questions.

[water]

When you read a columns as a whole _Excel_RangeRead returns an array. You can't send an array to an application, just single cells.