For i = 0 To 40 Step 1
code = Str(i)
StrFilePath = "C:\UPPER\" + code
Shell ("Command.com /C " + "md " + StrFilePath)
FileName = StrFilePath & "\MYFILE.TXT"
Open FileName For Output As #1
If rs_S.RowCount > 0 Then
rs_S.MoveFirst
While Not rs_S.EOF
Print #1, Trim(rs_S!DATA)
rs_S.MoveNext
Wend
End If
Close #1
Next i
我想把MYFILE.TXT寫在0至40的Directory下,
以上的program什麼也出不了.
如果把FileName = StrFilePath & "\MYFILE.TXT"
改為 FileName = StrFilePath & "MYFILE.TXT"
沒有了 '/' 這符號,
就可以寫到file,但在C:\UPPER\下,
File名字易改成 0MYFILE.TXT..1MYFILE.TXT...40MYFILE.TXT
我怎樣才可把FILE寫到
C:\UPPER\0\MYFILE.TXT
C:\UPPER\1\MYFILE.TXT
:
C:\UPPER\39\MYFILE.TXT
C:\UPPER\40\MYFILE.TXT
請幫幫我,我真的很迷茫!! (:_:)
謝謝!