Import web data in excel using vba

  • Hello.i want to import web data from a site with soccer results...i've recorded a macro for it...the macro worked great but there is a little problem...here is the macro...


    i need the results from 6-11-2010 to 10-11-2010...the first day (6-11) is imported in cell a3...the second day(7-11) is imported in cell n3...i need to change the macro so the second day pasted in collumn a where the results of day one are finished.....


    EDIT: please use code tags to format the VBA code

  • Re: Import web data in excel using vba


    Hi 1979aris,
    Welcome to this forum.
    Offset is good method i think.
    Try change this line

    Code
    , Destination:=Range("$A$3"))


    to

    Code
    , Destination:=Range("$A$3").Offset(0, (x - 6) * 13))


    Regards, junholee

  • Re: Import web data in excel using vba


    hi and thanks for your response...i ve tried the code but the ploblem is that the results of the second date is again not in collunm a where the results of day one finished but again in column n3...

  • Re: Import web data in excel using vba


    Hi 1979aris,
    Try this instead.


    Regards, junho

  • Re: Import web data in excel using vba


    Quote from junho lee;530694

    Hi 1979aris,
    Try this instead.

    Regards, junho


    what to say!!!!!!!!!!
    thank you very much....
    i have nothing else to say......

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!