Save to specified drive, folder

[Markkens]

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

 

[Norie]

So what's in the cell and what/where do you want to save the file as?

 

[chicagodiceman]

You probably need to specify the directory to store:

Sub Save_TLA()
ChDir "Z:\TLA"
ActiveWorkbook.SaveAs Filename:= _ 
Worksheets("ID and cust info").Range("b42").Text & ".xls", FileFormat _ 
:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:= _ 
False, CreateBackup:=False 
End Sub

 

[Markkens]

Got it. I just added the drive and path as part of the cell contents to read as a filename, giving the save a full path and filename.

Thanks!