AutoHotkey Community

Hi,

I currently have code that will run a macro on a specific workbook, so long as this workbook has been opened first. The problem is, that I sometimes will have another workbook that was opened first, and thus I get an error stating the macro cannot be found.

I need a method of access a specific workbook by title name to run macros. My current code:



I've been searching in vain for over an hour now, and I'll continue searching in the meantime.

Thanks in advance for any help.

I would recommend using Sean's GetExcel()function:

Or, if you know the full workbook path & name:

_________________

Recommended: AutoHotkey_L
Basic Webpage Controls

Thanks Jethrow!

The second method (GetObject) seemed to have worked just fine.

As for the GetExcel(hwnd), I'm not sure how I am supposed to use this function. I looked it up based on the link you provided, but I couldn't find an example where a unique identifier would have been entered.

I have tried various combinations for hwnd, but to no avail.

Your patience are appreciated

Thanks.

Actually, Sean uses it in the function:
Or, you should be able to use WinExist()as well.

_________________

Recommended: AutoHotkey_L
Basic Webpage Controls

I'll try that out.

Thanks a bunch!

Or, you could do this:

_________________

Recommended: AutoHotkey_L
Basic Webpage Controls

Got it to work with the GetExcel function along with WinGet.

Thanks man.