DATA EXTRACT FROM WEBSITE(s)

  • Re: DATA EXTRACT FROM WEBSITE(s)


    Use following code hope that you will find some clues


  • Re: DATA EXTRACT FROM WEBSITE(s)


    all i can suggest is to change this line

    Code
    1. ThisWorkbook.Sheets("Sheet1").Cells(ActRw + lngRow + 1, lngCol + 1) = objTable(lngTable).Rows(lngRow).Cells(lngCol).innerText

    to

    Code
    1. ThisWorkbook.Sheets("Sheet1").Cells(ActRw + lngRow + 1, lngCol + 1) = t & " "" &objTable(lngTable).Rows(lngRow).Cells(lngCol).innerText


    to tell you what table your are looking at . it will put the table number before and entry
    then use the if statement lke in the previous example


  • Re: DATA EXTRACT FROM WEBSITE(s)


    Quote from pike;713564

    no need for the sir


    any way its the third table


    I get my required data from above code for http://www.barchart.com/commod…232_Futures/CT?search=CT*


    but barchart changed their website face and now above code not working, I need support on the same.


    Regards


    Shahzaib