PDA

View Full Version : Need Help with controlling internet using Excel Macro !!!



23izkool
12-05-2010, 02:30 AM
Hi people, found this great site and have decided to seek help after umpteen futile attempts at getting my macro to work!!!

I am trying to pick up how to:
(1) Open up an internet url
(2) Click a button to enter another page
(3) Fill in an empty field in the internet page


REMARKS

For (1), I have managed to get some basic stuff going like activating the 2 internet objects and opening public websites. What I need now is to access secure websites which appear to work but are rather unstable (gives me 'error in loading' in return)
For (3) The empty field is not directly visible to fill in. For example, in this website here, the top bar's first tab 'Site Links' show a further list when we click on it. In my case, it is similar just that the further list bears the empty fields. I do not know how to access these fields so that figures are updated in them when I have to indirectly access themQUESTIONS

I have been working on these intermitently for months to no avail! Really hope to seek some help over here - Can anyone possibly recommend some guides / books I can refer to so as to pick up how to use objects in vba access of internet
Hope someone can help advise on my problems above. I do not seem to be able to find much help on these via the internet...HELP!!!!
THANKS!!!

Tinbendr
12-05-2010, 07:24 AM
Welcome to VBA Express!

Search is your friend. (Excel Internet Explorer)

Link 1 (http://www.vbaexpress.com/kb/getarticle.php?kb_id=386)

Link 2 (http://www.vbaexpress.com/forum/archive/index.php/t-11287.html)

Link 3 (http://www.vbaexpress.com/kb/getarticle.php?kb_id=293)