|
本帖最后由 Gaoyunpeng 于 2020-2-5 20:04 编辑
分享一个控件翻译的实例
使用Excel表作为数据源,进行控件翻译。
翻译代码请参考。
- Sub ControlTranslate()
- Dim strShape As String
- Dim strCNN As String
- Dim strSQL As String
- Dim rst As Object
-
- strCNN = "Provider = Microsoft.ACE.OLEDB.12.0;Extended Properties = 'Excel 12.0;HDR=YES';Data Source = " & ThisWorkbook.FullName
- strSQL = "Select * From [Translate$] "
- Set rst = CreateObject("ADODB.Recordset")
- rst.Open strSQL, strCNN, 1, 1
- If rst.Fields(0).Name = "CN" Then
- Do Until rst.EOF
- strShape = rst.Fields.Item(0)
- Sheets("Main").OLEObjects(strShape).Object.Caption = rst.Fields.Item(1)
- rst.MoveNext
- Loop
- End If
- If rst.Fields(0).Name = "JP" Then
- Do Until rst.EOF
- strShape = rst.Fields.Item(0)
- Sheets("Main").OLEObjects(strShape).Object.Caption = rst.Fields.Item(2)
- rst.MoveNext
- Loop
- End If
- rst.Close
- Set rst = Nothing
- End Sub
复制代码 实例参考附件
|
|