Search found 39 matches

by Monoxide3009
15 Apr 2019, 16:31
Forum: Ask For Help
Topic: Write to Network Drive Topic is solved
Replies: 9
Views: 124

Re: Write to Network Drive Topic is solved

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 ...
by Monoxide3009
15 Apr 2019, 16:17
Forum: Ask For Help
Topic: Write to Network Drive Topic is solved
Replies: 9
Views: 124

Re: Write to Network Drive Topic is solved

I cant really post too much (pretty strict NDA) - I believe this is what you are asking for.
by Monoxide3009
15 Apr 2019, 16:03
Forum: Ask For Help
Topic: Write to Network Drive Topic is solved
Replies: 9
Views: 124

Re: Write to Network Drive Topic is solved

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...
by Monoxide3009
15 Apr 2019, 15:18
Forum: Ask For Help
Topic: Write to Network Drive Topic is solved
Replies: 9
Views: 124

Re: Write to Network Drive Topic is solved

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, ...
by Monoxide3009
15 Apr 2019, 14:36
Forum: Ask For Help
Topic: Write to Network Drive Topic is solved
Replies: 9
Views: 124

Write to Network Drive Topic is solved

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 ...
by Monoxide3009
02 Apr 2019, 19:50
Forum: Ask For Help
Topic: FormatTime Issues Topic is solved
Replies: 5
Views: 266

Re: FormatTime Issues Topic is solved

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 ...
by Monoxide3009
02 Apr 2019, 18:57
Forum: Ask For Help
Topic: FormatTime Issues Topic is solved
Replies: 5
Views: 266

FormatTime Issues Topic is solved

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...
by Monoxide3009
07 Feb 2019, 16:35
Forum: Ask For Help
Topic: Multiple Contains Functions on Single Line Topic is solved
Replies: 9
Views: 430

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: 430

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: 430

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: 430

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: 430

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: 239

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: 239

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: 239

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: 159

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: 159

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: 129

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: 202

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: 202

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

Go to advanced search