locked
Is there a way to send keystrokes to a popup in vba? RRS feed

  • Question

  • I have a requirement to send a password to excel to unlock the current sheet by entering a password to a popup
    Friday, November 20, 2020 7:43 PM

All replies

  • forum migrated to mentioned below link please use this

    https://docs.microsoft.com/en-us/answers/index.html

     hope answer the question if issue resolve please accept answer

    Friday, November 20, 2020 7:46 PM
  • forum migrated to mentioned below link please use this

    https://docs.microsoft.com/en-us/answers/index.html

     hope answer the question if issue resolve please accept answer


    It seems untrue that Visual Basic for Applications (VBA) was migrated.


    Saturday, November 21, 2020 9:16 AM
  • VBA include the SendKeys statement: https://docs.microsoft.com/en-us/office/vba/Language/Reference/user-interface-help/sendkeys-statement. Check if it works when window is active.

    But maybe it is more appropriate to open the fail manually, then enter and remove the password.

    Saturday, November 21, 2020 9:29 AM