ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] EXCELÂà TXTÀÉ, ¦p¦ó¦Û°Ê·s¼WÂù¤Þ¸¹?

¥»©«³Ì«á¥Ñ n7822123 ©ó 2019-6-6 23:08 ½s¿è

¦^´_ 1# mistery


¦s¦¨txt´N¤£­n¥ÎCSV¦sÀɤF¡A§ï¦sÀɮ榡§a¡A¸Õ¸Õ¬Ý

ActiveWorkbook.SaveAs Filename:=spath & "\Q.txt", FileFormat:=xlTextPrinter, CreateBackup:=False
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¦^´_ 3# mistery


  ¥ÎReplace ³B²z¦r¦ê¡A§âªÅ®æÅܦ¨³r¸¹¡A¦]¬°§A¨Sµ¹ÀɮסA©Ò¥H§Ú¤]¥u¯àµ¹«Øij
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD