I am using "hyperlinks.follow" method to download data from website.
The example for this method shows saving the result in new window as

ActiveWorkbook.FollowHyperlink Address:="http://example.microsoft.com", _
NewWindow:=True

But I require to paste or save the result in some range like (range c1 to H1)
of the active worksheet. New window not required.
How to do this? Please help me.