Consulting

Results 1 to 2 of 2

Thread: Need Help with controlling internet using Excel Macro !!!

  1. #1
    VBAX Regular
    Joined
    Dec 2010
    Posts
    12
    Location

    Need Help with controlling internet using Excel Macro !!!

    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 them
    QUESTIONS
    • 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!!!

  2. #2
    VBAX Expert Tinbendr's Avatar
    Joined
    Jun 2005
    Location
    North Central Mississippi (The Pines)
    Posts
    993
    Location
    Welcome to VBA Express!

    Search is your friend. (Excel Internet Explorer)

    Link 1

    Link 2

    Link 3

Posting Permissions

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