Search found 29 matches

by Neib74656
Fri Jan 13, 2023 10:04 pm
Forum: Technical / Scripting
Topic: How to find the name of a file in a folder
Replies: 4
Views: 3347

Re: How to find the name of a file in a folder

Thanks Dorian!

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

Thank you as always!
by Neib74656
Thu Jan 12, 2023 7:06 pm
Forum: Technical / Scripting
Topic: How to find the name of a file in a folder
Replies: 4
Views: 3347

Re: How to find the name of a file in a folder

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?
by Neib74656
Sun Jul 17, 2022 7:25 am
Forum: Technical / Scripting
Topic: Excel VBA Error - End With (Resolved)
Replies: 1
Views: 2569

Re: Excel VBA Error - End With (Resolved)

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...
by Neib74656
Sun Jul 17, 2022 7:18 am
Forum: Technical / Scripting
Topic: Excel Set Range Format
Replies: 2
Views: 3441

Re: Excel Set Range Format

This worked perfectly thanks very much!
by Neib74656
Sun Jul 17, 2022 7:16 am
Forum: Technical / Scripting
Topic: Excel VBA Error - End With (Resolved)
Replies: 1
Views: 2569

Excel VBA Error - End With (Resolved)

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...
by Neib74656
Sun Jul 17, 2022 7:06 am
Forum: Technical / Scripting
Topic: Converting Text to Numeric
Replies: 12
Views: 10541

Re: Converting Text to Numeric

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!
by Neib74656
Wed Jul 13, 2022 11:05 pm
Forum: Technical / Scripting
Topic: Converting Text to Numeric
Replies: 12
Views: 10541

Re: Converting Text to Numeric

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.
by Neib74656
Tue Jul 12, 2022 6:22 am
Forum: Technical / Scripting
Topic: Converting Text to Numeric
Replies: 12
Views: 10541

Re: Converting Text to 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 ...
by Neib74656
Tue Jul 12, 2022 5:46 am
Forum: Technical / Scripting
Topic: Converting Text to Numeric
Replies: 12
Views: 10541

Re: Converting Text to 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...
by Neib74656
Fri Jun 17, 2022 3:27 pm
Forum: Technical / Scripting
Topic: Out of system resources
Replies: 20
Views: 22664

Re: Out of system resources

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!
by Neib74656
Fri Jun 17, 2022 3:27 pm
Forum: Technical / Scripting
Topic: Out of system resources
Replies: 20
Views: 22664

Re: Out of system resources

@user5274

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

Thanks very much!
by Neib74656
Thu Jun 16, 2022 7:06 pm
Forum: Technical / Scripting
Topic: Out of system resources
Replies: 20
Views: 22664

Re: Out of system resources

Hello,

Was anyone ever able to solve this issue. I am having it as well.
by Neib74656
Wed Mar 09, 2022 4:02 am
Forum: Technical / Scripting
Topic: Exact Match Function when using XLFind
Replies: 6
Views: 2872

Re: Exact Match Function when using XLFind

Works like a charm thank you very much!

Guess it is time for me to learn some VBA :)
by Neib74656
Sat Feb 26, 2022 7:04 pm
Forum: Technical / Scripting
Topic: Exact Match Function when using XLFind
Replies: 6
Views: 2872

Re: Exact Match Function when using XLFind

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...
by Neib74656
Wed Feb 16, 2022 11:21 pm
Forum: Technical / Scripting
Topic: Exact Match Function when using XLFind
Replies: 6
Views: 2872

Re: Exact Match Function when using XLFind

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...
cron
Sign up to our newsletter for free automation tips, tricks & discounts