Skip to main content
Solved

AA360 Community Edition - Simulate keystrokes not opening Replace window in Excel

  • Mar 14, 2025 3:35 PM UTC
  • 3 replies
  • 142 views

I want to clean data in a csv file by opening it in excel and using replace to remove known extraneous characters. I have tried:

and

However, both just resize the excel window? 

Best answer by Marc Mueller

Hi ​@esheridan,

Try with lowercase h with your version 1. ☺️

Maybe you need also increase the delay between keystrokes.

 

Cheers

Marc

View original

    3 replies

    Marc Mueller
    Most Valuable Pathfinder
    Forum|alt.badge.img+8
    • Marc MuellerMost Valuable Pathfinder
    • Most Valuable Pathfinder
    • Answer
    • Mar 14, 2025 4:10 PM UTC

    Hi ​@esheridan,

    Try with lowercase h with your version 1. ☺️

    Maybe you need also increase the delay between keystrokes.

     

    Cheers

    Marc

    🤝Let's connect on LinkedIn: https://www.linkedin.com/in/developer-marc-mueller >>>>>>>> 📺Check out my YouTube channel - https://youtube.com/@AutomationDevelopmentEasy
      • esheridan
      • Author
      • Cadet | Tier 2
      • Mar 14, 2025 4:14 PM UTC

      thanks!! ​@Marc Mueller 

        Marc Mueller
        Most Valuable Pathfinder
        Forum|alt.badge.img+8
        • Marc MuellerMost Valuable Pathfinder
        • Most Valuable Pathfinder
        • Mar 14, 2025 4:14 PM UTC

        Glad it helped!

         

        Cheers

        Marc

        🤝Let's connect on LinkedIn: https://www.linkedin.com/in/developer-marc-mueller >>>>>>>> 📺Check out my YouTube channel - https://youtube.com/@AutomationDevelopmentEasy
        Terms & ConditionsAccessibility statement