VBA Excel - Assign saved filename and path to variable
Posted on 2010-11-26
I have a small macro by recorder below, it just save the actual excel file to directory D:\ASN \Test.xls
ActiveWorkbook.SaveAs Filename:="D:\ASN\Test.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
Could you please advise how to assign this saved filename to a variable, which after would be copied by the macro to Sheet2 as clickable hyperlink to cell A1?