Thanks Dorian!

I was hoping to avoid doing it with a loop but I guess it is the only option.

Thank you as always!

Hello Everyone,

This seems to work for what I need but only on a single file.

I need to extract the file names to rows in Excel. Is it possible to do this without looping extract file name?

Sorry for cluttering up the board uselessly. The issue was that an End With was missing in my code. original section of code with error With Selection.Interior .Pattern = xlNone .TintAndShade = 0 .PatternTintAndShade = 0 Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagon...

This worked perfectly thanks very much!

Hello Everyone, I am trying to get MS to run some VBA to set the cell outlines to black. However, Excel gives an error "expected end with" and then the macro fails. Here is the code for what I am trying to work with. labeltovar>vba_code3,theCode3 XLRunCode>A16,theCode3 /* vba_code3: Range("A1").Sele...

hagchr wrote: ↑

Thu Jul 14, 2022 6:18 am

Sorry, I thought you were just looking for one digit. Simply change from \d (one digit) to \d+ (one or more digits) and you should catch all.

No worries works perfectly thanks very much!

Small tip. If you are just looking for the digit/number you can search for that directly eg: regex>\d,myStr,0,matches,num,0 \d will look for a digit, and your number will be in matches_1. Does it look for only a single digit? I used this as an example but the number can be anywhere from 1 - 99999.

Reviving a very old thread here. Hello Everyone, I have a need for something similar to this but I can't seem to get it to work. I am using OCRarea to capture text and symbols on my screen. The OCRarea will give 1 of two possible results. 1)string - 2 @ 2)string - 2 © I want to isolate the numeric ...

Reviving a very old thread here. Hello Everyone, I have a need for something similar to this but I can't seem to get it to work. I am using OCRarea to capture text and symbols on my screen. The OCRarea will give 1 of two possible results. 1)string - 2 @ 2)string - 2 © I want to isolate the numeric v...

user5274 wrote: ↑

Thu Jun 16, 2022 9:39 pm

X2 should always be larger than X1
Y2 should always be larger than Y1

The coordinate are always Top Left, Bottom Right.

The previous scripts show Y2 is smaller than Y1

This was exactly the problem a mistake I made with my coordinates in my script and fixed by reversing them.

Thanks very much!

@user5274

This was exactly the problem a mistake I made with my coordinates in my script and fixed by reversing them.

Thanks very much!

Hello,

Was anyone ever able to solve this issue. I am having it as well.

Works like a charm thank you very much!

Guess it is time for me to learn some VBA

Looks like I need further insight with this issue. I have tried to program in a method for finding exact matches as follows. Xlopen>XLFile.xlsx,1,XY RGB>255,0,0,R repeat>e xlfind>XY,Sheet1,PL4, xlgetselectedcell>XY,D,intRow,intCol if>D=PL4 xlsetcellcolor>XY,Sheet1,intRow,intCol,R endif Until>e the c...

Thanks Dorian! I know that in the find menu you can check off in the options match entire cell contents as indicated below. https://techcommunity.microsoft.com/t5/image/serverpage/image-id/126374i12C8F825433EAEBC/image-size/large?v=v2&px=999 Maybe this is something that could be added to MS in the f...