Hi,
I have something already in use that saves an excel doc to a specific location with the filename based on a cells value.
I am wanting to do the same but printing/saving in a pdf, I can't figure out how I need to change the bottom line to save as pdf and not as xlsm, any help would be appreciated.
I have something already in use that saves an excel doc to a specific location with the filename based on a cells value.
I am wanting to do the same but printing/saving in a pdf, I can't figure out how I need to change the bottom line to save as pdf and not as xlsm, any help would be appreciated.
VBA Code:
Dim FName As String
Dim FPath As String
FPath = Sheets("Timber Programme").Range("W3").Text
FName = Sheets("Timber Programme").Range("X3").Text
ThisWorkbook.SaveAs Filename:=FPath & "\" & FName