Hyperlink Filename Save

Apologies, but I am a newbie.

I have a list of hyperlinks in a column in excel 2007. The hyperlink names are incremented by one i.e. ABB01, ABB02, ABB03. Each of the hyperlinks goes to the same template. I would like to know how to save the template with the same name for the hyperlink that was used to open it. Thank you.

Stumpy

Hi, do you know how to use macros or VBA at all?  You can use the following code to save a file with filename from a label in a cell.  Let's say you have some text in cell A1...

savename = range(“A1”).text & ".xls"

ActiveWorkbook.SaveAs Filename:=savename, FileFormat:= _

    xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False

You can also write a loop to do the same for an entire range of cells...