gcriaco

_Excel_RangeFind for a specific sheet

6 posts in this topic

I need to execute a search in a specific sheet (not sure if active), in a workbook that contains more sheets.

Is it possible? If not, do you think that it's OK to post a feature request?

 

 

Best regards

Peppe

Share this post


Link to post
Share on other sites



Example: Set parameter 3 to $oWorkbook.Sheets(5).UsedRange to search all cells on sheet 5.


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 works fine.

BTW, I commented the following two lines in the UDF to avoid errors:

    ;$aResult[$iIndex][1] = $oMatch.Name.Name
    ;$aResult[$iIndex][5] = $oMatch.Comment.Text
as other users posted in this forum. I thought you should know.

 

Many thanks for your help.

 

Have a good year ahead.

Peppe

Share this post


Link to post
Share on other sites

Glad it works now.
This is a known bug. I'm not sure if I will do a workaround or wait until the bug has been fixed :huh:


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

#5 ·  Posted (edited)

On 12/31/2015 at 6:23 AM, water said:

Example: Set parameter 3 to $oWorkbook.Sheets(5).UsedRange to search all cells on sheet 5.

Erm, can you explain how this works in english? I have a workbook object $oWorkbook, I want to search in a sheet named "template" for the string "description". The problem I'm having is the help file is less than descriptive. 

Peram 3 is described as "A range object, an A1 range (string) or keyword Default to search all sheets of the workbook (default = keyword Default)" but I can't find anything about a1 range or range objects in the help file. The description of peram 4 is also lacking on what XLFindLookIn enumeration is and has no info about it.

I also want to note, most other _excel_range* functions were rewritten to use $oWorksheet instead of $oWorkbook, and the fact _Excel_RangeFind does not use worksheet seems like an oversight. Shouldn't _Excel_RangeFind be useable on a specific worksheet like the rest of the _excel_range functions? What about making it take workbook (to search whole book) or worksheet (to search specific sheet)?

Either way, I'm confused how to search only one sheet and don't understand the previous answer, could you clarify?

Edited by corgano

0x616e2069646561206973206c696b652061206d616e20776974686f7574206120626f64792c20746f206669676874206f6e6520697320746f206e657665722077696e2e2e2e2e

Share this post


Link to post
Share on other sites

#6 ·  Posted

1 hour ago, corgano said:

but I can't find anything about a1 range or range objects in the help file.

That's because the AutoIt help file describes the Excel UDF, not the basics of Microsoft Excel.
In the wiki you can find more information about how the UDF works.
 

1 hour ago, corgano said:

I also want to note, most other _excel_range* functions were rewritten to use $oWorksheet instead of $oWorkbook, and the fact _Excel_RangeFind does not use worksheet seems like an oversight.

Thats because you can specify to search some rows or columns (a range) as well, not just a whole sheet. So it isn't an oversight.

1 hour ago, corgano said:

Shouldn't _Excel_RangeFind be useable on a specific worksheet

Specify the sheet to be searched as described in post #2.


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