Search found 273 matches

by WeThotUWasAToad
22 Mar 2020, 18:12
Forum: Ask For Help
Topic: Script to quickly navigate between multiple Excel windows
Replies: 35
Views: 981

Re: Script to quickly navigate between multiple Excel windows

I've got 8 Excel files running right now. I activated one of them; then, while keeping the mouse over it, I captured a screenshot of Window Spy. The result can be seen here: https://imgur.com/oPlJ40R. Thanks. That shows why my version didn't work with Excel 2010. Try this version with the WinTitle ...
by WeThotUWasAToad
22 Mar 2020, 16:34
Forum: Ask For Help
Topic: Script to quickly navigate between multiple Excel windows
Replies: 35
Views: 981

Re: Script to quickly navigate between multiple Excel windows

I've never been able to figure out how to upload a screenshot here so following is a link to an image Hi Steve, Here are the steps to embed an image at this forum so that you (and we) don't have to deal with imgur (or any image-sharing site): (1) Click the Full Editor & Preview button under the Qui...
by WeThotUWasAToad
22 Mar 2020, 13:17
Forum: Ask For Help
Topic: Script to quickly navigate between multiple Excel windows
Replies: 35
Views: 981

Re: Script to quickly navigate between multiple Excel windows

Thanks everyone for your contributions. OK. Probably outdated Excel version... Yes, as mentioned in the OP, I'm using Excel 2010 in Windows 10.* __________________________________________________ …it works fine here with Excel 2010, but I don't know why it's not working for him. Regards, Joe Precise...
by WeThotUWasAToad
21 Mar 2020, 21:40
Forum: Ask For Help
Topic: Script to quickly navigate between multiple Excel windows
Replies: 35
Views: 981

Re: Script to quickly navigate between multiple Excel windows

This code Xl := ComObjActive("Excel.Application") for x in xl.Workbooks msgbox % x.name should show all open spreadsheets, one after the other, not just the first one. Make sure you have a few open before launching the script. Please confirm. If it does not work, @JoeWinograd 's script won't work e...
by WeThotUWasAToad
21 Mar 2020, 21:34
Forum: Ask For Help
Topic: Script to quickly navigate between multiple Excel windows
Replies: 35
Views: 981

Re: Script to quickly navigate between multiple Excel windows

Hi Steve, Try the attached script. I assume that you want to include it in your AutoHotkey start-up script with all of your AHK hotkeys/hotstrings so I made it such that you can simply copy/paste it in there as is (or running it as its own file works, too). I made the hotkey Alt+Ctrl+F3, but, as al...
by WeThotUWasAToad
21 Mar 2020, 14:59
Forum: Ask For Help
Topic: Script to quickly navigate between multiple Excel windows
Replies: 35
Views: 981

Re: Script to quickly navigate between multiple Excel windows

Assuming COM works just fine in Excel 2010, this is a wrapper around those few lines above: Xl := ComObjActive("Excel.Application") #\:: gui, margin, 0,0 gui, -caption gui, add, ListView, x0 y0 w150 r20 grid gLaunch,Active Excel Spreadsheets for x in xl.Workbooks lv_add("",x.name) gui, show return ...
by WeThotUWasAToad
21 Mar 2020, 14:27
Forum: Ask For Help
Topic: Script to quickly navigate between multiple Excel windows
Replies: 35
Views: 981

Re: Script to quickly navigate between multiple Excel windows

Here's a script to get you started. It creates buttons for each of the Excel windows open when the script is run. If you open or close Excel windows, hit the Refresh button. Other improvements could be made to it such as auto-refresh when the windows change. Tested with the latest version of Office...
by WeThotUWasAToad
21 Mar 2020, 14:22
Forum: Ask For Help
Topic: Script to quickly navigate between multiple Excel windows
Replies: 35
Views: 981

Re: Script to quickly navigate between multiple Excel windows

Thanks for the replies. First, because your using Excel 2010, lets see if this works. Open a few excel files and launch this: Xl := ComObjActive("Excel.Application") for x in xl.Workbooks msgbox % x.name Yes, that seems to work great. It shows a MsgBox with the filename of the first Excel thumbnail;...
by WeThotUWasAToad
19 Mar 2020, 20:37
Forum: Ask For Help
Topic: Script to quickly navigate between multiple Excel windows
Replies: 35
Views: 981

Script to quickly navigate between multiple Excel windows

Hello, Is it possible to create a script which, upon activation with a hotkey, shows a list of all Excel files (workbooks) currently open on your system, and then by clicking one of the filenames, causes that particular workbook to become the active window on your screen? I am still using Excel 2010...
by WeThotUWasAToad
10 Jan 2020, 23:35
Forum: Ask For Help
Topic: Combine [WinSet, Region…] & [WinSet, Transparent…] commands
Replies: 5
Views: 301

Re: Combine [WinSet, Region…] & [WinSet, Transparent…] commands

Thanks for the reply. The following script works great: SetTitleMatchMode, 2 WinMove, DragonBar,, 1880, 1050, 805, 60 WinSet, Region, 25-15 W30 H30 E, DragonBar Return Interestingly, the transparency persists after closing the script. Why is that and how can that be changed (ie so the entire DragonB...
by WeThotUWasAToad
09 Jan 2020, 14:33
Forum: Ask For Help
Topic: Combine [WinSet, Region…] & [WinSet, Transparent…] commands
Replies: 5
Views: 301

Combine [WinSet, Region…] & [WinSet, Transparent…] commands

Hello, I'm trying to hide all but a small circle of a window using the WinSet, Region... and WinSet, Transparent... commands: https://www.autohotkey.com/docs/commands/WinSet.htm#Region https://www.autohotkey.com/docs/commands/WinSet.htm#Transparent The window is the DragonBar for the voice recogniti...
by WeThotUWasAToad
24 Dec 2019, 17:24
Forum: Ask For Help
Topic: Script skips some steps
Replies: 2
Views: 208

Re: Script skips some steps

That was exactly the problem. I didn't think about the sleep in the subroutine overwriting the previous sleep but it makes perfect sense. Thanks
by WeThotUWasAToad
24 Dec 2019, 12:09
Forum: Ask For Help
Topic: Script skips some steps
Replies: 2
Views: 208

Script skips some steps

Hello, Can someone tell me what's wrong with this script? Each time I try running it, it skips (fails to execute) several steps. Here's the full script: F1:: ;Sleep lengths: short := 999 medium := 1999 long := 5299 ;Loop, # { CoordMode, Mouse, Screen GoSub, CaptureNotepadLine ; includes activating n...
by WeThotUWasAToad
21 Aug 2019, 22:51
Forum: Ask For Help
Topic: Round off variables to whole integers
Replies: 4
Views: 546

Round off variables to whole integers

Hello, What command will round off a number to a whole integer? For example, a script I'm using has to calculate a variable by dividing two other variables. var1 := 4 var2 := 5 var3:= var2 / var1 As a result, the variable sometimes ends up with decimal points (eg 1.25). Then, because the decimal val...
by WeThotUWasAToad
21 Aug 2019, 22:42
Forum: Ask For Help
Topic: Script freaks out when it runs
Replies: 4
Views: 626

Re: Script freaks out when it runs

Thanks!

That is just what I need. It works great now.
click does not support expressions
The key was discovering that Click parameters do not support expressions.
by WeThotUWasAToad
21 Aug 2019, 18:13
Forum: Ask For Help
Topic: Script freaks out when it runs
Replies: 4
Views: 626

Script freaks out when it runs

Hello, Can someone help me understand why this script goes crazy when I run it? It is a looped script which includes a Left mouse click at one of 12 locations depending on the circumstances. Fortunately, the click locations are evenly spaced vertically so I initially calculated the 12 vertical locat...
by WeThotUWasAToad
20 Aug 2019, 17:45
Forum: Ask For Help
Topic: Insert Sleep commands in single line of script
Replies: 14
Views: 1189

Re: Insert Sleep commands in single line of script

I just discovered a problem.

The above script works great but apparently it's got a limit on how many records can be entered. I don't know what the limit is but I entered 88 records and got an error pop-up saying:
Expression too long
Any way to get around that?

Thanks
by WeThotUWasAToad
20 Aug 2019, 12:59
Forum: Ask For Help
Topic: Insert Sleep commands in single line of script
Replies: 14
Views: 1189

Re: Insert Sleep commands in single line of script

Awesome! This is very cool and it works great. Thanks for the patience. (This is one of those scripts which I can put to work right away and learn it as I go.) I usually use a Loop command when I've got a repeating process but this one threw me a curve because of the multiple/changing field entries....
by WeThotUWasAToad
20 Aug 2019, 12:04
Forum: Ask For Help
Topic: Insert Sleep commands in single line of script
Replies: 14
Views: 1189

Re: Insert Sleep commands in single line of script

I pasted the script just as you had it (and added a hotkey F1:: at the beginning): F1:: People := [["Hugh", "Aug", "10", "1838"] , ["C W", "Sep", "5", "1848"] , ["Eliza", "May", "20", "1892"] , ["Robert", "Aug", "15", "1869"] , ["William C", "Aug", "8", "1937"]] for each, Person in People robisonSen...
by WeThotUWasAToad
20 Aug 2019, 10:45
Forum: Ask For Help
Topic: Insert Sleep commands in single line of script
Replies: 14
Views: 1189

Re: Insert Sleep commands in single line of script

Thanks for the extra info and links. With the above script, is it possible to include a looping function for input of multiple records? I don't know how to structure it, but so it contained something like this: ... (300, "Hugh", "{Tab}", "Robison", "{Tab 5}", "Aug", "{Tab}", "10", "{Tab}", "1838") (...

Go to advanced search