AutoHotkey Community

Hello friends,
I am a freshman in AHK. There is something make me confuse, I am always activate a Excel window by the script as blow:

but in our daily work. we always need to open mutiple Excel windows. like "a.xls", "b.xls", "c.xls", "d.xls"......recently I found if "a.xls" is the first Excel window to be opened, then "a.xls" can not be activated by the scipt as above.(example: first, I open "a.xls", and then I open "b.xls" or creat a new Excel file "book1.xls". after that I run the scrift as above. window "Microsoft Excel - a.xls" can not be activated)
Could anyone help? Thanks a lot!!!

You don't provide the version of excel you are using, could you provide that?

All of the commands you list are based on how you match the title.
The spelling, punctuation and even LeTtEr CaSe matter.
http://www.autohotkey.com/docs/commands/WinWait.htm
http://www.autohotkey.com/docs/commands ... chMode.htm

If the files are in the same MDI interface you might need to try this thread.
http://www.autohotkey.com/forum/viewtopic.php?t=55080

My excel has a little lagged behind, just 2003
I think the problem may due to the same MDI interface. I tried to delete "Microsoft Excel - ", just run as "WinActivate, a.xls". it works. but not stably. error are always happened. so...I am trying to find another way...[/img]

Read the last thread listed in my prior post.

I also have EXCEL 2002 installed on another machine

This script works for me with the file names a.xls b.xls and c.xls
There is one caveat, all 3 files must be opened in the same instance of Excel.

To illustrate: If I open excel and drag/drop the 3 files onto the excel window, it works fine.
If I select thm in one Windows Explorer window and hit enter, this script will work.
If I open each of the files from the Excel File->Open menu, it will work.

What will not work: is to open one or two of the files, then open excel again (using a
desktop shortcut, or Start->Programs...) and then try to open the remaining excel file(s)

I think 2002 and 2003 should be the same...
Thank you for your reminder, "SetTitleMatchMode" is usefully.
I could activate the window via the script. But I also wanna add some text into the Excel. Could you try the blow script?



You must try to run this script more than 10 times(Run on other actived Excel windows), and then you will find the problem(s). Sometimes the window looks like activated, actually not. but it still keeps running. So made some error. ("SetDefaultMouseSpeed, 0" and "click, 63,18" look like a little stupid, But I have to make sure the script Sendinput ZZZZZZ after the window have been activated.)
Are there any solutions for that? Thanks a lot

I've noticed a different response between XL2002 and XL2007 to a few things I have tried.
I haven't been able to make much sense of the results.

I do need to ask, are you planning to have the A.xls b.xls etc maximized withing the parent Excel frame or are you planning them to be non-maximized?

The reason I ask is that the title of the Excel window changes based on whether the the active spreadsheet is maximized or not.

If the spreadsheet is maximized (_not_ necessasarily the excel window) then the title of the window is a combination of "Microsoft Excel" and the title of the spreadsheet. (The word arrangement is different between versions)

Anyway, if the spreadsheet is maximized within the Excel frame, then all the old methods seem to work.

If the spreadsheet is not maximized, then the a.xls is in the title of its _own_ window.
With the result that "WinWaitActive" doesn't /see/ it

I suggest looking at the remarks of
http://www.autohotkey.com/docs/commands/WinMaximize.htm

Try the Postmessage command shown there by trying "a.xls" in each of the WinTitle, WinText parameters
(remember to make the unsed parameter empty)

that's all I have for now. I think I need to go lie down, this is weird.

yes...much weirdly
Anyway, thank you. I will try "WinMaxmize". I think it is a good way for solving the problem. my boss pushed me everyday....

I may be off base here, but it sounds like there is an issue activating an Excel window where there are multiple WorkBooks open for one Excel Object/Process ( check the Window HWND/ID ). If you have Excel open, go to the Start menu & click Microsoft Excel, it will create a new Excel object/process. ( this can be confusing since each workbook has its own tab on the taskbar; if you just double click on an xls file, it will open it in a pre-existing excel object/process if one exists ). If you have two or more WorkBooks open in the same Excel object/process & need to activate an unactive one, you can use the following code ( written for AHKL & COM_L ):
NOTE - for multiple workbooks in the same excel object/process, the only WinTitle that exists is Microsoft Excel - <Active WorkBook>; ie - only the active workbook exists as a window, not the other workbooks (even though they have a tab in the taskbar ) .

_________________

Recommended: AutoHotkey_L
Basic Webpage Controls

Hello jethrow,
Thanks for helping me out, You are very talented. I think COM is a better way for that. but I don't know it well. when I run blow script. A warning pop up ------ The following variable name contains an illegal character: ".Activate".



Is there some additional module need to be installed into my computer?

AHKL is a separate build of AHK that supports objects. You will notice there is also two different versions of the COM Standard Library. To use the code I provided, you need to use AHKL & COM_L. Otherwise, here is the same code written for the standard release of AHK & COM:

_________________

Recommended: AutoHotkey_L
Basic Webpage Controls

It worked and it became more stable. It fixed the problem perfectly. Thank you!
But i still have three more questions:
1. Where could I get the details of each function?
2. How could I get some information for learning COM? I think I really need these.
3. I need to create an ".EXE" file and use in three computers. Do I need to put the whole script of COM.ahk into my program? (If I want to run the program on share drive and I could not create any file on their computers.)