was trying to fetch Swiss bank a/cs details
I wanted very simple thing..Was just trying to fetch future data from NSE website.. check below what I wanted to do... I want date(in qurl) to be taken from cells(here I am just changing expry date)... date is in cell(3,2)
Thanks
DIM m , y , d as integer
s = Cells(3, 2)----------------date in 24-02-2011
m = UCase(Format(s, "MM"))
y = Format(s, "YYYY")
d = Format(s, "dd")
I want expiryDate to go as 24-02-2011 in below qurl
qurl = "http://www.nseindia.com/marketinfo/sym_map/symbolMapping.jsp?instrumentType=FUTSTK&symbol=" & stock_code & "&expiryDate= " & y & "/" & m & "/cm" & d & m & y & " &optionType=select&strikePrice=&dateRange=day &fromDate=14-02-2011&toDate=18-02-2011&segmentLink=9&symbolCount=1"