Hello,
I built a system that generate invoice number.
Now it work on excel , and i want to convert it to macro in vba.
My problem is that you can't use char() in vba.
I need the generator to generate number of invoice with the date the
day and A,B,C............ I give an exmpale:
Lets say I did three invoices on the date 11/8/04, the invoice genrate
will give me :
1) 040811
2) 040811A
3) 040811B

For now i use in excel : =TEXT(TODAY(),"yymmdd") & Char(65)

Thanks for your help..........


---
Message posted from http://www.ExcelForum.com/