+ Reply to Thread
Results 1 to 4 of 4

Copy Tables from IE window to Excel - Need help making code see already opened window

  1. #1
    Registered User
    Join Date
    02-23-2012
    Location
    FL
    MS-Off Ver
    Excel 2007
    Posts
    55

    Copy Tables from IE window to Excel - Need help making code see already opened window

    So I found this code on the web and I'm trying to understand it and make it work for me. The problem is, I don't want to open a new IE window, I want the code to point to an IE window thats already open. Would someone mind helping me out with this? Every instance of this I've come across they make you open a weblink directly to the page and I really need it to work with a page thats already open.

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    02-23-2012
    Location
    FL
    MS-Off Ver
    Excel 2007
    Posts
    55

    Re: Copy Tables from IE window to Excel - Need help making code see already opened window

    Okay, update #1. I updated the code to look at a window thats already opened. Using this code:
    Please Login or Register  to view this content.
    My problem is now that it's only taking the text from the very top table and stopping. Is there anyway to pull data from all tables shown on the website and bring it into excel?
    Last edited by mattyp; 10-26-2015 at 01:40 PM.

  3. #3
    Registered User
    Join Date
    02-23-2012
    Location
    FL
    MS-Off Ver
    Excel 2007
    Posts
    55

    Re: Copy Tables from IE window to Excel - Need help making code see already opened window

    Update #3 - So I figured out that the code is only copying the first table. What I actually need is the 3rd table. Can someone please let me know how this would be done?

  4. #4
    Registered User
    Join Date
    02-23-2012
    Location
    FL
    MS-Off Ver
    Excel 2007
    Posts
    55

    Re: Copy Tables from IE window to Excel - Need help making code see already opened window

    I figured it out, just in case anyone is every trying to do this:

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. use VBA to switch to an new IE window that has opened behind main IE window.
    By Andy Mcc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2015, 09:16 AM
  2. Excel crashes when Macro is run, but only when the VBA window has been opened
    By EchoPassenger in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-04-2015, 08:55 AM
  3. rogue window opens with any opened excel file
    By T 520 in forum Excel General
    Replies: 1
    Last Post: 05-23-2015, 09:58 AM
  4. [SOLVED] How to show both Project Explorer and Code window in the VB window?
    By m3atball in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2014, 07:22 PM
  5. [SOLVED] Different Screenupdating status in VBA Code Window than Immediate Window
    By ArnolddG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2014, 11:14 AM
  6. Replies: 1
    Last Post: 06-13-2013, 11:35 AM
  7. need help in making the current window as active window.
    By ashvija in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-27-2012, 06:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1