Results 1 to 10 of 10

Get Currency from Web

Threaded View

  1. #1
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Get Currency from Web

    Hi All

    First time Ever doing web scraping...

    I am wanting to extract USD to ZAR exchange rate

    Any suggestions on how to get the correct element and change values...

    Sub Auto_Open()
    Dim URL As String, ExRt As Double, Obj As Object, Ele As Object
    URL = "https://www.xe.com"
    With CreateObject("InternetExplorer.Application")
        .Visible = True
        .navigate URL
        Do Until .ReadyState = 4: DoEvents: Loop
        Stop
        Set Obj = .document.getElementsByClassName("CurrencyInputWrapper-Djuqw fmFlNB")
        For Each Ele In Obj
            Debug.Print Ele.innerText
        Next Ele
    End With
    End Sub
    Untitled.png
    Last edited by Sintek; 07-12-2020 at 09:29 AM.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Change currency in quotation (automatically if an certain currency is selected.
    By The excel apprentice in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-29-2021, 03:31 AM
  2. Replies: 2
    Last Post: 09-26-2018, 03:19 PM
  3. [SOLVED] Formula that contains currency not returning the results as currency
    By Triscia in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 07-17-2014, 03:02 PM
  4. Replies: 7
    Last Post: 06-17-2014, 02:15 PM
  5. Currency conversion insert currency symbol
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-01-2013, 05:50 AM
  6. Replies: 5
    Last Post: 06-30-2011, 07:48 AM
  7. Currency Formatting-range of number as currency
    By kmurray24 in forum Excel General
    Replies: 1
    Last Post: 01-09-2008, 09:09 AM

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