Copying data from a child Internet Explorer window after excel opened the parent win.

**CJPHX** · 07-09-2010, 09:57 AM

Mornign all,
I have already gotten some help with this code and I am close to having it to do exactly what I want.

The macro I have opens Internet Explorer to a webpage clicks a button which opens a new page with all the data I need and then selects and copies all the data.

The problem I have is when it clicks the submit button that data is opened in a new Internet Explorer window so the copy and paste feature copies the old page which is not the data I need. I need it to copy from the new page that opens.

Please Login or Register  to view this content.

**CJPHX** · 07-09-2010, 01:20 PM

I am able to get it to copy form the parent window, however I am still unable to get it to switch to the child window and copy.

**Chippy** · 07-09-2010, 01:52 PM

Can't really help you because it's an intranet site, but my suggestion is to use IE WithEvents to trap the creation of the child window (via the NewWindow2 event), or loop through ShellWindows looking for the IE window which matches the .LocationURL or .LocationName of the child window.

**CJPHX** · 07-09-2010, 02:54 PM

thanks Chippy I will look into those as I know nothing about them.

Copying data from a child Internet Explorer window after excel opened the parent win.

LinkBack

Thread Tools

Rate This Thread

Display

Copying data from a child Internet Explorer window after excel opened the parent win.

Re: Selecting and copying all data from a webpage.

Re: Copying data from a child Internet Explorer window after excel opened the parent

Re: Copying data from a child Internet Explorer window after excel opened the parent

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions