aatmik_m24
New Member
- Joined
- Aug 2, 2013
- Messages
- 6
My Code for Saving an Invoice Template to PDF at a specified location is -
Sub SavePDF()
' pdf Macro
Application.ScreenUpdating = False
Sheets("Invoice").Select
Range("A1:A52").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _
"G:\Electronyx Bazaar\Invoice\" & Range("A9").Value & " Order No# " & Range("F9").Value & " Invoice No #" & Range("F3").Value & " " & Range("F13").Value & " " & "AWB - " & Range("F11").Value, Quality:=xlQualityStandard, IncludeDocProperties:=
False, IgnorePrintAreas:=False, OpenAfterPublish:=False
Sheets("Invoice").Select
Range("B1").Select
Application.ScreenUpdating = False
End Sub
THIS CODE GIVES ME SYNTAX ERROR.
I DO NOT UNDERSTAND WHERE IS THE ISSUE.
Please help its urgent, this is my invoicing requirement for daily purpose.
Sub SavePDF()
' pdf Macro
Application.ScreenUpdating = False
Sheets("Invoice").Select
Range("A1:A52").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _
"G:\Electronyx Bazaar\Invoice\" & Range("A9").Value & " Order No# " & Range("F9").Value & " Invoice No #" & Range("F3").Value & " " & Range("F13").Value & " " & "AWB - " & Range("F11").Value, Quality:=xlQualityStandard, IncludeDocProperties:=
False, IgnorePrintAreas:=False, OpenAfterPublish:=False
Sheets("Invoice").Select
Range("B1").Select
Application.ScreenUpdating = False
End Sub
THIS CODE GIVES ME SYNTAX ERROR.
I DO NOT UNDERSTAND WHERE IS THE ISSUE.
Please help its urgent, this is my invoicing requirement for daily purpose.