s3nsei 0 Posted November 29, 2010 Good day, Please help, i'm trying to select multiple excel sheet, as in manual, i hold down ctrl button and just clicked the sheet 1,2,3 Is it possible to do that with autoit script? Thank you.. Share this post Link to post Share on other sites
water 2,388 Posted November 29, 2010 It's possible. $oExcel.Sheets("sheet1").Select $oExcel.Sheets("sheet2").Select(False) Will select "sheet1" and "sheet2". Or you can select by sheetnumber: $oExcel.Sheets(1).Select $oExcel.Sheets(3).Select(False) My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2020-12-15 - Version 1.6.3.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2020-06-27 - Version 1.3.2.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsPowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & SupportExcel - Example Scripts - WikiWord - WikiTask Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - WikiTutorials:ADO - Wiki, WebDriver - Wiki Share this post Link to post Share on other sites
s3nsei 0 Posted November 29, 2010 It's possible. $oExcel.Sheets("sheet1").Select $oExcel.Sheets("sheet2").Select(False) Will select "sheet1" and "sheet2". Or you can select by sheetnumber: $oExcel.Sheets(1).Select $oExcel.Sheets(3).Select(False) Hello Water, Thanks for your help as always, really appreciate But i still can't select both sheet, please check below code and kindly advise Below code doesn't select group, but it select one by one (in manual, clicked without control pressed) $aArray = _ExcelSheetList($oExcel) _ExcelSheetActivate($oExcel,$aArray[0]) For $i = $aArray[0] To 2 Step -1 $oExcel.Sheets($i).Select Next Share this post Link to post Share on other sites
water 2,388 Posted November 29, 2010 Be sure to use the parameter for Select: $aArray = _ExcelSheetList($oExcel) _ExcelSheetActivate($oExcel,$aArray[0]) For $i = $aArray[0] To 2 Step -1 $oExcel.Sheets($i).Select(False) Next My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2020-12-15 - Version 1.6.3.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2020-06-27 - Version 1.3.2.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsPowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & SupportExcel - Example Scripts - WikiWord - WikiTask Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - WikiTutorials:ADO - Wiki, WebDriver - Wiki Share this post Link to post Share on other sites
s3nsei 0 Posted November 29, 2010 Be sure to use the parameter for Select: $aArray = _ExcelSheetList($oExcel) _ExcelSheetActivate($oExcel,$aArray[0]) For $i = $aArray[0] To 2 Step -1 $oExcel.Sheets($i).Select(False) Next Yey, thanks m8, it worked! You're amazing, Thanks a lot! Share this post Link to post Share on other sites
water 2,388 Posted November 29, 2010 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2020-12-15 - Version 1.6.3.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2020-06-27 - Version 1.3.2.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsPowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & SupportExcel - Example Scripts - WikiWord - WikiTask Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - WikiTutorials:ADO - Wiki, WebDriver - Wiki Share this post Link to post Share on other sites