Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
UDF problem in converting data into code 128 B
Function Format_Code128 (InString As String) As String
Dim Sum As Integer, i As Integer Dim Checksum As Integer, Checkchar As Integer Dim MyString As String, CVal As Integer ' Initialize running total with value of ' Subset B start character Sum = 104 ' Scan the string and add character value times position For i = 1 To Len(InString) ' Copy one character from InString position i to MyString MyString = Mid$(InString, i, 1) ' Get the numeric value of the character and subtract ' 32 to shift (the space character, ASCII value 32, has ' a numeric value of 0 as far as Code 128 is concerned) CVal = Asc(MyString) - 32 ' Add the weighted value into the running sum Sum = Sum + (CVal * i) Next i ' Calculate the Modulo 103 checksum Checksum = Sum Mod 103 ' Now convert this number to a character. If Checkdigit = 0 Then Checkchar = 174 ElseIf Checkdigit < 94 Then Checkchar = Checkdigit + 32 Else Checkchar = Checkdigit + 71 End If ' ' Now format the final output string: start character, ' data, check character, and stop character ' MyString = Chr(162) + InString + Chr(Checkchar) + Chr(164) Format_Code128 = MyString End Function I Have coded above UDF to construct data (my data is like "CCF001257") the UDF returns value as ¢CCF001257®¤ but when I changed this into 128 font and took printout the scanner is not reconging it..what will be the problem..will any one trace out ...i have a doubt.. 1.code 128 and code 128 B fonts are different if so.. 2. shall i have to use Code 128 B font does this will slove.. Plz tell me soon... Regards, safi. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
External data Macro Problem Excel 97 | Excel Discussion (Misc queries) |