How to get given URL website table data to excel using excel VBA code

Sub ScrapeLondonStockExchangeData()
    Dim URL As String
    Dim HTMLContent As String
    Dim HTMLDoc As Object
    Dim Table As Object
    Dim Row As Object
    Dim Cell As Object
    Dim i As Integer, j As Integer
    Dim CurrentRow As Integer
    
    ' Define the URL of the webpage to scrape
    URL = "https://www.londonstockexchange.com/indices/ftse-aim-all-share/constituents/table"
    
    ' Create a new instance of Internet Explorer
    Set HTMLDoc = CreateObject("HTMLFile")
    
    ' Download the webpage's HTML content
    With CreateObject("MSXML2.ServerXMLHTTP.6.0")
        .Open "GET", URL, False
        .send ""
        HTMLContent = .responseText
    End With
    
    ' Load the HTML content into the HTML document
    HTMLDoc.body.innerHTML = HTMLContent
    
    ' Find the table by its class name
    Set Table = HTMLDoc.getElementsByClassName("table_dati")(0) ' Adjust 
                                                     ' the index if needed
    
    ' Create a new worksheet to store the data
    Worksheets.Add
    ActiveSheet.Name = "StockData"
    
    ' Initialize the row counter
    CurrentRow = 1
    
    ' Loop through the rows in the table
    For Each Row In Table.Rows
        ' Initialize the column counter
        j = 1
        ' Loop through the cells in each row
        For Each Cell In Row.Cells
            ' Copy the data to the Excel worksheet
            Cells(CurrentRow, j).Value = Cell.innerText
            j = j + 1
        Next Cell
        ' Move to the next row in the Excel worksheet
        CurrentRow = CurrentRow + 1
    Next Row
End Sub