⑴ 想做一个EXCEL表格，实现助记码功能
使用方法：
1、 打开要生成的EXCEL文件，选择工具--宏---Visual Basic编辑器（快捷键：alt+f11）。
3、 代码部分：
Function PinYin(Hz As String)
Dim PinMa As String
Dim MyPinMa As Variant
Dim Temp As Integer, i As Integer, j As Integer
PinMa = "a,20319,"
PinMa = PinMa & "b,20283,"
PinMa = PinMa & "c,19775,"
PinMa = PinMa & "d,19218,"
PinMa = PinMa & "e,18710,"
PinMa = PinMa & "f,18526,"
PinMa = PinMa & "g,18239,"
PinMa = PinMa & "h,17922,"
PinMa = PinMa & "j,17417,"
PinMa = PinMa & "k,16474,"
PinMa = PinMa & "l,16212,"
PinMa = PinMa & "m,15640,"
PinMa = PinMa & "n,15165,"
PinMa = PinMa & "o,14922,"
PinMa = PinMa & "p,14914,"
PinMa = PinMa & "q,14630,"
PinMa = PinMa & "r,14149,"
PinMa = PinMa & "s,14090,"
PinMa = PinMa & "t,13318,"
PinMa = PinMa & "w,12838,"
PinMa = PinMa & "x,12556,"
PinMa = PinMa & "y,11847,"
PinMa = PinMa & "z,11055,"
MyPinMa = Split(PinMa, ",")
For i = 1 To Len(Hz)
Temp = Asc(Mid(Hz, i, 1))
If Temp < 0 Then
Temp = Abs(Temp)
For j = 45 To 1 Step -2
If Temp <= Val(MyPinMa(j)) Then
PinYin = PinYin & MyPinMa(j - 1)
Exit For
End If
Next
Else
' 保留非汉字字符
PinYin = PinYin & Mid(Hz, i, 1)
End If
Next
PinYin = Trim(PinYin)
End Function
4、 保存后，回到EXCEL内容编辑界面 。
5、 在需要生成助记码的地方。输入公式=pinyin(相应的汉字单元格)。
⑵ 电子表格中如何生成助记码
用宏自定义函数吧。在Excel中同时按Alt和F11进入宏界面，点菜单的插入，模块，粘贴如下代码：
Function SZPY(tmpStr As String) As String
Dim i, j As Integer
j = Len(tmpStr)
For i = 1 To j
SZPY = SZPY & WorksheetFunction.VLookup(Mid(tmpStr, i, 1), _
[{"吖","a";"八","b";"嚓","c";"咑","d";"鵽","e";"发","f";"猤","g";"铪","h";" 夻","j";"咔","k";"垃","l";"呒","m";"旀","n";"噢","o";"妑","p";"七","q";"囕","r";" 仨","s";"他","t";"屲","w";"夕","x";"丫","y";"帀","z"}], 2)
Next i
End Function
回到Excel，在B1输入 =SZPY(A1)
缺点，一些多音字不识别。
⑶ 管家婆普及版如何自动生成商品编号
如果是辉煌普及版的话，只能每次录入商品时收工编写号码了。2008++虽然不能自动编号，但是在连续录入同类商品时，可以勾选编号递增，省去手工录入。
⑷ 我想在Excel中输入条形码后，后面的商品名称和型号自动录入进去怎么做
先做一张货品档案表，包括条码、名称、型号、价格等等
需要根据条码自动生成名称、型号、价格可以使用vlookup函数
⑸ 用友T1怎么能不让助记码要自动生成
T1普及版的没有这个功能，标准版的有，我也把助记码改成供销商店名了，一查商品出来就知道是谁家的，挺方便的。
⑹ 在软件中商品、供应商、客户档案助记码如何生成
助记码是由名称各字的首字母组成，录入档案名称时自动生成，如果是导入的数据，就不存在助记码。
德晟创想科技
⑺ 想把T3财务软件里“库存商品”下面的所有商品以助记码的形式导出来个excel表，怎么弄
1、使用账套主管身份登录到T3财务软件中，进入“基础设置”之后进入“存货档案“。
⑻ EXCEL里怎么生成助记码
什么助记码？汉字的拼音首字母吗？
⑼ excel助记码生成
使用方法：
1、 打开要生成的EXCEL文件，选择工具--宏---Visual Basic编辑器（快捷键：alt+f11）。
3、 代码部分：
Function PinYin(Hz As String)
Dim PinMa As String
Dim MyPinMa As Variant
Dim Temp As Integer, i As Integer, j As Integer
PinMa = "a,20319,"
PinMa = PinMa & "b,20283,"
PinMa = PinMa & "c,19775,"
PinMa = PinMa & "d,19218,"
PinMa = PinMa & "e,18710,"
PinMa = PinMa & "f,18526,"
PinMa = PinMa & "g,18239,"
PinMa = PinMa & "h,17922,"
PinMa = PinMa & "j,17417,"
PinMa = PinMa & "k,16474,"
PinMa = PinMa & "l,16212,"
PinMa = PinMa & "m,15640,"
PinMa = PinMa & "n,15165,"
PinMa = PinMa & "o,14922,"
PinMa = PinMa & "p,14914,"
PinMa = PinMa & "q,14630,"
PinMa = PinMa & "r,14149,"
PinMa = PinMa & "s,14090,"
PinMa = PinMa & "t,13318,"
PinMa = PinMa & "w,12838,"
PinMa = PinMa & "x,12556,"
PinMa = PinMa & "y,11847,"
PinMa = PinMa & "z,11055,"
MyPinMa = Split(PinMa, ",")
For i = 1 To Len(Hz)
Temp = Asc(Mid(Hz, i, 1))
If Temp < 0 Then
Temp = Abs(Temp)
For j = 45 To 1 Step -2
If Temp <= Val(MyPinMa(j)) Then
PinYin = PinYin & MyPinMa(j - 1)
Exit For
End If
Next
Else
' 保留非汉字字符
PinYin = PinYin & Mid(Hz, i, 1)
End If
Next
PinYin = Trim(PinYin)
End Function
4、 保存后，回到EXCEL内容编辑界面 。
5、 在需要生成助记码的地方。输入公式=pinyin(相应的汉字单元格)。
⑽ U8+怎么操作批量生成助记码
【基础设置】-【批量生成助记码】，点击此按钮，在弹出界面上由用户勾选需要批量生成的助记码。包括会计科目、常用摘要、客户档案、供应商档案、职员档案、部门。提示：注意：对于已经有助记码的档案，自动重置助记码，按照助记码生成规则覆盖原助记码。对于没有设置助记码的档案，自动根据助记码生成规则生成助记码。
U8cloud产品定义:U8 cloud不同于传统的ERP,是融合了交易、服务、管理于一体的整体解决方案。U8 cloud集中于企业内部管理管控,管理规范,高效,协同,透明。通过云模式,低成本,快速部署,即租即用帮助企业免除硬软件投入的快速 搭建企业管理架构。