Sign in to follow this  
Followers 0
Dustov

Search function in ExcelCOM_UDF trouble

3 posts in this topic

First of all hello to all the members...Im new to Autoit and so far i am doing prety well in compiling some programs for personal use...

My question concerns ExcelCOM_UDF...I used it to create a small program to keep track with my shop's stock...anyway they thing is as follows

I want my programm to do a search action in several worksheets and give the results to a list

Im using the function _ExcelFindInRange. In its description it states that it gives all the search results in an array in the form of $array[x][x]. My problem is that whatever i do it always gives one result after search.I wonder if the function only answers you if the search value "exists" in the workesheet.

Ive tried it several times (cause basicaly i make something work after continous tries :mellow: )and i always get one hit although the search value deliberately exists more than once in my test worksheets...

Am i doing something wrong? Please I could really use your help in correcting me and if possible give me some suggestions on how I could make it Work

Pogkas Nikos

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

Post an example of how you used _ExcelFindInRange(), specifically the parameters passed to the function for start/end of the range.

Note that ExcelCOM_UDF.au3 is not really supported much anymore since a subset of it was included in the standard UDFs as Excel.au3, which does not include this function. To perform that action with the new UDF would mean reading the sheet to an array with _ExcelReadSheetToArray() and then searching that array, or working with COM objects directly.

:mellow:

Edited by PsaltyDS

Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law

Share this post


Link to post
Share on other sites

thanks allot for your response

indeed i used _ExcelReadSheetToArray() and it worked fine...

thanks again

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