Importing Specific Column to Excel from Web page using VBA code (URL changes) -

Importing Specific Column to Excel from Web page using VBA code (URL changes) -

i'm new guy in vba , know how can import specific column web site , re-create year's info of specific column in excel using vba code. difference page has calendar , url changes, means want re-create 1st of june 2012 until nowadays specific column fron whole table using vba code.

sub websitee() websitee x = 1 x = 1 25 activesheet.querytables.add(connection:= _ "url;http://www.epexspot.com/en/market-data/intraday", destination:=range( _ "$a$1")) .name = "intraday" .fieldnames = true .rownumbers = false .filladjacentformulas = false .preserveformatting = true .refreshonfileopen = false .backgroundquery = true .refreshstyle = xlinsertdeletecells .savepassword = false .savedata = true .adjustcolumnwidth = true .refreshperiod = 0 .webselectiontype = xlspecifiedtables webtables = "315" .webformatting = xlwebformattingnone .webpreformattedtexttocolumns = true .webconsecutivedelimitersasone = true .websingleblocktextimport = false .webdisabledaterecognition = false .webdisableredirections = false .refresh backgroundquery:=false end next x end sub

url vba table import website