Search found 54 matches
- 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...
- 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...
- 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
Thanks. I will give it a try.mikeyww wrote: ↑06 Oct 2020, 12:52This will trap the key so that it does nothing.Code: Select all
#e::Return
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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 ...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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 ...
- 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.
- 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...
- 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, ...
- 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 ...