s3nsei Posted November 29, 2010 Share 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.. Link to comment Share on other sites More sharing options...
water Posted November 29, 2010 Share 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 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...
s3nsei Posted November 29, 2010 Author Share 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 Link to comment Share on other sites More sharing options...
water Posted November 29, 2010 Share 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 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...
s3nsei Posted November 29, 2010 Author Share 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! Link to comment Share on other sites More sharing options...
water Posted November 29, 2010 Share Posted November 29, 2010 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