Search found 54 matches

by Monoxide3009
07 Jan 2021, 12:54
Forum: Ask For Help
Topic: ComObj connection issues
Replies: 4
Views: 141

ComObj connection issues

Hello all, As is tradition, I will lead with I am self taught and now great with a lot of these things, so being as descriptive as possible in responses helps greatly =) I am having an issue where I wrote a script that works fine for me all the way through, but for a coworker it is not. The issue is...
by Monoxide3009
08 Oct 2020, 17:01
Forum: Ask For Help
Topic: File Explorer randomly pops up
Replies: 8
Views: 131

Re: File Explorer randomly pops up

I just came back to say that the #e:: return didnt work, but you beat me to it. It happened again today when I wasnt paying attention so I wasnt able to catch anything (though most everything I run is supposed to be set it and forget it so I 'never' catch it). As far as sending {text} I could try th...
by Monoxide3009
06 Oct 2020, 14:30
Forum: Ask For Help
Topic: File Explorer randomly pops up
Replies: 8
Views: 131

Re: File Explorer randomly pops up

mikeyww wrote:
06 Oct 2020, 12:52

Code: Select all

#e::Return
This will trap the key so that it does nothing.
Thanks. I will give it a try.
by Monoxide3009
06 Oct 2020, 12:31
Forum: Ask For Help
Topic: File Explorer randomly pops up
Replies: 8
Views: 131

Re: File Explorer randomly pops up

Pressing #e summons Explorer. Is it possible that you are inadvertently generating that sequence? I don't believe so. I have never used # for anything. In fact, I had to look up what # actually does. What I am doing is running the same functions over and over (hundreds of times). There is no real v...
by Monoxide3009
06 Oct 2020, 10:57
Forum: Ask For Help
Topic: File Explorer randomly pops up
Replies: 8
Views: 131

File Explorer randomly pops up

Hello All, I write some fairly basic code for my company that simulates a user to speed up production and reduce type errors. Generally I have our internal program and a com connected spreadsheet. Programs I write typically run fine, but once in a while the file explorer pops up to the general locat...
by Monoxide3009
12 Nov 2019, 10:27
Forum: Ask For Help
Topic: Excel ComObj Error Topic is solved
Replies: 6
Views: 635

Re: Excel ComObj Error Topic is solved

EDIT - Using just .value did work, but gave several decimal places, which is what I feared. I made a work around using regexreplace, but I feel like I am just creating more work to work around as said below. Its working, so I dont "need" to make it better/more efficient, but I am always open to sugg...
by Monoxide3009
11 Nov 2019, 17:31
Forum: Ask For Help
Topic: Excel ComObj Error Topic is solved
Replies: 6
Views: 635

Excel ComObj Error Topic is solved

Hello All, I have a weird issue I have never come across before (and I use excel comobj in about 90% of my scripts). I am getting a notification that the data from excel cant be pulled, and the error seems like it cant even register that the cell even exists. I know the com is set correct, as the ot...
by Monoxide3009
14 Oct 2019, 11:09
Forum: Ask For Help
Topic: Regex Issues
Replies: 5
Views: 673

Re: Regex Issues

Thank you all for your suggestions. I can honestly say, I dont understand any of them (yet), but I will see what I can decipher today and see what I can get working. One guy mentioned that it would catch on any match - I am aware of this. The pattern I gave will only ever have one match, and this is...
by Monoxide3009
11 Oct 2019, 17:00
Forum: Ask For Help
Topic: Regex Issues
Replies: 5
Views: 673

Regex Issues

Hey all, I have some regex that works in a regex tester (https://regex101.com/) but does not work within AHK. I know where the issue lies, but not why or how to fix it. Any advice would be appreciated. Text exmaple: - CASE TYPE TOTALS: ----------------- 1 #1 PALLET 1 QUARTR CUT 63 - MARKS: - FOR ULT...
by Monoxide3009
27 Sep 2019, 11:10
Forum: Ask For Help
Topic: Pulling Data from PDF - Regex Loop Issues
Replies: 4
Views: 582

Re: Pulling Data from PDF - Regex Loop Issues

You are executing your regex on the complete PDF. You could split the PDF in separate pages before and them loop trough them. Unfortunately, I am building this to accomodate another departments process. I have no choice but to use what is provided, and splitting them up is not an option (I already ...
by Monoxide3009
26 Sep 2019, 10:42
Forum: Ask For Help
Topic: Pulling Data from PDF - Regex Loop Issues
Replies: 4
Views: 582

Pulling Data from PDF - Regex Loop Issues

Hello All, First, forgive me but I don't know the best way to ask my question , so were going to go on a roller coaster ride together. I am working on a project I have mostly done; I am pulling text data from a PDF. No problems with that in general. My current process is to copy the entire PDF, then...
by Monoxide3009
27 Jun 2019, 12:35
Forum: Ask For Help
Topic: FileAppend and CSV (tab to new cell?) Topic is solved
Replies: 5
Views: 967

Re: FileAppend and CSV (tab to new cell?) Topic is solved

Yes, thanks. I think it makes a little bit of sense. Though to your point, it is an existing file. The ultimate goal is to dump data into a master log under certain circumstances. This master log will then be utilized by some less than computer literate people, so I need to make it as simple as poss...
by Monoxide3009
27 Jun 2019, 11:34
Forum: Ask For Help
Topic: FileAppend and CSV (tab to new cell?) Topic is solved
Replies: 5
Views: 967

Re: FileAppend and CSV (tab to new cell?) Topic is solved

try: FileAppend, %Variable1% `, %Variable2% `n, xyz.csv Thanks, flyingDman, this worked. Though I dont fully understand why. Is it that a csv file automatically "tabs" when there is a comma separator? This is everything I need to accomplish my goals, I would just like a small explanation if you can...
by Monoxide3009
26 Jun 2019, 12:50
Forum: Ask For Help
Topic: FileAppend and CSV (tab to new cell?) Topic is solved
Replies: 5
Views: 967

FileAppend and CSV (tab to new cell?) Topic is solved

Hello All, I am not sure this is possible, and all research/testing I have done says it isnt, but I wanted to check. I am trying to file append a csv file and have variables put into multiple cells. Being this is a csv, I am not sure I can. I tried using `t and %A_Tab% but it is putting everything i...
by Monoxide3009
07 Jun 2019, 12:50
Forum: Ask For Help
Topic: Simple OR Syntax
Replies: 2
Views: 388

Simple OR Syntax

Hello All, I am just looking for a more concise way to write the following line (I think this looks clunky and ugly, but everything I have tried doesnt work). Note - This works, I am just trying to find a better process: if ((IMG = "JFK") or (IMG = "ORD") or (IMG = "LAX") or (IMG = "DFW")) and (PROJ...
by Monoxide3009
15 Apr 2019, 16:31
Forum: Ask For Help
Topic: Write to Network Drive Topic is solved
Replies: 9
Views: 1123

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

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

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

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

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

Go to advanced search