save and open in excel

[anilg0001]

Range("A1").Select
M = Sheets("Sheet3").Range("A" & Rows.Count).End(xlUp).Row
For M = M To 1 Step -1
With Range("A" & M)
.Hyperlinks(1).Follow

End With
Next M

using this code me open the url
how i save that sites and repoen in excel.
i want to copy a75 (from repoend in excel) and past in main worksheet c cell
is it possible?

 

[anilg0001]

any one help me?

 

[wigi]

Please do not bump after only 19 minutes without a reply.

As I wrote in your previous topic, please inform yourself on webqueries.

Another basic link is this one:

http://www.techrepublic.com/article/pull-data-into-microsoft-excel-with-web-queries/6115870