åºãä¸å人æ°å
±åå½ç½ç»å®å
¨æ³ãè¦æ±ï¼èª2017å¹´6æ1æ¥èµ·ï¼ä½¿ç¨äºèç½æå¡éè¿è¡å¸å·å®å认è¯ã为ä¿éæ¨çç¾åº¦å¸å·è½å¤æ£å¸¸ä½¿ç¨ï¼è¯·å°½å¿«å¯¹å¸å·è¿è¡ææºå·éªè¯ï¼æè°¢æ¨çç解ä¸æ¯æã
å¦ä½ç¨VBA ä»TXTæ件ä¸æåç¸å
³æ°æ®è¾å
¥excelè¡¨æ ¼ï¼
æçTXTæ件ç»æå¦ä¸ P000000001987456 C0000000024835410020101103002018000020101102 C0000000034824360020101102002018000020101101 T0000000040000000000000000000000000000000000 解éå¦ä¸ï¼ P000000001987456ï¼ è¿æ¯æ´ä¸ªTXTæ件ç第ä¸è¡ï¼7个é¶å...å±å¼
ææç½å¯ä»¥ç¨å¯¼å
¥æ°æ®çå½¢å¼æTXTæ件导å
¥å°excel è¡¨æ ¼(XLS),ä½æ¯æè¿æ¯å¸æè½ç¨VBAæ¥å¤çï¼å 为æç»çä¾ååªæ¯æ°æ®çä¸é¨åï¼æ¯è¡æ°æ®è¿å
å«å¾å¤å
¶å®å
容ï¼èæåªæ³æåç¸åºçé¨åã谢谢大家ã
xfwxiao | æµè§ 6831 次
æææ´å¥½ççæ¡
åå¸äº2010-11-10 14:32æä½³çæ¡
Public Sub abc()
Dim filename, inputstring As String
Dim i As Integer
Dim data
i = 1
filename = "d:\WYKS.txt" 'æ¬åTXTæ件æ¾å¨Dçä¸
Open filename For Input Access Read As #1
Do While Not EOF(1)
Line Input #1, inputstring '读TXTæ件ä¸è¡
data = inputstring
If i <> 1 Then
Cells(i - 1, 1) = Mid(data, 11, 6) 'æªåä»ç¬¬11个å符å6个å符
Cells(i - 1, 2) = Mid(data, 19, 8) 'æªåä»ç¬¬19个å符å8个å符
Cells(i - 1, 3) = Mid(data, 29, 6) 'æªåä»ç¬¬29个å符å6个å符
温馨提示:答案为网友推荐,仅供参考