Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    1,051
    Thanks
    69
    Thanked 118 Times in 103 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,731
    Thanks
    395
    Thanked 1,533 Times in 1,390 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
    1,051
    Thanks
    69
    Thanked 118 Times in 103 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,754
    Thanks
    129
    Thanked 693 Times in 629 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
    1,051
    Thanks
    69
    Thanked 118 Times in 103 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
  •