Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Char() in Macro
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Char() in Macro
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 "slideman " wrote in message ... 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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Char() in Macro
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
char() | Excel Discussion (Misc queries) | |||
FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
Can excel macro access SUBstring individual 'char' level? If so how? | Excel Discussion (Misc queries) | |||
8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
CHAR(10) | Excel Worksheet Functions |