Excel interacting with IE

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

Hi Joseph

I have briefly, but I am struggling to find how to lable internet explorer to direct the activation?

Sorry, I am after both excel and internet explorer.

Thats what I was hoping but I am getting Run-time error '5', Invalid Procedure call or argument?

I'm guessing the answer would be yes, the title is "Colleague IT Servicedesk - Microsoft Internet Explorer provided by Lloyds TSB Group"

Yes, I have tried both individually and as one. The same run-time error occurs

ie8, sorry, meeting, will be back in 20 minutes. thanks for this

Hi

Sorry about that. I am using Internet Explorer 8. I have just tried writing a test macro merely saying

Please Login or Register  to view this content.

I am still getting the error activating IE

I have found the app source file on my machine is not called Internet Explorer as normal, it is packaged as LTSB_Internet_Explorer so have used that as the AppActivate name and it works.
Thanks very much for your help Joseph