I'm using a cell contents to generate a save-as filename, but am stuck on getting a drive & folder destination going for this...
Please help!
Thanks!
Z:\TLA\
Sub Save_TLA()
ActiveWorkbook.SaveAs Filename:= _
Worksheets("ID and cust info").Range("b42").Text & ".xls", FileFormat _
:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:= _
False, CreateBackup:=False
End Sub
Please help!
Thanks!
Z:\TLA\
Sub Save_TLA()
ActiveWorkbook.SaveAs Filename:= _
Worksheets("ID and cust info").Range("b42").Text & ".xls", FileFormat _
:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:= _
False, CreateBackup:=False
End Sub