Skip to main content
Cadet | Tier 2
May 5, 2022
Question

I need to put a series of keystrokes in Excel: 1. Y3, 2. Y4, 3. T., 4. Enter However, after I put y3, it does somehow not hold the “ALT”, so that it puts “Y4 etc.” in the activated cell instead of using it as a keystroke.

  • May 5, 2022
  • 13 replies
  • 322 views

I tried several options for the command, none of those are working (I also tried to vary the delay time.

  • [ALT DOWN][ALT UP]y3y4t
  • [ALT DOWN][ALT UP]y3y4t[ALT DOWN][ALT UP]
  • [ALT DOWN]y3y4t[ALT UP]
  • [ALT DOWN]y3[ALT UP] & new line [ALT DOWN]y4[ALT UP]

    13 replies

    Navigator | Tier 3
    May 5, 2022

    Hi You can put keystrokes into variables and use the variable for the key simulation.

    • Ex: $Variable$ = [ALT DOWN][ALT UP]y3y4t
    • use the $Variable$ in the keystrokes action

     

    Clara0902Author
    Cadet | Tier 2
    May 5, 2022

    Thanks a lot for the quick answer!! I tried it, but unfortunately it is not working. it is after typing Y§ losing the ALT and thus writes y4... in the activated cellError result:

    Variable definitionCommand including variable

    Navigator | Tier 3
    May 6, 2022

    If the keystrokes sequence includes in ALT, try using

    • [ALT DOWN]y3y4t[ALT UP]

    this should work

     

    Clara0902Author
    Cadet | Tier 2
    May 6, 2022

    I tried that option (see above), but it does not work unfortunately

    Navigator | Tier 3
    May 6, 2022

    I see.....

    then you can try customizing the Shortcut keys in excel

    • fix a shortcut key to access the IBM planning Analytics that can be used globally (Ex: ALT DOWN]MIALT UP] or ALT DOWN[B[ALT UP] this will be one solution for this kind of scenarios.
    • Another Solution is Create a Macro and Run ( Most Reliable when it comes to Excel)

     

    ( In general Keystroke Actions and Action performed in Excel is a bit delay process when using AAE )

    https://support.microsoft.com/en-us/office/customize-keyboard-shortcuts-9a92343e-a781-4d5a-92f1-0f32e3ba5b4d/p>

    Clara0902Author
    Cadet | Tier 2
    May 6, 2022

    Thanks again for your support.

    Option 1: In my Excel I can somehow not customize the shortcuts, I miss totally the field "customize" (see below)

    Option 2: I created a marco which works perfectly fine when executed in excel, however executed in AA, the original error comes up again (that the series of keystrokes is not executed, only the first one and the rest is written in the activated cell)

     

    ... I really have no clue how to solve this issue. 2022-05-06_13h52_42 

     

    Navigator | Tier 3
    May 9, 2022

    Hiii.....

    ohh that seems fishy

    are you using AA Commands to run the Script (VBScript Command ) ?

    If so dont use the AA Command, use keystrokes to run the macro.

    ALT + F8-> to open macro window, using the ALT to select the macros to run.

    Clara0902Author
    Cadet | Tier 2
    May 15, 2022

    2022-05-15_21h14_38Hi Yokogawa, thanks again and sorry for my late reply. I just tried your solution and the start of the macro with ALT + F8 works, however, AA still does not get it, still writing the "y6t" of "y4y6t" in the excel cell...no idea why it does not work with all the tries.

     

    The crazy thing is, when i start the macro by hand instead of by AA, it works perfectly

    Cadet | Tier 2
    May 20, 2022

    Is there a solution to this issue? We have the exact same problem when we try to simulate [Alt Down] CX [Alt up]. We tried all different permutations, including the C and X pressed after the [Alt Up], and we still have the last character (X) printed out on the cell. This seems to be a serious limitation of the platform.

    Cadet | Tier 2
    May 20, 2022

    @Clara Rösen​ Hi, I was wondering if you were able to find a solution to this? I have spent many hours on the exact same thing, trying different ways of carrying out the Alt related action but to no success.

     

    @Ninad Kanade​ I was wondering if you had any idea of the above issue. I have the same exact problem and have opened a ticket too for this.