Code
If [KNSales] = 0 Then
'KN Saving
'Saving CSV for KN
Sheets("KN").Select
ChDir _
"A:\Kitchn\Invoices 2016"
ActiveWorkbook.SaveAs Filename:=InvoiceMonth, _
FileFormat:=xlCSV, CreateBackup:=False
'Saving PDF for KN
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=InvoiceMonth, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False
Else: End If
Display More
Is there something obvious missing that im getting this error?: http://i.imgur.com/fgxmTit.png