CATIA VBA : range.Find exact value from CATIA

[jissididi]

Hi everybody,

I made a macro exporting data (drawingtexts) into a newly created excelsheet "wbk1"
I want to make a check with another workbook ("wbk2") to find if the text I exported in my "wbk1" exists in "wbk2".
I need to use the

wbk2.usedrange.find(thetext,lookat:=XlWhole)

method (because I want an exact match) but it does not work.

Do you have an idea of what could be the problem ?

PS : when I use

wbk2.usedrange.find(thetext)

alone, it works but it also find me other cells in which ones the string is containing the text I'm looking for : but I dont want that.

Thanks in advance

Jissi

 

[Little Cthulhu]

method (because I want an exact match) but it does not work.

What is the error exactly?

 

[jissididi]

I found the answer to my problem

in CATIA

wbk2.usedrange.find(thetext,lookat:=XlWhole)

does not work

instead use

wbk2.usedrange.find(thetext,lookat:=true)

regards

 

[tesak]

Is this code from Catia or Excel? Did you link the right libraries?

Because although it might work I am not sure that this is the right way.

Tesak

https://scripts4all.eu/play-tetris-in-catia-v5-drawing-vba/

- Play Tetris in CATIA V5 drawing

 

[tesak]

According to Excel reference Const xlWhole = 1, so you make better if you replace True with number 1. If you work from CATIA VBA and you didn't link Excel libraries, then xlWhole constant is unknown which could cause your issues.

Tesak

https://scripts4all.eu/play-tetris-in-catia-v5-drawing-vba/

- Play Tetris in CATIA V5 drawing