Open Urls in Chrome with Excel VBA

แชร์
ฝัง
  • เผยแพร่เมื่อ 11 พ.ย. 2024

ความคิดเห็น • 40

  • @bahn451
    @bahn451 ปีที่แล้ว

    Thank you for this video. With a little tweaking, this really helped.

  • @Steve-og3cr
    @Steve-og3cr 2 ปีที่แล้ว +1

    I need to click a link on the site I'm opening in Chrome....If I "inspect" the webpage I can get the label of the link I need to click, but can't get the syntax to work.
    Any ideas?

  • @sabarisanthosh
    @sabarisanthosh ปีที่แล้ว

    Thank you so much brother ❤️

  • @gustavohernandez7297
    @gustavohernandez7297 2 ปีที่แล้ว

    Thank you for sharing this program. It helps me a lot to do my work faster. Regards

  • @davideluccardi3127
    @davideluccardi3127 2 ปีที่แล้ว

    Very useful and good explanation. You are great. Thank You

  • @abdelazizsaidi
    @abdelazizsaidi 2 ปีที่แล้ว

    Thank you brother , how can I close after tab with VBA ? Please I need your answer

  • @shahidraza8115
    @shahidraza8115 3 ปีที่แล้ว

    Suppose links are of a login webpage, can we also enter credentials and login in each tab simultaneously?

  • @sahnounhamdini7716
    @sahnounhamdini7716 2 ปีที่แล้ว

    Please can you help to import data from oanda with chrome using vba code

  • @evertonferreira2900
    @evertonferreira2900 3 ปีที่แล้ว

    Thank you a lot for the tutorial!!!! This was very usefull for me

  • @ОлегДудкин-ю1э
    @ОлегДудкин-ю1э 2 ปีที่แล้ว

    Орел! Молодец!!!

  • @BS-yy8ur
    @BS-yy8ur 3 ปีที่แล้ว

    👍 ⭐⭐⭐⭐⭐ *Really good video.*

  • @prasannakulkarni2045
    @prasannakulkarni2045 2 ปีที่แล้ว

    It works 😀👍🏻

  • @amanullapatel648
    @amanullapatel648 2 ปีที่แล้ว

    Amazing work. Can you please make a video on how to open URLs in a separate incognito browser? I mean if I have 10 URLs listed in the Excel file then each URL should be open in a different incognito browser.

    • @TechTinkTronics
      @TechTinkTronics  2 ปีที่แล้ว

      Thank you. If there was or is a command to cause Excel to open an incognito browser it would be completely dooable.

  • @BS-yy8ur
    @BS-yy8ur 3 ปีที่แล้ว

    *Hi... I am using excel in my new mobile from some months. This was working good but from two days suddenly I am unable to open any youtube link from excel worksheet. But other url weblinks I can open. I am confuse. ... When I tap on yt link in excel worksheet then instead of launch yt video this message appear ahead me. "There is no web browser installed for this user profile, so the page couldn't be opened." Option button appears with this message is only "Ok." ... I am clueless. Can you help me?*
    *Subscribed.*

    • @TechTinkTronics
      @TechTinkTronics  2 ปีที่แล้ว

      Sorry for the late reply. I would look into what changed and maybe why. Maybe look into different syntax for opening links. A mobile device may have different requirements for opening links from youtube.

    • @BS-yy8ur
      @BS-yy8ur 2 ปีที่แล้ว

      @@TechTinkTronics 👍 *okay.*

  • @Innrlogick
    @Innrlogick 2 ปีที่แล้ว

    @TechTinkTronics
    Thank you very much for the tutorial and Kudos to you and your outstanding work from a Portuguese Canadian subscriber.
    I have tried using your code and it works awesomely fast. All websites open up on multiple tabs under the same Google Chrome window. Great!
    However can you demonstrate if there is a way in VBA code of Excel that one can open each website address that we would like to open up on different Google Chrome windows instead of just opening one Google Chrome Window with multiple tabs for all the links that we wish to visit.
    I ask this because on a daily basis I need to open 7 Google Chrome Windows and I need too maintain them open throughout the course of the day in order to login and to perform my work from home. With only 5 minutes to login prior to your shift it is almost impossible to login on time.

  • @negociosonline40
    @negociosonline40 3 ปีที่แล้ว

    Aqui no meu VBA há um problema com esta linha de código
    VVVVVVVVVVVVVVVVVVVV
    Set ws1 = Sheets ("rawdata")

    • @TechTinkTronics
      @TechTinkTronics  3 ปีที่แล้ว

      I think you want to declare the ws1 as worksheet and make sure everything is within the range.

  • @radikutoyo
    @radikutoyo 3 ปีที่แล้ว

    Could you please tell me how I close a page/tab in chrome, not just kill the chrome, because chrome will inform that it didn't close properly if I open chrome again

    • @TechTinkTronics
      @TechTinkTronics  3 ปีที่แล้ว

      I usually would hit the x on the tabs or the program. Might I ask what type of system are you using? Because chrome may be still running in the background and not closing properly.

    • @radikutoyo
      @radikutoyo 3 ปีที่แล้ว

      Thanks for your reply, i would like to open a website in chrome and then i put option wait for 5 second after that i close that website. Could you show me the way to hit x using syntax in vba

    • @TechTinkTronics
      @TechTinkTronics  3 ปีที่แล้ว

      This site seems to cover the topic of using sendkeys. www.contextures.com/excelvbasendkeys.html

    • @radikutoyo
      @radikutoyo 3 ปีที่แล้ว

      I have tried to use Sendkey, but it didn't work

  • @DeleshGrg
    @DeleshGrg 3 ปีที่แล้ว

    Can we open the link one by one?

    • @TechTinkTronics
      @TechTinkTronics  3 ปีที่แล้ว

      I would just hyperlink urls on the sheet and click links as needed.

    • @DeleshGrg
      @DeleshGrg 3 ปีที่แล้ว

      Can't we do it using loop via vba

    • @TechTinkTronics
      @TechTinkTronics  3 ปีที่แล้ว

      @@DeleshGrg I do use a loop for opening the urls in this macro. Im not sure what you are trying to do. Could you explain more?

    • @DeleshGrg
      @DeleshGrg 3 ปีที่แล้ว

      Can you please share your email or instant messenger id?
      It could be helpful to communicate

    • @TechTinkTronics
      @TechTinkTronics  3 ปีที่แล้ว

      @@DeleshGrg paulrwilsonjr.com/contact-me/

  • @nitu1074
    @nitu1074 3 ปีที่แล้ว

    Thank u