Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts

    Web toolbar - unwanted appearance !

    Excel 2003

    I am writing my first ever code to pull data from a website.

    So far it is going quite well but an unwanted side-effect is that when it is finished the Web toolbar is open. How can I prevent this ?

    NB the line which unexpectedly triggers this is

    ActiveWorkbook.FollowHyperlink "MyURL"

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Martin,

    With the toolbar visible.
    Turn on Macro recording.
    Close the toolbar manually.
    Turn off Macro recording.
    Press Alt+F11 and see what code was written and add it to your code just before it exits.
    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    3 minutes - is this a record for a response ?! Its appreciated even if it isn't a record

    Thanks for the tip - I was going to do just that but, being of a tidy mind, wondered if the toolbar could be prevented from opening in the first place ?

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,631
    Thanks
    115
    Thanked 645 Times in 589 Posts
    Martin,

    Welcome to the "Dark Side"!

  5. The Following User Says Thank You to Maudibe For This Useful Post:

    mrjimphelps (2013-12-16)

  6. #5
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Well it is pretty dark here - at 23:13

    The new module is complete, tested and running - turned out to be easier than I had expected. Now to get some error -trapping in place for when the Internet is inaccessible . . . I don't want the module to hang forever waiting.

Posting Permissions

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