Where am i goin wrong

hi fnds,

was trying to get data on Rcom from Nse to Excel. Actualy was trying to assign a macro to refresh after ever 5-10-15 secs. Have done quite a bit. I just think im missing somethin.

Iv been trying hard but cudnt work it out.

Can anybody pls check it out and solve my problem.


thanks in advance