Open Hyperlinks in Firefox, Chrome, Internet Explorer Excel VBA Tricks

Share
Embed
  • Published on Sep 16, 2013
  • **Limited Offer** Learn to Make Excel Do Your Work For You with The Ultimate Excel Programmer Course - Get the Full 9+ Hour Premium Course for 75% off using coupon code: www.udemy.com/ultimate-excel-programmer/?couponCode=2016RU-clip75 Click Now to Order and get Lifetime Access to Course, Workbooks, Updates and Support!
    ------------------------
    Create Your Own Barcode Lookup System Using Excel VBA. Learn to Make Your Own Barcode Labels the Easy way and have fun with Barcode Scanners to Automate your Workflow! In this project-driven Course, you’ll learn to Build your own Custom Inventory System with Step-By-Step video instructions. This goes in depth into some advanced Userform strategies that you can use for your other projects to come. A great weekend study! RU-clip Subscibers only pay one forth! Get your 75% off Coupon here: www.udemy.com/barcodes-excelvba/?couponCode=2016RU-clip75
    ------------------------
    Too busy to Learn Piano? Use my Secrets and Play Your Favorite Songs Today! Did you know; You can learn 4 basic chords in about 5 minutes and instantly be able to play millions of songs. Seriously, check this course out. 75% off for my RU-clip Friends! Click here: www.udemy.com/play-piano-by-ear-today-supercourse/?couponCode=2016RU-clip75
    For Articles, Updates and to Contact me for Consulting or just to drop me a line, please visit www.ExcelVbaIsFun.com
    To download this FREE workbook(source code included): Click the link below.
    excelvbaisfun.com/mdocs-posts/open-hyperlinks-in-firefox-chrome-internet-explorer-excel-vba-tricks/
    ------------------------
    Playlists:
    Excel Vba Basics ru-clip.net/video/AIhKNNXzZLM/video.html
    Tips N Tricks ru-clip.net/p/PLw8O1w0Hv2zsPU-k2vPZ_6brD5Gk1sVy_
    Userforms ru-clip.net/p/PLw8O1w0Hv2zvnLFyiMrihcaOqA0sT0X2U
    Sample Excel Programs ru-clip.net/p/PLw8O1w0Hv2zuP-BE7tV1UjWa0ZexZqY89
    Events Series ru-clip.net/p/PLw8O1w0Hv2zvf-YaBApsIHloI9G6Cq1Wh
    Activex Controls ru-clip.net/p/PLw8O1w0Hv2zupzNIWkZCOYYngTtMH5nSf
    ------------------------
    Grab an Excel Nerd T-Shirt or Hoodie:
    ExcelVbaIsFun.spreadshirt.com/
    ------------------------
    Interact and Follow me on:
    LinkedIn: www.linkedin.com/in/danielcstrong
    Facebook: facebook.com/Excelvbaisfun/
    Twitter: twitter.com/ExcelVbaIsFun
    Google Plus+: www.google.com/+ExcelVbaIsFun

    'Royalty Free Music by audiomicro.com/royalty-free-music'

Comments • 27

  • Prathap R
    Prathap R 5 months ago

    This is really helpful..after opening, how can I copy data from the opened webpage...Pls help

  • Jake Delger
    Jake Delger 6 months ago

    Thank you! I used the shell method and it worked except now I can’t figure out how to do auto fill on the website is there any way you can help me?

  • Design mis
    Design mis 6 months ago

    TIME WEST.

  • Swapnil Infotech
    Swapnil Infotech 10 months ago

    Thank you very much Excel Guy. i was looking for vba script which can open url in Mozilla and not in default browser. but i didnt get anything on internet and some of the script worked only for one url but seeing your video i realized that it was very easy man. Keep going ..

  • Wes Hedrick
    Wes Hedrick 10 months ago

    "If you needed Explorer, God forbid" hahahaha!

  • Umesh Sai
    Umesh Sai 10 months ago

    Hi, this is really a good video. I have a doubt, If I want to open an application that requires user ID and password, (for example Gmail) can you suggest me how can I use

  • Kartick Chakraborty

    Can you make a video on how to run macro on protected worksheet or workbook? It always shows "Debug"

  • xing hansen
    xing hansen Year ago

    Do you know how to close the Chrome after finish the job?

  • Hickson Heritage
    Hickson Heritage Year ago

    Great Tutorial! Only caveat was using Windows 10, I️ had to manually type browser application .exe locations in the file explorer to identify path of Chrome & Firefox as following video navigation didn’t work.

  • Jarred Wennekes
    Jarred Wennekes Year ago

    Hi Dan, do you know of a way where I could pull the URL from a cell using the shell method?

    • Jarred Wennekes
      Jarred Wennekes Year ago

      Never mind. I found a solution. If any one else is interested, see below.
      Dim strURL As String
      Dim strChrome As String
      strChrome = "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"
      strURL = Range("W12")
      Call Shell("""" & strChrome & """ """ & strURL & """")

  • Amit Bodhwani
    Amit Bodhwani 2 years ago

    Hi,
    There is a text box on my webpage which on clicking will pop up a calendar the properties of that text box is

    I tried clicking that button using IE.document.getelementbyid("datepicker") and IE.document.getelementsbyclassname("hasDatepicker") and also IE.document.getelementsbyname("date") but i failed everytime and i am not able to click text box because of which the calendar on my webpage is not appearing.
    I tried using Selenium Java code and it is working fine with it but i want to code with VBA scripting.
    Please help me with this issue as while running i am not getting any errors also.
    Thank You

  • Sugat M
    Sugat M 2 years ago

    nice videos ,need help with extracting data from textboxes of already opened webpage in chrome using vba

  • DerVorLaser
    DerVorLaser 2 years ago +1

    Thanks, man. You finally saved me in my most desperate hour.

  • staaldak
    staaldak 4 years ago +3

    Ok, so you can open chrome and firefox with predefined urls. Not much use if you need dynamic urls. How do you use vba to get the url from an already running running instance of chrome or firefox? For example the url of a page that has been opened after clicking on a link from a search engine?

  • Christian Wilson
    Christian Wilson 5 years ago

    Run-time error '2146697212 (800c0004)

  • Fabian Maume
    Fabian Maume 5 years ago

    And is it possible to use the VBA to copy paste the content of a webpage?

  • ExcelVbaIsFun
    ExcelVbaIsFun  5 years ago

    Fantastic. You'll love it. Dan

  • Flyermarc
    Flyermarc 5 years ago

    You rock! fyi I just clicked on the link to get a dropbox account. Thanks for the videos. Marc J

  • Daniel Weikert
    Daniel Weikert 5 years ago

    Thank you very much. Your videos are great. The shell command is awesome. But one question. If someone else open the workbook on his computer and I don't know the path of the program on his pc, is there a possibility to tell excel to search for the path and implement it in the shell command?

  • krn14242
    krn14242 5 years ago

    Thanks Dan

  • ExcelIsFun
    ExcelIsFun 5 years ago

    Thanks for another great video!

  • Myrslokstok
    Myrslokstok 5 years ago

    Yes it helped, thanks for understanding my question!
    Michael in Sweden, Stockholm!

  • Martin Kreitmair
    Martin Kreitmair 5 years ago

    Off Topic: Whats the date explorer program you use?

  • Youssef
    Youssef 5 years ago

    Thanks a lot Dan!

  • ExcelVbaIsFun
    ExcelVbaIsFun  5 years ago

    You're very welcome, Myrslokstok. Hope this helps. Dan

  • Myrslokstok
    Myrslokstok 5 years ago

    Thanks!