AutoHotkey Community

WeThotUWasAToad

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 ...

WeThotUWasAToad

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...

WeThotUWasAToad

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...

WeThotUWasAToad

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...

WeThotUWasAToad

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...

WeThotUWasAToad

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 ...

WeThotUWasAToad

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...

WeThotUWasAToad

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;...

WeThotUWasAToad

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...

WeThotUWasAToad

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...

WeThotUWasAToad

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...

WeThotUWasAToad

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

WeThotUWasAToad

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...

WeThotUWasAToad

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...

WeThotUWasAToad

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.

WeThotUWasAToad

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...

WeThotUWasAToad

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

WeThotUWasAToad

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....

WeThotUWasAToad

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...

WeThotUWasAToad

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") (...

Search found 273 matches

Re: Script to quickly navigate between multiple Excel windows

Re: Script to quickly navigate between multiple Excel windows

Re: Script to quickly navigate between multiple Excel windows

Re: Script to quickly navigate between multiple Excel windows

Re: Script to quickly navigate between multiple Excel windows

Re: Script to quickly navigate between multiple Excel windows

Re: Script to quickly navigate between multiple Excel windows

Re: Script to quickly navigate between multiple Excel windows

Script to quickly navigate between multiple Excel windows

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

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

Re: Script skips some steps

Script skips some steps

Round off variables to whole integers

Re: Script freaks out when it runs

Script freaks out when it runs

Re: Insert Sleep commands in single line of script

Re: Insert Sleep commands in single line of script

Re: Insert Sleep commands in single line of script

Re: Insert Sleep commands in single line of script