+ Reply to Thread
Results 1 to 2 of 2

How do I change this syntax so that it works on chrome instead of internet explorer?

  1. #1
    Registered User
    Join Date
    03-30-2022
    Location
    El Paso, Texas
    MS-Off Ver
    MS Office 22
    Posts
    1

    How do I change this syntax so that it works on chrome instead of internet explorer?

    I found this code I wrote a while back that basically navigated to a website, found some data, copied all the rows, and pasted it into excel. The code does this on IE and I want it to work on chrome but I'm not sure how to convert it. As of now, I've figured out how to open chrome, go to the webpage, log in, go to the page with the data, and enter the current day's date. What I'm stuck on is how to copy the data from the site and paste it into excel. This is what I had in the old module:

    Please Login or Register  to view this content.
    How do I get this to work on chrome?
    Also, if there are ways to make the code more efficient, I'm open to it.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: How do I change this syntax so that it works on chrome instead of internet explorer?

    There is no simple way to do that. The code you are using is based on a library built-in to Excel that can directly interact with the IE application. There are no such libraries for other browsers, not Chrome, not even Edge. So you can't just modify this code, you have to start from scratch and develop code that is much more complex. Another current thread has a post suggesting using Selenium to do this.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Log-In/Log-Out from any website in Google Chrome and Internet Explorer Using VBA
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-14-2021, 11:10 AM
  2. Internet Automation - The Open/Save/Cancel bar in Internet explorer
    By Tamil4 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2021, 04:05 PM
  3. need to edit macro for auto login, replaced from internet explorer to google chrome
    By warriorpoet7176 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2017, 03:23 PM
  4. Replies: 3
    Last Post: 12-07-2014, 08:33 PM
  5. change from Internet Explorer to Google Chrome
    By aikz007 in forum Excel General
    Replies: 6
    Last Post: 11-10-2014, 03:38 AM
  6. How do I open with Chrome and not Internet Explorer?
    By walterscj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2013, 11:13 AM
  7. Open internet Explorer and change settings
    By thadeus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-17-2012, 07:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1