Search found 24 matches

by Sergio
27 Sep 2016, 13:11
Forum: Ask For Help
Topic: URLDownloadToFile with original file name?
Replies: 6
Views: 426

Re: URLDownloadToFile with original file name?

Thanks Garry. I just want to reiterate that it is an API & I do not know at the time of the request what the filename of the response will be. So my request is a lot like this: http://thesite.com/api/foo?paramter=bar And the response file is named: 74bfb59b-8410-42a7-83ad-fca268a5b49c.xlsx
by Sergio
27 Sep 2016, 11:46
Forum: Ask For Help
Topic: URLDownloadToFile with original file name?
Replies: 6
Views: 426

URLDownloadToFile with original file name?

I want to use AHK to create a small UI for querying an API. The API generates a random UUID for each download & I just need to know the name of the file which I've downloaded. The problem is that URLDownloadToFile forces you to specify the filename upon downloading. Is it possible to get the fil...
by Sergio
07 Sep 2016, 15:23
Forum: Ask For Help
Topic: Getting device properties from USB (Apple Ipad)
Replies: 0
Views: 220

Getting device properties from USB (Apple Ipad)

I need to collect the serial number from several different Apple Ipads. I see that if I go to the properties of my connected USB device, I see a trait called "Serial Number" and a value. How would I collect that value via the command line? I know that I can make the windows open & righ...
by Sergio
31 May 2016, 16:40
Forum: Scripts and Functions
Topic: Compare arrays & create final array with deltas
Replies: 0
Views: 223

Compare arrays & create final array with deltas

I happened to need this & couldn't find anyone who wrote it out, so I figured I'd add my own. This script takes two multidimensional arrays and compares the first two columns as key/value pairs. I could have used a dictionary, but ADOSQL outputs tuples - which is what I needed - so I kept it all...
by Sergio
12 Apr 2016, 14:51
Forum: Ask For Help
Topic: Closing (invisible) excel after writing
Replies: 2
Views: 146

Re: Closing (invisible) excel after writing

wolf_II wrote:Xl.Quit ?


I've been Googling answers for over a year & haven't needed a single question. Of all things, this one stumped me.

That was it. Thanks
by Sergio
12 Apr 2016, 14:29
Forum: Ask For Help
Topic: Closing (invisible) excel after writing
Replies: 2
Views: 146

Closing (invisible) excel after writing

I have to create the simplest module to generate excel files. It works well as is, but I don't know how to close the connection once I've written to the file. It is invisible so I can't just alt-F4. Can someone tell me how to do it? ID := "1234567" saveFileName = %A_Desktop%\ID-%ID%.xlsx T...
by Sergio
04 Oct 2015, 11:53
Forum: Ask For Help
Topic: Listview LV_GetText() get second column?
Replies: 2
Views: 282

Re: Listview LV_GetText() get second column?

I literally facepalmed.

Thank you very much! I almost went through the painstaking work of looping through the array that populated the LV just to get more data...
by Sergio
04 Oct 2015, 11:34
Forum: Ask For Help
Topic: Listview LV_GetText() get second column?
Replies: 2
Views: 282

Listview LV_GetText() get second column?

Is there any way to get any other data from the listview other than the first column?
by Sergio
20 Jan 2015, 15:08
Forum: Ask For Help
Topic: How to change the user agent in IE with AHK
Replies: 2
Views: 448

Re: How to change the user agent in IE with AHK

Thanks! Ironically, I kept searching this forum because I thought it was more complicated than something that would come up on that one.

Good to see there's healthy commingling though. Thanks again, it's always appreciated.
by Sergio
20 Jan 2015, 10:02
Forum: Ask For Help
Topic: How to change the user agent in IE with AHK
Replies: 2
Views: 448

How to change the user agent in IE with AHK

I want to use AHK to operate in the mobile version of a website. To do that, I need IE (for the COM access) and IE can change the user agent (below). I can't find (or figure out) how to change the User Agent through the command line. I could hit F12 & manipulate the mouse, but I'd prefer to do i...
by Sergio
09 Jul 2014, 02:15
Forum: Ask For Help
Topic: How to use Web Browser object when Navigation is separate
Replies: 2
Views: 446

How to use Web Browser object when Navigation is separate

Here I have a loop within a loop. In the outer loop I call the Navigate function to go to a given page. The inner loop also needs to navigate, but I won't know the URL in advance, so I click on a page. Based on that click, I need it to wait in the same way that Navigate makes it wait. However when I...
by Sergio
26 Mar 2014, 16:49
Forum: Ask For Help
Topic: Change Colors in Excel file with COM
Replies: 4
Views: 1286

Re: Change Colors in Excel file with COM

I was hoping you'd say that it'd be easy! I have a macro I like. It just filters ranges of text & changes the background color for the most part (below). I guess the big question is how do I implement a VBA macro on an Excel sheet? Sub Macro2() ' ' Macro2 Macro ' ' Select...
by Sergio
26 Mar 2014, 15:00
Forum: Ask For Help
Topic: Change Colors in Excel file with COM
Replies: 4
Views: 1286

Change Colors in Excel file with COM

I have started to write files to excel through COM using the code below. My one issue now is that I'd like to be able to change background & foreground colors as well as font markup (to make it bold). Is that possible through COM as well? If so, can someone point me to a tutorial? NewFileName :=...
by Sergio
24 Mar 2014, 16:41
Forum: Ask For Help
Topic: [RESOLVED] Class Stopped Working After Move to Separate File
Replies: 2
Views: 492

Re: [RESOLVED] Class Stopped Working After Move to Separate

We don't formally divide them into classes. So the return doesn't just return that division of code. It returns the entire code as if it were all in one file in whatever order you had it.
by Sergio
24 Mar 2014, 16:39
Forum: Offtopic
Topic: any AHK mail management or spam filter scripts?
Replies: 4
Views: 993

Re: any AHK mail management or spam filter scripts?

There isn't a full fledged mail client written in AHK. It's possible to do, but it's not the best language for it.

For Gmail though, you can read each of your e-mails via API. You can systematically scan for blacklist e-mails or keywords & delete them. But if it's not Gmail, I don't know.
by Sergio
14 Oct 2013, 09:34
Forum: Ask For Help
Topic: AutoHotKey & SQL in a separate file...
Replies: 7
Views: 1240

Re: AutoHotKey & SQL in a separate file...

Afterwards, I realized I could just make each variable into a function and pass it the required parameters. It's a bit more work, but it allows me to have all of the SQL on a separate file. Some of those queries are a bit long and I'd rather have them organized. Yep - that would be a better setup: ...
by Sergio
12 Oct 2013, 22:32
Forum: Ask For Help
Topic: AutoHotKey & SQL in a separate file...
Replies: 7
Views: 1240

Re: AutoHotKey & SQL in a separate file...

I did not explain it properly. Actually, I do not need SQL to explain this. Lets say my code looks like this File1: endVar := "Var 1 is: |" . var1 . "|`nVar2 is: |" . var2 . "|" File2: #Include, File1.ahk var1 := "ABC" var2 := "123" MsgBox, % endVar ...
by Sergio
11 Oct 2013, 14:46
Forum: Ask For Help
Topic: AutoHotKey & SQL in a separate file...
Replies: 7
Views: 1240

AutoHotKey & SQL in a separate file...

I use a MySQL database as the backend for a particularly large AHK software. I used to declare a query & run it in-line, but to make life easier for myself I created a separate document and just included it into my code. It's a good idea in theory, but it created nightmares in practice. The bigg...
by Sergio
09 Oct 2013, 17:02
Forum: Scripts and Functions
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 731
Views: 283526

Re: Macro Creator v4.0.0 - Automation Tool (Recorder & Write

Wow! I discovered your software fairly recently and it's grown by leaps and bounds! In the past I had suggested it to absolute AHK beginners who don't know code, but it's definitely more than that. Needless to say, you're an asset to the community. My one suggestion, if you'll bear it, is more tutor...
by Sergio
09 Oct 2013, 11:04
Forum: Ask For Help
Topic: RegEx replace equivalent for NOT
Replies: 5
Views: 1534

Re: RegEx replace equivalent for NOT

Thanks!

Go to advanced search