Search found 19 matches

by shipaddicted
03 Jan 2019, 13:13
Forum: Ask For Help
Topic: Use AutoHotKey to Execute a Google Apps Script
Replies: 0
Views: 138

Use AutoHotKey to Execute a Google Apps Script

Long story short, I have a Google Apps script that runs on a google sheet when a form is submitted. I can't have the script bounded to the sheet because the sheet is on a Team Drive and the script creates a document from the sheet -- which I need to be created in MY drive. So the script itself is lo...
by shipaddicted
26 Dec 2018, 22:57
Forum: Ask For Help
Topic: How would you attack this GUI?
Replies: 0
Views: 161

How would you attack this GUI?

Ok. So I have just been assigned the "coordinator" of a new application system that will be spoonfed to AP. I will be fielding applications from all over the company, ensuring that all paperwork is in order and if approvals need to be obtained from other individuals/groups, that that is done. I inhe...
by shipaddicted
23 Dec 2018, 13:52
Forum: Ask For Help
Topic: How to run Powershell code using AHK
Replies: 6
Views: 1776

Re: How to run Powershell code using AHK

Nevermind! I found all the fields I need on a different thread!
by shipaddicted
22 Dec 2018, 21:27
Forum: Ask For Help
Topic: How to run Powershell code using AHK
Replies: 6
Views: 1776

Re: How to run Powershell code using AHK

This is working great for me so far. However, I would like the options of adding cc: and attachments. Does anyone know how I can add these variables? I have tried pmsg.Add pmsg.To.Add for the cc, both indicating ":= cc" to define the variable and adding ", cc," after the 2nd parameter in the functio...
by shipaddicted
03 Dec 2018, 22:58
Forum: Ask For Help
Topic: Extract only one type of file from zip file
Replies: 7
Views: 429

Re: Extract only one type of file from zip file

I still haven't had any luck, but now I have a cold, so my brain is a mess. I can't concentrate when I'm all drugged up. I'll have to shelve this for a couple of days. BRB.
by shipaddicted
02 Dec 2018, 15:55
Forum: Ask For Help
Topic: Extract only one type of file from zip file
Replies: 7
Views: 429

Re: Extract only one type of file from zip file

Run "C:\Program Files\7-Zip\7z.exe" e "C:\Users\Paige\Downloads\BF_2018-09-06.zip" -o "C:\Users\Paige\Desktop\Silhouettetemp\" *.svg -r I have tried several variations of this with no luck (changing which paths are put into quotes ). If it's working, I don't know where they're being extracted to -- ...
by shipaddicted
02 Dec 2018, 15:16
Forum: Ask For Help
Topic: Extract only one type of file from zip file
Replies: 7
Views: 429

Re: Extract only one type of file from zip file

I'm looking for .svg files - I'm not following how this would extract those. Would I substitute *.exe with *.svg ??

Thanks!
by shipaddicted
02 Dec 2018, 13:40
Forum: Ask For Help
Topic: Extract only one type of file from zip file
Replies: 7
Views: 429

Extract only one type of file from zip file

I frequently download zip files that contain maybe 40 different folders inside, each containing several different file types of the same graphic. I only need to extract the .Svg files out - the rest is garbage to me (.Jpg, .Ai, .dxf, etc.), even the parent folders. How can I do this with AutoHotKey?...
by shipaddicted
12 Nov 2018, 17:47
Forum: Tutorials
Topic: Using Selenium with AutoHotkey- Cross browser automation!
Replies: 95
Views: 29992

Re: Using Selenium with AutoHotkey- Cross browser automation!

Immediately after posting I thought of another thing to try -- IfWinNotExist -- which worked. I wasn't going to bother with it since the documentation said it's deprecated, but Win[Not]Exist() didn't work either, so I thought, why not? So now I at least have this functioning pretty well: #!2:: IfWin...
by shipaddicted
12 Nov 2018, 17:44
Forum: Tutorials
Topic: Using Selenium with AutoHotkey- Cross browser automation!
Replies: 95
Views: 29992

Re: Using Selenium with AutoHotkey- Cross browser automation!

I just started messing with this Selenium stuff last night. So far, it works great. I'm hoping I'll be allowed to use it on my work computer to automate a bunch of the useless crap we have to go through to complete the simplest of tasks. Anyhow, I'm trying to mash up a couple of scripts from earlier...
by shipaddicted
10 Nov 2018, 12:21
Forum: Ask For Help
Topic: Auto-login problem
Replies: 18
Views: 1020

Re: Auto-login problem

I'm dealing with the same exact issue! I FINALLY, FINALLY got auto logins working on most of my sites, but I have a couple that are being stubborn. But thanks to this post, this is what I cobbled together: gosite := "https://ess.impellam.com/default.aspx" GoSub, Nav Sleep, 500 wb.Document.getElement...
by shipaddicted
01 Nov 2018, 22:53
Forum: Ask For Help
Topic: GUI for scripts - If Multiple Selections Allowed, Will They Run Concurrently?
Replies: 2
Views: 268

Re: GUI for scripts - If Multiple Selections Allowed, Will They Run Concurrently?

Awesome!! I cobbled my script together from the Button script I had just to see what would happen -- and it turns out they do run linearly **for the most part**. They did tend to step over each other a little, especially when the document SaveAs dialog was open. I kept having to add more Sleeps, whi...
by shipaddicted
30 Oct 2018, 23:19
Forum: Ask For Help
Topic: GUI for scripts - If Multiple Selections Allowed, Will They Run Concurrently?
Replies: 2
Views: 268

GUI for scripts - If Multiple Selections Allowed, Will They Run Concurrently?

I have a GUI that I created for work that runs all our "Friday Download" files and saves them to our hard drive. Right now, the user has to click on each button for its report individually, which is still a VAST improvement over the chicanery that we had to get into previously, but you're still kind...
by shipaddicted
20 Oct 2018, 10:36
Forum: Scripts and Functions
Topic: Automatically Restore Last Window Position For Each Process
Replies: 50
Views: 8816

Re: Automatically Restore Last Window Position For Each Process

Yep. Must have been sun spots. Or gremlins or rogue drones or something. I can see the line breaks now. Okay...I'm not sure if it's just me or maybe there are sun spots interfering with my internetal reception, but I don't see any line breaks in the code. I'd really like to try it out -- it sounds l...
by shipaddicted
19 Oct 2018, 21:13
Forum: Scripts and Functions
Topic: Automatically Restore Last Window Position For Each Process
Replies: 50
Views: 8816

Re: Automatically Restore Last Window Position For Each Process

Okay...I'm not sure if it's just me or maybe there are sun spots interfering with my internetal reception, but I don't see any line breaks in the code. I'd really like to try it out -- it sounds like something I would LOVE ... but I'm trying to add in the line breaks manually and Ahk is not very hap...
by shipaddicted
03 Oct 2018, 12:14
Forum: Ask For Help
Topic: Embedding AHK Functions in an Excel Add-in??
Replies: 3
Views: 249

Re: Embedding AHK Functions in an Excel Add-in??

[quote="tmplinshi"]Instead of a Excel Add-in, maybe you could.. Make a separate GUI window, with some buttons in it. When buttons clicked, it connects to the active excel window by ComObjActive("Excel.Application") , then do the stuffs you want to do. Use hotkeys. Embed MS Office document in GUI Cre...
by shipaddicted
02 Oct 2018, 22:08
Forum: Ask For Help
Topic: Embedding AHK Functions in an Excel Add-in??
Replies: 3
Views: 249

Embedding AHK Functions in an Excel Add-in??

Hi ... first off, I have been using vba and ahk for my own purposes for a couple of years now, but now I've been asked to share my stuff with my coworkers. I am happy to share my stuff (who doesn't like to brag??) 'm having a hard time programming what I do and packaging it all up so someone who is ...
by shipaddicted
15 Sep 2016, 00:17
Forum: Scripts and Functions
Topic: Text Toolbox 1.1
Replies: 8
Views: 3179

Re: Text Toolbox 1.1

Capping the first letter of all words would be called Initial Caps as opposed to CamelCase is Initial Caps with no spaces between the words (first letter not/capped depending on your use. ;)
by shipaddicted
15 Jul 2016, 20:18
Forum: Ask For Help
Topic: Need some guidance on sending values in Excel to my ahk clipboard manager
Replies: 0
Views: 462

Need some guidance on sending values in Excel to my ahk clipboard manager

Hello AHKers. I am a fairly new user (just a few weeks) and I'm trying to script some things to make my work life a little easier. I have done some pretty cool scripts on my own, but I keep running into dead ends on my excel/ahk script. Basically, what I need is this: 1. I get a daily Excel document...

Go to advanced search