Search found 32 matches

by Monoxide3009
07 Feb 2019, 16:35
Forum: Ask For Help
Topic: Multiple Contains Functions on Single Line Topic is solved
Replies: 9
Views: 306

Re: Multiple Contains Functions on Single Line Topic is solved

Thanks. I already have a working function, but this is good to know. The issue was that I have never used the A_Loopfield, so that is something to look into for the future. I think that can help me a lot.
by Monoxide3009
25 Jan 2019, 11:42
Forum: Ask For Help
Topic: Multiple Contains Functions on Single Line Topic is solved
Replies: 9
Views: 306

Re: Multiple Contains Functions on Single Line Topic is solved

Thanks, I actually looked there, but I somehow missed these lines:

if var contains 1,3 ; Note that it compares the values as strings, not numbers.
MsgBox Var contains the digit 1 or 3 (Var could be 1, 3, 10, 21, 23, etc.)
by Monoxide3009
25 Jan 2019, 11:38
Forum: Ask For Help
Topic: Multiple Contains Functions on Single Line Topic is solved
Replies: 9
Views: 306

Re: Multiple Contains Functions on Single Line Topic is solved

Looks like everything works well when tested. Thanks a ton.

I tried researching for contains using multiple parameters, but I was unable to find anything - the wiki didnt seem to answer my question properly. I have updated everything and looks to be working great.
by Monoxide3009
25 Jan 2019, 11:09
Forum: Ask For Help
Topic: Multiple Contains Functions on Single Line Topic is solved
Replies: 9
Views: 306

Re: Multiple Contains Functions on Single Line Topic is solved

I didnt think that worked - let me try it. However, I have another line that I was hoping to fix as well: if (PROJ = "OPT") and HAWB contains MST { Sleep, 50 wrkbk1.Sheets(SheetName).Range("C"ROW).Characters.Text := "Skipped MST HAWB" Sleep, 50 continue } EDIT - I will test this as (PROJ = "OPT"),HA...
by Monoxide3009
25 Jan 2019, 10:37
Forum: Ask For Help
Topic: Multiple Contains Functions on Single Line Topic is solved
Replies: 9
Views: 306

Multiple Contains Functions on Single Line Topic is solved

Hello All, I am having a hard time figuring out a solution to a function that has multiple contain parameters on a single line. This seems extremely simple, but I cannot find the solution. Please be gentle; I am self taught (please be as descriptive as you can with any suggestions). segment of funct...
by Monoxide3009
31 Dec 2018, 15:05
Forum: Ask For Help
Topic: Single Cell - Multiple Output Topic is solved
Replies: 5
Views: 170

Re: Single Cell - Multiple Output Topic is solved

I 'may' be able to get strsplit to work, but it looks like I have to use indexing, which I am not super familiar with. I will try to put something together and trial-and-error it. If you come up with an idea, Scr1ptor, I would still love to see it. Sorry for the spam, I was able to get it working si...
by Monoxide3009
31 Dec 2018, 15:02
Forum: Ask For Help
Topic: Single Cell - Multiple Output Topic is solved
Replies: 5
Views: 170

Re: Single Cell - Multiple Output Topic is solved

Scr1pter wrote:
31 Dec 2018, 14:01
Did I understand it correctly?
What you wrote looks to be correct for what I am looking for.

I will also check out string split in the meantime.
by Monoxide3009
31 Dec 2018, 13:43
Forum: Ask For Help
Topic: Single Cell - Multiple Output Topic is solved
Replies: 5
Views: 170

Single Cell - Multiple Output Topic is solved

Hello All, I assume this will have a simple solution, but I am drawing a blank. I have an excel sheet (that cant be edited) that has multiple entries in a single cell that I need to split up. The data points are separated by a semicolon, so I think this will have an easy solution. Example - 17022056...
by Monoxide3009
13 Sep 2018, 14:43
Forum: Ask For Help
Topic: Multiple RegEx Matches Topic is solved
Replies: 4
Views: 106

Re: Multiple RegEx Matches Topic is solved

I was able to get it functioning with your help awel20. However, I had to alter/remove several things you changed, as 'exactly' what you wrote does not work at all. I came across a proper setup by trial and error, as I didn't understand what the m)^ was for, I removed it. I also changed the $ end of...
by Monoxide3009
13 Sep 2018, 12:46
Forum: Ask For Help
Topic: Multiple RegEx Matches Topic is solved
Replies: 4
Views: 106

Multiple RegEx Matches Topic is solved

Hello All, I know there are a lot of posts on this topic, but all of them so far have been far beyond my understanding. I have tried to piece things together for several days, and I am getting no where. My goal is to pull multiple regex matches in a batch of text. I currently have a working script t...
by Monoxide3009
02 Aug 2018, 14:52
Forum: Ask For Help
Topic: Format Date - Excel Com
Replies: 2
Views: 87

Format Date - Excel Com

Hello All, I am looking to make a completed script easier for the end user. Currently, my script obtains dates and puts them in excel, pretty cut and dry. However, there is confusion as the dates arent in "date formatting" on the end spreadsheet; everything works fine from my end, but their equation...
by Monoxide3009
31 Jul 2018, 15:06
Forum: Ask For Help
Topic: ControlClick Help
Replies: 4
Views: 153

Re: ControlClick Help

Back after spending the weekend pondering/playing with all this. I currently have internet explorer connected via com, and (finally) figured out how to get it to wait for the page to finish loading. I now have a new/similar issue to the ones above. I was able to work around the "moving" link I was d...
by Monoxide3009
27 Jul 2018, 17:13
Forum: Ask For Help
Topic: ControlClick Help
Replies: 4
Views: 153

Re: ControlClick Help

Create works - however I am trying to utilize an already open window. Everything I have found on the topic was close but not the same, or simply didnt work (or at the very least *I* couldnt get it to work). Verison: 1.1.27.00 I have played with the idea of creating a new window and starting from the...
by Monoxide3009
27 Jul 2018, 16:02
Forum: Ask For Help
Topic: ControlClick Help
Replies: 4
Views: 153

ControlClick Help

Hello All, Im back again. I am trying to click on a moving button on a web page. From what I can tell, ControlClick can accomplish this task. However, I cannot get it to work. I think part of the problem is that the button appears to be an image in the html and not actual text: <A onclick="if(typeof...
by Monoxide3009
26 Jul 2018, 15:52
Forum: Ask For Help
Topic: if (excel sheet exists) ? create
Replies: 4
Views: 195

Re: if (excel sheet exists) ? create

Took me about 2 hours to really figure out what was going on here; once I played with it a while, I got it.

Works like a charm. Cut a LOT of inefficiency out of my script.

Thanks, FG, you Fatastic Guru.
by Monoxide3009
25 Jul 2018, 16:54
Forum: Ask For Help
Topic: if (excel sheet exists) ? create
Replies: 4
Views: 195

Re: if (excel sheet exists) ? create

FG Thanks. I have seen something "similar" to this, but I wasnt able to decipher it. This looks clear and to the point, I think I should be good. Any suggestions on finding the next blank cell when dealing with multiple sheets? What I have 'works' but after a few dozen rows, it slows down drastical...
by Monoxide3009
25 Jul 2018, 15:44
Forum: Ask For Help
Topic: if (excel sheet exists) ? create
Replies: 4
Views: 195

if (excel sheet exists) ? create

Hey All, TL;DR - 1) how do you test if a sheet name exists, 2) how do you create a sheet - I'm new, the more details/descriptions you provide the better. I am trying to figure out (what I assume to be) a simple function but I am drawing a blank. I am working with 2 workbooks at a time, and I need a ...
by Monoxide3009
19 Jul 2018, 15:49
Forum: Ask For Help
Topic: Comparing Dates
Replies: 2
Views: 108

Re: Comparing Dates

Playing around, I used a regex match to change the format of both dates to yyyymmdd then used EnvSub, and it seems to be working. I am going to try to adapt this to the main script. If anyone has suggestions or a better working process, please let me know still. What I came up with: var1 = %A_Now% ;...
by Monoxide3009
19 Jul 2018, 12:45
Forum: Ask For Help
Topic: Comparing Dates
Replies: 2
Views: 108

Comparing Dates

I have seen MANY forum posts on this, so I apologize, but I cannot get what I am doing wrong even with some of those answers. I am still quite new, so any advice would help if extremely detailed. Do not worry about condescending =p Right now, I am trying to compare a date pulled from an internal pro...
by Monoxide3009
19 Jun 2018, 16:55
Forum: Ask For Help
Topic: RegExMatch Help Topic is solved
Replies: 5
Views: 170

Re: RegExMatch Help Topic is solved

Welp, after you responded saying this should work, I started to copy over my entire code with the examples I have... Only to stop and notice that my variable FTL and FLT is not the same... I had been using a different variable the entire time. However, now that the variables are matched up and it is...

Go to advanced search