VBA webform filling in child window

[Helloby]

Hello,

Appreciate if anybody can help me solve this, despite the fact that i hv tried various other options already mentioned on this forum.

Now the automation task :

1 ) Open a webpage & on that webpage click on a particular button which opens up a new window
2 ) fill up the fields in that new window from excel sheet

Now the problem :
I am able to complete the task No.1 but not able to fill up the fields in newly opened window because it required to be
opened by invoking .navigate "URL" command and setting .visible = true since I must open the said URL only thru the task no.1
So i just want a solution for the second part wherein I am able to input excel data into field of child window which must not be opened by invoking .navigate command from vba script.

I Need help from the masters.

Thanks

 

[John_w]

You can get a reference to the IE child window by using WithEvents InternetExplorer and trapping the NewWindow2 event, or by looking for it in Shell.Windows. Once you have a reference to the IE child window you can use IE.document methods (getElementsByTagName, getElementById, etc.) to populate the form fields on the page.