Open hyperlink to PDF on website and save file

[NewDaddy]

Hello

I need some help please

I have a transaction report. On each transaction line instead of a description of what the invoice is for there is a hyperlink which opens up PDF on a web page showing a copy of the invoice.

I would like to right a routine to loop through each of these (those which are selected), open and then save to my c drive then close.

I am ok on the loop part but am unsure how to pass the hyperlink to open the document and then save.

Thanks
J

[NewDaddy]

Hi

Sorry mistyped a bit.

I can open the document using ActiveWorkbook.FollowHyperlink "THe link" but now out of my domain and unsure how to programically save and then close.