AutoHotkey Community

Monoxide3009

That worked. I actually had the shared in there before, but we had a migration and it was removed from the explorer location, so I both didnt think it was needed and eventually forgot about it. Thanks a lot. I have it working now. I just need to figure out a good way to standardize the process into ...

Monoxide3009

I cant really post too much (pretty strict NDA) - I believe this is what you are asking for.

Monoxide3009

I am new to checking error levels. I had no error popup, but I had the script track those two errors types, and I have: ErrorLevel = 1 A_LastError = 161 Not sure how to interpret this. EDIT - 161 apparently is bad path name. Im at a loss for why, as it SHOULD be correct. EDIT2 - I tried using the ma...

Monoxide3009

I can manually create a folder; I created the Automated_Production_Logs folder myself (manually). I also am not getting any sort of error, it simply isn't creating the folder. For personal testing to make sure I had things correct as far as I could tell, I tried the same lines using a C:\ location, ...

Monoxide3009

Hello All, I am trying to write to a network directory (shared drive at a company). For some reason, I cannot get it to work. I have seen a few forum posts claiming to have a similar issue, but I couldnt find any resolutions. I have a subroutine used in many of my current scripts that will create a ...

Monoxide3009

Thanks guys. I somewhat understand jeeswg's (and I know you have answered several of my questions before), but just me's response seems a lot more concise. I think the big key is the Format() function you both used; I hadnt seen that before. I am going to work with both the excel conversion and the ...

Monoxide3009

I have tried to research FormatTime and went over the wiki several times, but I am having a hard time utilizing this function. My overall goal is to take a date from excel, and compare it to the current date to get a day difference. My problem seems to stem from the format of each data point being d...

Monoxide3009

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.

Monoxide3009

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.)

Monoxide3009

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.

Monoxide3009

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...

Monoxide3009

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...

Monoxide3009

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...

Monoxide3009

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.

Monoxide3009

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...

Monoxide3009

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...

Monoxide3009

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...

Monoxide3009

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...

Monoxide3009

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...

Monoxide3009

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...

Search found 39 matches

Re: Write to Network Drive Topic is solved

Re: Write to Network Drive Topic is solved

Re: Write to Network Drive Topic is solved

Re: Write to Network Drive Topic is solved

Write to Network Drive Topic is solved

Re: FormatTime Issues Topic is solved

FormatTime Issues Topic is solved

Re: Multiple Contains Functions on Single Line Topic is solved

Re: Multiple Contains Functions on Single Line Topic is solved

Re: Multiple Contains Functions on Single Line Topic is solved

Re: Multiple Contains Functions on Single Line Topic is solved

Multiple Contains Functions on Single Line Topic is solved

Re: Single Cell - Multiple Output Topic is solved

Re: Single Cell - Multiple Output Topic is solved

Single Cell - Multiple Output Topic is solved

Re: Multiple RegEx Matches Topic is solved

Multiple RegEx Matches Topic is solved

Format Date - Excel Com

Re: ControlClick Help

Re: ControlClick Help