Sign in to follow this  
Followers 0
s3nsei

Multiple sheet select

6 posts in this topic

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.. :graduated:

Share this post


Link to post
Share on other sites



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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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 :graduated:

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

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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! :graduated:

You're amazing, Thanks a lot!

Share this post


Link to post
Share on other sites
:graduated:

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0