Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

CATIA VBA : range.Find exact value from CATIA

Status
Not open for further replies.

jissididi

Automotive
Mar 17, 2015
46
FR
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
Code:
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
Code:
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
 
Replies continue below

Recommended for you

I found the answer to my problem

in CATIA
Code:
wbk2.usedrange.find(thetext,lookat:=XlWhole)
does not work

instead use
Code:
wbk2.usedrange.find(thetext,lookat:=true)
regards
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top