Good Day All,
I am just curious whether am I able to auto generate invoice number based on actual date.
E.g. Today is 5 Apr 2021 and my Invoice number usually will be 050420210001(DDMMYYY0001)
So I change it manually. My VBA already auto +1 when I save the invoice.
'for PDF Draft file save
Sheet9.Range("A1:I51").ExportAsFixedFormat xlTypePDF, Filename:= _
"C:\Users\JOYCELYN SEE\Desktop\FENG YUN\RECEIPT\Draft PDF\" & Sheet9.Range("C9").Value, Openafterpublish:=True
Anyone able to guide me on this please.
Thank You.
I am just curious whether am I able to auto generate invoice number based on actual date.
E.g. Today is 5 Apr 2021 and my Invoice number usually will be 050420210001(DDMMYYY0001)
So I change it manually. My VBA already auto +1 when I save the invoice.
'for PDF Draft file save
Sheet9.Range("A1:I51").ExportAsFixedFormat xlTypePDF, Filename:= _
"C:\Users\JOYCELYN SEE\Desktop\FENG YUN\RECEIPT\Draft PDF\" & Sheet9.Range("C9").Value, Openafterpublish:=True
Anyone able to guide me on this please.
Thank You.