Hemanth Posted October 17, 2017 Share Posted October 17, 2017 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. Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted October 17, 2017 Moderators Share Posted October 17, 2017 Moved to the appropriate forum. "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
Hemanth Posted October 17, 2017 Author Share Posted October 17, 2017 Sorry I didn't get u.... Link to comment Share on other sites More sharing options...
Deye Posted October 17, 2017 Share Posted October 17, 2017 Try $iReturn = 3 only allows to get the displayed text of a single cell. That's an Excel limitation. Link to comment Share on other sites More sharing options...
Hemanth Posted October 17, 2017 Author Share Posted October 17, 2017 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) Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted October 17, 2017 Moderators Share Posted October 17, 2017 Stick to one thread per topic please. Also, please read the header on each forum so you know where to post your questions. "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
water Posted October 17, 2017 Share Posted October 17, 2017 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. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now