Hi rahul,

a small alteration we cannot give url every time. we have to fetch data such a way that
it has to got active window of internet explorer and then it has to fetch values from there.
clearly means we will be in excel when we run the macro(VBA) it has to navigate to already opened website and copy values from there. i have code for window navigate please check it out
On Error Resume Next
AppActivate "Windows Internet Explorer"
will be waiting for your early reply.
Thanks in advance
Regards,
Maruthi