Search found 17 matches

by SpencerH
12 Mar 2019, 01:06
Forum: Ask For Help
Topic: Moving items in outlook on delivery
Replies: 0
Views: 164

Moving items in outlook on delivery

I have a strange problem in outlook where items are going to junk that should not. The rules do not allow me to do anything with the junk folder or items going there. Can I create an AHK that moves items on delivery? from Junk --> Inbox I have used the ObjCom a little in the past but I have no clue ...
by SpencerH
27 Oct 2018, 11:23
Forum: Ask For Help
Topic: Chrome has marked AutoHotKey Dangerous
Replies: 2
Views: 336

Chrome has marked AutoHotKey Dangerous

It is now a huge hassle to download AHK on chrome it says the file is dangerous and I will have tons of issues if I proceed. Of course I would proceed because I have been a user for years but why all of the sudden is it doing this?
by SpencerH
28 Mar 2018, 15:23
Forum: Ask For Help
Topic: Excel Com Use... Finding it very confusing
Replies: 12
Views: 1285

Re: Excel Com Use... Finding it very confusing

Everything was looking really good but on my development machine with Excel 2016, but when I tried to test to the point we are right now none of the "move" operations worked on the Excel 2007 version. So what do I need to change here? WinActivate, Microsoft Excel - scrape.xlsx, xlApp := ComObjActive...
by SpencerH
28 Mar 2018, 13:53
Forum: Ask For Help
Topic: Excel Com Use... Finding it very confusing
Replies: 12
Views: 1285

Re: Excel Com Use... Finding it very confusing

You can ignore this post as I found several typos. (midday slump) :D My new code is starting to look a little hairy and does some funny things when I add in the last move operation. Can you see what I am doing wrong here? Row_EmptyBelowData1 := xlApp.Sheets(1).UsedRange.Find("*",,,,,2).Offset(-1,0)...
by SpencerH
24 Mar 2018, 11:09
Forum: Ask For Help
Topic: Excel Com Use... Finding it very confusing
Replies: 12
Views: 1285

Re: Excel Com Use... Finding it very confusing

Now I have figured out how to get row counts using this #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. ; #Warn ; Enable warnings to assist with detecting common errors. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. Se...
by SpencerH
24 Mar 2018, 10:40
Forum: Ask For Help
Topic: Excel Com Use... Finding it very confusing
Replies: 12
Views: 1285

Re: Excel Com Use... Finding it very confusing

@FanaticGuru Thank you!!! based on your example I was able to take it to the next step and get rid of all the rows and columns that need to be gone. Not that you need to see this but this is what I have so far #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. ; ...
by SpencerH
23 Mar 2018, 11:25
Forum: Ask For Help
Topic: Excel Com Use... Finding it very confusing
Replies: 12
Views: 1285

Re: Excel Com Use... Finding it very confusing

I have still been stuck on trying to get this to work. I have noteven been able to get the simple examples to work. Here is what steps I am trying to do as simply as I think I can explain them at this point. I'd say I'm not entirely sure what all the things should be called that I am doing. 1. Delet...
by SpencerH
10 Feb 2018, 18:07
Forum: Scripts and Functions
Topic: [Script] KeypressOSD - Display key press on screen
Replies: 613
Views: 94393

Re: [Script] KeypressOSD - Display key press on screen

@robodesign

I was thinking it would be helpful to have this OSD display what the "my" script is doing as it does it. Kind of a debugging tool.
by SpencerH
10 Feb 2018, 18:04
Forum: Ask For Help
Topic: Excel Com Use... Finding it very confusing
Replies: 12
Views: 1285

Re: Excel Com Use... Finding it very confusing

Using what you posted I'm trying to build something that will delete a column. This is as far as I have gotten so far and it is not working yet: #Warn ;xlApp := ComObjGet("C:\Users\mrhob\Desktop\AHK Testing\test.xlsx") xlApp := ComObjActive("Excel.Application") loop, 3 xlWS%a_index% := xlApp.Sheets(...
by SpencerH
10 Feb 2018, 03:24
Forum: Ask For Help
Topic: Excel Com Use... Finding it very confusing
Replies: 12
Views: 1285

Excel Com Use... Finding it very confusing

I'm watching videos on YouTube and reading the tutorials here and in other places, but I'm just not getting it. Right now if I was going to just use the GUI I would click or select cell A:3 of sheet 2 then I would press {ctrl down}{shift down}{end}{shift up}{ctrl up}. then I would copy that data to ...
by SpencerH
04 Feb 2018, 23:03
Forum: Scripts and Functions
Topic: [Script] KeypressOSD - Display key press on screen
Replies: 613
Views: 94393

Re: [Script] KeypressOSD - Display key press on screen

Is there some way to make my script show what it is doing like this? I think this could be really helpful
by SpencerH
30 Jan 2018, 20:08
Forum: Ask For Help
Topic: Classes and If cases not sure if I am doing this right
Replies: 2
Views: 398

Re: Classes and If cases not sure if I am doing this right

I had originally placed it for testing purposes, but now it doesn't seem to work... I'm playing with it and chatting with ppl on discord so I will post an update if I learn something. for future reference to get my class/method to work I needed to use the following format if (WinExist( this.QbMainWi...
by SpencerH
29 Jan 2018, 17:43
Forum: Ask For Help
Topic: Classes and If cases not sure if I am doing this right
Replies: 2
Views: 398

Classes and If cases not sure if I am doing this right

I'm trying to make my code check for the window state and then do an action based on that. I had it working until I put it in the class. I wasn't sure if I had too many if and if I made and called my class correctly. #SingleInstance force Escape:: ExitApp SetTitleMatchMode, 2 CoordMode, Mouse, Clien...
by SpencerH
22 Jan 2018, 15:11
Forum: Ask For Help
Topic: Inconsistent Window detection possible script error
Replies: 4
Views: 632

Re: Inconsistent Window detection possible script error

I'm taking this part by part now trying to work it out. Originally I had this: SetTitleMatchMode, 2 IfWinExist, QuickBooks Enterprise Solutions: Contractor 16.0, , , { WinActivate WinMaximize MsgBox It found the Open Window! } IfWinExist, , An empty QuickBooks window already exists, , { WinActivate ...
by SpencerH
21 Jan 2018, 19:07
Forum: Ask For Help
Topic: Inconsistent Window detection possible script error
Replies: 4
Views: 632

Re: Inconsistent Window detection possible script error

In general, I am trying to make this script more robust so that if something fails or "changes" it can continue. After posting on the discord and seeing I could use a loop for ImageSearch, it makes me think I could use a bunch of conditional ImageSearch expressions to keep things on track is this fl...
by SpencerH
19 Jan 2018, 11:25
Forum: Ask For Help
Topic: Inconsistent Window detection possible script error
Replies: 4
Views: 632

Re: Inconsistent Window detection possible script error

I wasn't sure if this was the issue I am running into: https://autohotkey.com/docs/Tutorial.htm#s13 So I changed the code to remove the if condition nested in the else. My script seemed to be a little more consistent but seems to skip ahead. So now i have this: IfWinExist, ahk_exe qbw32.exe, { WinAc...
by SpencerH
18 Jan 2018, 16:31
Forum: Ask For Help
Topic: Inconsistent Window detection possible script error
Replies: 4
Views: 632

Inconsistent Window detection possible script error

Below you can see my script which I think I have messed up because I can detect the window and get the desired behavior most of the time but not all of the time. Also when QuickBooks detects another running window it will automatically switch to that window. I just wasn't sure of what I am doing wro...

Go to advanced search