gcriaco Posted December 31, 2015 Share Posted December 31, 2015 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 regardsPeppe Link to comment Share on other sites More sharing options...
water Posted December 31, 2015 Share Posted December 31, 2015 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 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...
gcriaco Posted December 31, 2015 Author Share Posted December 31, 2015 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.Textas other users posted in this forum. I thought you should know. Many thanks for your help. Have a good year ahead.Peppe Link to comment Share on other sites More sharing options...
water Posted December 31, 2015 Share Posted December 31, 2015 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 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...
corgano Posted August 31, 2017 Share Posted August 31, 2017 (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 August 31, 2017 by corgano 0x616e2069646561206973206c696b652061206d616e20776974686f7574206120626f64792c20746f206669676874206f6e6520697320746f206e657665722077696e2e2e2e2e Link to comment Share on other sites More sharing options...
water Posted August 31, 2017 Share Posted August 31, 2017 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 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