Hello Friends,
I have 2 worksheets.
Sheet 1 has list of invoice details with invoice numbers in more than 2500+ rows.
Sheet 2 has Invoice Format. Based on Invoice numbers in cell no. 'T5', all Invoice details will be filled.
in Sheet 2, I wish to save each PDF print of these invoices separately with changes in invoice no. in cell 'T5' based on no. of rows in "Sheet 1" from cell 'B6'. Only positive invoice value in Cell 'T26' should be printed.
I have made below code for print in PDF with file name as per cell no. T5
Code
Sub Macro2()
'
' Macro2 Macro
'
'
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\gmoghe\Documents\Gaurav\Gaurav\Shares4U\" & Range("T5").Value, Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=False
End Sub
Display More