Microsoft Excel Hyperlink Filename Save

View Other Microsoft Excel Posts Ask New Question Ask New Question With Power Editor

Hyperlink Filename Save

john hay posted at Saturday, November 07, 2009 3:12 PM

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

Reply Reply Using Power Editor

	Rank	Winnings	Points
November	0	$0.00	0
October	0	$0.00	0

RE: Hyperlink Filename Save

Gary Byrne provided a

rated reply to john hay on Sunday, November 08, 2009 9:39 PM

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...

Reply Reply Using Power Editor

I come from a varied background of financial reporting and data analysis, having worked for many of the top mutual fund and investment companies in Boston before heading south for warmer climes. I've been a spreadsheet buff since the early days of using the DOS version of Lotus 1-2-3 in college (booted up from a nice big 5 1/4" floppy). Through the years I've gained a great deal of expertise with Excel, my weapon of choice, along with it's built-in automation companion VBA.

	Rank	Winnings	Points
November	14	$0.00	25
October	15	$0.00	44