import data from website to excel by changing the dates in web page

[chssundeep]

Dear Excel experts,

Need your guidance on fetching the data from website to excel. Below are the details I will be required

website: https://www.cbb.gov.bh/facilities-interest-rates/
Import to excel: Exchange Rates - Historical Search (Table)
Date: 1-Jan-2023 to 20-Nov-2023

Require to import the date in below format

can you please help

	01-01-2023​	02-01-2023​	03-01-2023​
Currency	BHD
AED	0.102391
ANG	0.210101
AUD	0.244810
CAD	0.274042
CHF	0.424591
EUR	0.409985
GBP	0.468278
HKD	0.048235
INR	0.004516
JOD	0.530439
JPY	0.002510
KWD	1.219697
LKR	0.001148
NOK	0.034772
NZD	0.225630
OMR	0.977494
PKR	0.001312
QAR	0.103114
USD	0.376081
SGD	0.279791
SAR	0.100275
BDT	0.003399
CNY	0.052130
EGP	0.012171
IDR	0.000024
LBP	0.000025
MAD	0.037095
NPR	0.002824
PHP	0.006756
THB	0.010704
TND	0.120608
TRY	0.013102
ILS	0.101135

 

[Monty]

Hello Chss
You can use VBA to import data from a website to Excel, changing the dates on the web page. Here's a basic example to get you started:

Sub ImportDataFromWebsite()
    Dim url As String
    Dim startDate As Date
    Dim endDate As Date

    ' Define website URL
    url = "https://www.cbb.gov.bh/facilities-interest-rates/"

    ' Define start and end dates
    startDate = DateValue("01-Jan-2023")
    endDate = DateValue("20-Nov-2023")

    ' Create Internet Explorer object
    Dim ie As Object
    Set ie = CreateObject("InternetExplorer.Application")

    ' Navigate to the website
    ie.Navigate url

    ' Wait for the webpage to load
    Do While ie.Busy Or ie.readyState <> 4
        Application.Wait Now + TimeValue("0:00:01")
    Loop

    ' Your code to interact with the webpage and extract data goes here
    ' This may involve finding and clicking elements, filling forms, etc.

    ' Close Internet Explorer
    ie.Quit
    Set ie = Nothing
End Sub

This is a starting point, and you need to adapt the code based on the structure of the website. You may use tools like the Internet Explorer Developer Tools or inspect elements to find the necessary information.

For interacting with the website and extracting data, you might want to explore methods like `getElementById`, `getElementsByClassName`, or `querySelector` in combination with the `innerText` property.

Remember that web scraping may be subject to terms of service of the website, so ensure compliance with the website's policies.