Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    1,004
    Thanks
    59
    Thanked 109 Times in 94 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,484
    Thanks
    376
    Thanked 1,471 Times in 1,339 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,004
    Thanks
    59
    Thanked 109 Times in 94 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,684
    Thanks
    121
    Thanked 666 Times in 607 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,004
    Thanks
    59
    Thanked 109 Times in 94 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
  •