Pesticide GST Invoice A4 size Half Page Print & PDF Save Auto Serial no in Invoice

on

 





GST INVOICE VIDEO LINK FOLLOW

Download File :

https://drive.google.com/file/d/1Y0Fxp06Cg1M8CDlyuNjMp-x8m0WJRFKE/view?usp=sharing


Fully Automatic Invoice no generate & PDF file Save or Excel Duplicate File save.

Download FIle Module 1 Coding: Sub Saveinvoice() 'for PDF file save Sheet1.Range("A1:K23").ExportAsFixedFormat xlTypePDF, Filename:="Path your invoice saving folder\" & Sheet1.Range("C6").Value, openafterpublish:=True Range("C6").Value = Range("C6").Value + 1 Range("C7:H7").ClearContents Range("J7:K7").ClearContents Range("C8:H8").ClearContents Range("J8:K8").ClearContents Range("B10:B17").ClearContents Range("D10:D17").ClearContents End Sub Module 2 Coding : Sub SaveInvoiceExcel() Dim NewFN As Variant ' copy invoice to a new workbook ActiveSheet.Copy NewFN = "Path your invoice saving folder\" & Range("C6").Value & ".xlsx" ActiveWorkbook.SaveAs NewFN, FileFormat:=xlOpenXMLWorkbook ActiveWorkbook.Close Saveinvoice End Sub Any Query please comment if you your own invoice system generate please comment.

Comments

Post a Comment