[算表] EXCEL匯入.TXT檔案
軟體:office excel
版本:2007以上
請問大大,
1.我要匯入100個以上的TXT檔案到EXCEL裡面,有快速的方法嗎?
2.如何讓EXCEL自動更新這TXT檔裡的資料,我試過都要手動更新,
還是需要寫後端的VBA程式來控制?若是的話如何撰寫?
以上的問題,麻煩大大了,感恩
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 59.127.45.45
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1416015942.A.60F.html
→
11/15 15:43, , 1F
11/15 15:43, 1F
→
11/15 15:53, , 2F
11/15 15:53, 2F
→
11/15 15:53, , 3F
11/15 15:53, 3F
→
11/15 15:54, , 4F
11/15 15:54, 4F
→
11/16 07:58, , 5F
11/16 07:58, 5F
→
11/16 18:26, , 6F
11/16 18:26, 6F
→
11/16 18:57, , 7F
11/16 18:57, 7F
→
11/16 23:31, , 8F
11/16 23:31, 8F
→
11/16 23:31, , 9F
11/16 23:31, 9F
→
11/17 00:08, , 10F
11/17 00:08, 10F
→
11/20 12:51, , 11F
11/20 12:51, 11F
→
11/20 13:07, , 12F
11/20 13:07, 12F
→
11/20 18:20, , 13F
11/20 18:20, 13F
→
11/20 18:20, , 14F
11/20 18:20, 14F
→
11/20 22:51, , 15F
11/20 22:51, 15F
→
11/21 23:36, , 16F
11/21 23:36, 16F
→
11/23 12:51, , 17F
11/23 12:51, 17F
→
11/24 17:55, , 18F
11/24 17:55, 18F
→
11/24 17:55, , 19F
11/24 17:55, 19F
→
11/24 18:16, , 20F
11/24 18:16, 20F
→
11/24 18:16, , 21F
11/24 18:16, 21F
→
11/24 18:16, , 22F
11/24 18:16, 22F
→
11/24 18:17, , 23F
11/24 18:17, 23F
→
11/24 18:21, , 24F
11/24 18:21, 24F
→
11/24 18:21, , 25F
11/24 18:21, 25F
→
11/24 18:22, , 26F
11/24 18:22, 26F
→
11/24 18:22, , 27F
11/24 18:22, 27F
→
12/13 10:22, , 28F
12/13 10:22, 28F
→
01/06 22:58, , 29F
01/06 22:58, 29F
Office 近期熱門文章
PTT數位生活區 即時熱門文章