Hi I have the following code,
I am trying to save the print area of only one page of my workbook, as a pdf with the file name as K3 & save it in a specified folder, It just isnt working as it's saving it as a excel macro enabled workbook. Can anyone help?
Sub SAVEPDF()
'
' SAVEPDF Macro
'
Dim FName As String
Dim FPath As String
Dim username As String
username = Environ$("username")
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF
FPath = "C:\Users\" & username & "\Dropbox\Quotations To Be Emailed"
FName = ActiveWorkbook.ActiveSheet.Range("k3").Text
ThisWorkbook.SaveAs Filename:=FPath & "\" & FName
End Sub
Bookmarks