I am building one of my first bots and am currently having an issue with Type Into and selectors that I cannot figure out.
The main task of this bot is to automate some Excel formatting, applying the same formatting to (the only) two sheets in an Excel workbook. I am using “Type Into” block with “[k(alt)]” followed by the appropriate keystrokes to set the formatting I want. However, I am having an issue where sometimes the “alt” keystroke doesn’t get sent and the following keystrokes end up getting typed into a cell. I have tried many different selectors as well as checking and unchecking different options on the type into and separating the alt keystroke from the following letters (using two type into’s, one for the alt and one for the keystrokes) and am not able to get both the first sheet and the second sheet to both be formatted. Either the first sheet never gets the first alt keystroke and the whole workflow doesn’t run or the first sheet gets formatted but the second sheet never gets the second alt keystroke sent.
I have a formatting chain (written in a “Do” block) and am looping through using “for each sheet in wb.GetSheets” and when I run the workflow, it correctly formats the first sheet but then when it switches to the next sheet it does not send the “alt” stroke even though it is in the “Do” block and the letters instead get typed into a cell. If anyone had any guidance on this (correct selectors, type into options, approach other than “for each…”) I would greatly appreciate it.