Hi All
I am in the middle of writing a macro that interacts with Internet Explorer. I have managed to open IE with a reference number copied from excel. The macro then works in IE with the request and when finished, submits the form. I now want it to return to Excel (without closing IE).
This is where I'm having trouble, I have tried sendkeys Alt+Tab but would prefer a more foolproof method.
I have only 1 internet explorer page open, and 1 excel worksheet, is there a way I can activate excel to complete relavent fields, and then activate IE once more to continue on the next request?
NB - I have also tried Application.Activate but with no luck so far.
Any help greatly appreciated
Bookmarks