Internet Explorer Help

[akn112]

Hi all,

Im evaluating my options right now to start a macro that manipulates IE. for example. if my tables are online and i have to go through a series of links to download and link the tables i need, should i be creating a macro for this directly in vba access, or is there an easier way where i can execute an external macro? The commands i need are:

-Enter username/password
-clicking links
-closing windows
-waiting for page to load (can take several minutes)
-exporting

:help Thanks!

[vosmerkin]

In Excel I'm doing it this way:

In references you should check MS internet controls and MS HTML object lbr

This are some code examples I'm using:
ie.document.forms("form1").all("username").Value="john"
ie.document.forms("form1").submit

ie.Navigate "http:\\www.google.com\"

ie.Quit

Do: Loop While ie.Busy = True

a$=ie.Document.Body.OuterHtml


and then work with a$ variable and parse HTML code to extract the info you need