[算表] 再一次請問txt命名（上個問題的拓展問題)
軟體:office
版本:2007
Open "F:\SmthBetdata\Bet\" & "\2015年的第w周數據(m.dd-m.dd).txt" For Output
As #1
要求前面w則命名第16周，后面括號的區間命名（4.12-4.16）最后的效果是得到一個文
件名為
2015年的第16周數據(4.12-4.18)
ps：區間是上周六0:00到本周六24:00
目前處理的方法是先在B1寫了相關函數，得到B1單元格內容為
“2015年的第16周數據(4.12-4.18)”，然后
Open "F:\SmthBetdata\Bet\" & Sheets(1).[B1] & ".txt" For Output As #1
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 27.38.52.160
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1429439924.A.10A.html
→
04/19 18:44, , 1F
04/19 18:44, 1F
→
04/19 18:47, , 2F
04/19 18:47, 2F
→
04/19 18:48, , 3F
04/19 18:48, 3F
→
04/19 18:49, , 4F
04/19 18:49, 4F
→
04/19 18:50, , 5F
04/19 18:50, 5F
→
04/19 18:51, , 6F
04/19 18:51, 6F
→
04/19 18:55, , 7F
04/19 18:55, 7F
→
04/19 18:56, , 8F
04/19 18:56, 8F
→
04/19 18:57, , 9F
04/19 18:57, 9F
→
04/19 18:57, , 10F
04/19 18:57, 10F
→
04/19 19:23, , 11F
04/19 19:23, 11F
→
04/19 19:57, , 12F
04/19 19:57, 12F
→
04/19 19:57, , 13F
04/19 19:57, 13F
→
04/19 20:23, , 14F
04/19 20:23, 14F
→
04/19 20:34, , 15F
04/19 20:34, 15F
→
04/19 20:39, , 16F
04/19 20:39, 16F
→
04/19 20:40, , 17F
04/19 20:40, 17F
→
04/20 00:26, , 18F
04/20 00:26, 18F
→
04/20 00:26, , 19F
04/20 00:26, 19F
→
04/20 00:27, , 20F
04/20 00:27, 20F
→
04/20 00:27, , 21F
04/20 00:27, 21F
→
04/20 00:28, , 22F
04/20 00:28, 22F
→
04/20 06:58, , 23F
04/20 06:58, 23F
→
04/20 06:58, , 24F
04/20 06:58, 24F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
