Hi @paul_cranberry !
Instead of using "Click UI element", use "send keys" action.
Here is one flow:
So I open my word file, find and replace the text maybe a date or simple text and then switch to the developer tab using send keys.
Configuration of some actions:
This action is to go to developer tab, and then click on the macros section
Then this will send keys like up or down depending on how many macros are there. So the no. of up and down keys will change based on how many macros are there and which specific macro you wish to run. Then simply hit enter key to run the macro.
my macros:
This is just a test so my macros are blank.
If the process of macros are huge, try to put "Wait" action after this before closing the word file.
Code (just copy and paste into your flow):
Word.LaunchWord.LaunchAndOpen Path: $'''C:\\Users\\UserName\\Desktop\\Doc1.docx''' Visible: True ReadOnly: False Instance=> WordInstance
UIAutomation.SetWindowState.SetStateByInstanceOrHandle WindowInstance: WordInstance State: UIAutomation.WindowState.Maximized
# find the text to replace with
Word.FindAndReplaceWord.FindAndReplaceAllWithoutWildcards Instance: WordInstance TextToFind: $'''June 26, 2024''' TextToReplaceWith: $'''26th June 2024''' MatchCase: True MatchEntireWord: False
# Go to developer tab and then go to macro tab
MouseAndKeyboard.SendKeys.FocusAndSendKeysByInstanceOrHandle WindowInstance: WordInstance TextToSend: $'''{Alt}({L}){PM}''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: True
# Select the macro using up and down keys (if many) to select your macro. This needs to be changed if you want a particular macro. Then hit Enter to run the macro
MouseAndKeyboard.SendKeys.FocusAndSendKeysByInstanceOrHandle WindowInstance: WordInstance TextToSend: $'''{Down}{Return}''' DelayBetweenKeystrokes: 10 SendTextAsHardwareKeys: True
# Close and save the word file
Word.CloseWord.CloseAndSave Instance: WordInstance
Before:
Between this a macro will run using the send keys.
After:
I hope this helps.
