Problem Running Excel Macros using HotKeys
User Cole, John (US - Hermitage) (firstname.lastname@example.org) posted:
I am instructing WR to type short-cut keys to goto certain windows. For
example, the following takes me to the Go To window in Excel:
I am having problems using the same method to run macros with short-cut
keys. I have a Macro and have assigned the short-cut sequence as (control
and lowercase "w"). When I use the following command, I get a VB error:
Has anyone used WR to execute Excel Macros?
- This message (including any attachments) contains confidential information
intended for a specific individual and purpose, and is protected by law. -
If you are not the intended recipient, you should delete this message and
are hereby notified that any disclosure, copying, or distribution of this
message, or the taking of any action based on it, is strictly prohibited.
Content-Type: text/html; charset=US-ASCII
< !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
< !-- |**|begin egp html banner|**| -->
Re: Problem Running Excel Macros using HotKeys
It is working fine with the following one:
const xlsMakroA = "<kCtrl_L-a>";
const FensterExcelOutput = "Microsoft Excel - "; & "Output.xls";
win_activate ( FensterExcelOutput );
set_window ( FensterExcelKasse , 0);
obj_type ( FileXLS_Kasse ,xlsMakroA);
or you can use the shortcuts directly:
obj_type ( FileXLS_Kasse ,"<kCtrl_L-a>");
# the Shortcut CTRL+a must be defined / connected to the Excel-Macro!
- the shortcuts could be replaced with the text as well!!!