Excel and IE interacting....possible?
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Excel and IE interacting....possible?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Milwaukee, WI
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Every evening I have to run a very tedious routine. Using some custom developed software, the routine automatically generates 2 new browser windows displaying files for each of 4 portfolios (= 8 windows). For each portfolio one window is the name of the portfolio and the other is the name followed by SUMMARY.

    Generally, I manually copy the URL of the file and open it in Excel. From there, I have to copy certain data to another workbook, but that part i think I can handle. Is it possible to script something that:
    (a) recognizes when the IE windows have appeared, and
    (b) opens the URL in excel

    Thanks in advance.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi
    Perhaps you can bypass IE all together and do all of your work in Excel. Has browser capability.
    Tom

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com