Announcements
In the 40-minute process, I used sendkey input ten times (as shown in the picture) to save the Excel file regularly, but after waiting seven times each time, I saw that PD entered S in the cell for no reason. Is this a bug?
Hi.
Why not just use the "Save Excel" Action?
If you must use a Hotkey, try to enable them to be send as Hardware Keys instead.
Hi @alee001
Is the action is under a loop condition? If so you could have debug that and check why the action is triggering after seven times
Hope this may help you
If you find this reply helpful, please consider giving it a LIKE
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION
Thanks,
Srini
My Excel file is not opened via PA (pre-opened), so I can't use save settings.
[Send text as hardware keys] I don't know the difference between this option, let me try it.
My PA process is not looping, it is a program for 10 Excel files need save after each updated (a total of ten times).
I wonder if the PA process is too fast to cause sendkey error? (wait seconds added)
Yes, as you updated so it might be PA is trying to send key before the Excel instance is ready
If you know the File Names, you can Attach to the running instance and then save it.
Even if you just know the folder location you could loop through the files in the folder, attach to each instance, do what you want to do and then save it in the end.
Saves you using "Send Keys" and other scripting that is more prone to failing 🙂
I known your mean, but because Excel opening with PA restricts the use of userform in VBA, I choose to pre-opened Excel the process of recording UI elements. Sendkey Ctrl+S is the shortcut on progress.
Does the default delay of 10ms matter? How should it be adjusted?
Maybe the static wait will not work. because it depends how fast the excel is getting ready to accept the next send keys action
So I suggest you to check a UI Element in the Window and try using wait for window / wait for window content to appear, So that I dynamically wait until the windows element is appeared
Fair enough. Attaching shouldnt care about that VBA you have running, as it will just attach to the process itself. Up to you 😉
But changing to Send Text as Hardware Keys should be the fix for you. If thats not working, let me know
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 248 Super User 2026 Season 1
11manish 204
Haque 179
