Using Char() in Macro

  • Thread starter Thread starter slideman
  • Start date Start date
S

slideman

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..........:confused:
 
Use the Chr() function. E.g.,

Dim S As String
S = Format(Now,"yymmdd") & Chr(65)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top