Interacting with IE using sendkeys from Excel
- by Thomas Egan
I'm trying to write an application which uses values from excel and then switches to a web application using sendkeys. The problem I am having is that I cannot used sendkeys ("{ENTER}") or sendkeys ("^o") as I don't have the access for that.
I'm trying to automate a very trivial admin task. I've thought about using the mouse to interact with the links as well as pausing and waiting for the user to just hit return but so far have been unable to come up with a solution.
Do you think there is anyway around this? I have some VBA knowledge (enough to get me this far) but not a great deal.