請問如何才能使中英文欄位交雜的Excel file 輸出成文字檔時排列會整齊
Mid(testString, 1, 3) = testFile.Cells(RowIntestFile, 1)
Mid(testString, 4, 3) = testFile.Cells(RowIntestFile, 2)
Mid(testString, 7, 3) = testFile.Cells(RowIntestFile, 3)
Mid(testString, 10, 6) = testFile.Cells(RowIntestFile, 4)
Mid(testString, 16, 3) = testFile.Cells(RowIntestFile, 5)
Mid(testString, 22, 4) = testFile.Cells(RowIntestFile, 6)
Mid(testString, 26, 70) = testFile.Cells(RowIntestFile, 7)
以上方法輸出時欄位會隨中文字數而不對齊. 請問我該如何做?
arrow
arrow
    全站熱搜

    vbqa 發表在 痞客邦 留言(2) 人氣()