[VBA ] 請問輸出問題

[silvaco ()]

Dim FileNo As Integer
Dim CurrentLine As String
Dim Filename As String

Filename = "C:\Documents and Settings\data.txt"


' Define file name


FileNo = FreeFile               ' Establish free file handle

Open Filename For Output As #FileNo         ' Open file (writing mode)
Print #FileNo, "This is a line of text"      ' Save line
Print #FileNo, "This is another line of text"   ' Save line
Close #FileNo                  ' Close file


請問我要如何才能讓data可以變成是一個變數呢??
我想用now()函數把每天的檔案存進去~
請問可行嗎??該怎麼做呢??
請大家指導一下~~謝謝

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 220.135.251.190
推 dingyuchi:"C:\Documents and Settings\" & Now() & ".txt"
→ dingyuchi:Now() 出來的東西你還要改一下 因為有些符號不能當檔名
推 fumizuki:Format(Now, "yyyymmdd")