Z
Zygoid
i have a command button on a spread sheet that, when clicked, will sav
the spread sheet in a folder and name it, depending what is in certai
cells. my problem is where i want it saved.
right now, i have all spread sheets being saved into one certai
folder, but i would like the spread sheet to be saved into a folde
that is specified in cell d2.
this is the code i have now.
Sub Save_As_FileName()
FName1 = Range("d2").Value
FName2 = Range("d3").Value
FName3 = Range("d5").Value
FName4 = Range("d6").Value
Fname5 = Range("d7").Value
pth = "f:\bids\"
ActiveWorkbook.SaveAs Filename:=pth & FName2 & " " & FName3 & " "
FName4 & " " & Fname5 & " " & FName1 & ".xls", _
FileFormat:=xlNormal, CreateBackup:=False
End Sub
I have tried changing the pth="f:\bids\" to many different things an
can't seem to figure it out.
any help? Thanks
the spread sheet in a folder and name it, depending what is in certai
cells. my problem is where i want it saved.
right now, i have all spread sheets being saved into one certai
folder, but i would like the spread sheet to be saved into a folde
that is specified in cell d2.
this is the code i have now.
Sub Save_As_FileName()
FName1 = Range("d2").Value
FName2 = Range("d3").Value
FName3 = Range("d5").Value
FName4 = Range("d6").Value
Fname5 = Range("d7").Value
pth = "f:\bids\"
ActiveWorkbook.SaveAs Filename:=pth & FName2 & " " & FName3 & " "
FName4 & " " & Fname5 & " " & FName1 & ".xls", _
FileFormat:=xlNormal, CreateBackup:=False
End Sub
I have tried changing the pth="f:\bids\" to many different things an
can't seem to figure it out.
any help? Thanks