¡@¼ÊºÙ: ÀH·ÄÆ¿ºªº¦Ð¤ò ¡@ÀY»Î: [±s¥Î]¼ç¤ô¸¥
°ª¤¤¥Í
- ©«¤l
- 852
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 918
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7 , XP
- ³nÅ骩¥»
- Office 2007, Office 2003,Office 2010,YoZo Office
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¦t©z
- µù¥U®É¶¡
- 2011-4-8
- ³Ì«áµn¿ý
- 2024-2-21
|
¥»©«³Ì«á¥Ñ mark15jill ©ó 2012-3-27 15:49 ½s¿è
¦^´_ 7# tommy.lin
³Â·Ð¶K¹Ï ¬ÝþÃ䦳¿ù..
Sub xyw()
Columns("g:g").Select
Selection.TextToColumns Destination:=Range("m1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _
:="/", FieldInfo:=Array(Array(3, 2), Array(2, 2), Array(1, 2)), _
TrailingMinusNumbers:=True
sy = Columns("o:o").Value
Columns("t:t") = sy
sm = Columns("n:n").Value
Columns("u:u") = sm
sd = Columns("m:m").Value
Columns("v:v") = sd
Columns("m:o").Clear
End Sub |
|