⑴ 想做一個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集中於企業內部管理管控,管理規范,高效,協同,透明。通過雲模式,低成本,快速部署,即租即用幫助企業免除硬軟體投入的快速 搭建企業管理架構。