Const PathRoot = "c:\script" Dim objFso, strFolder strFolder = PathRoot & Year(Date) & Mid(Date, 4,2) & Left(Date,2) Set objFso = CreateObject("Scripting.FileSystemObject") If Not objFso.FolderExists(strFolder) Then objFso.CreateFolder(strFolder)
Sub WriteTextFile(tabsum) Const MyFile = "C:\script\test1.csv" ''mais je ne peux pas vraiment utiliser ce chemain car mes dossier je les crees avec la date et lheur reelement et donc ils changent tt le temps Dim objFso, objTextFile Set objFso = CreateObject("Scripting.FileSystemObject
Call WriteTextFile(tabsum)
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionOption Explicit Const cstPathRoot = "D:\SCRIPTS" Dim objFso, strDate, strFolder ReDim tabsum(5) 'init tabsum pour test strDate = Year(Date) & Mid(Date, 4,2) & Left(Date,2) strFolder = cstPathRoot & strDate & Chr(92) Set objFso = CreateObject("Scripting.FileSystemObject") Call CreateFolder(strFolder) Call WriteTextFile(tabsum, strFolder) Set objFso = Nothing WScript.Quit '######################################################### Function CreateFolder(strFolder) If Not objFso.FolderExists(strFolder) Then objFso.CreateFolder(strFolder) CreateFolder = strFolder End Function '###################################### Sub WriteTextFile(tabsum, strFolder) Dim objTextFile, strFileTabSum strFileTabSum = strFolder & Year(Date) & Mid(Date, 4,2) & Left(Date,2) & _ Replace(Time,Chr(58), vbNullString) & ".csv" MsgBox strFileTabSum Set objTextFile = objFso.CreateTextFile(strFileTabSum,True) objTextFile.WriteLine Join(tabsum, vbCrLf) objTextFile.Close Set objTextFile = Nothing End Sub '######################################
strDate = Year(Date) & Mid(Date, 4,2) & Left(Date,2)
strFolder = cstPathRoot & strDate & Chr(92)
Set objFso = CreateObject("Scripting.FileSystemObject")
Call CreateFolder(strFolder)
Call WriteTextFile(tabsum, strFolder)
Set objFso = Nothing
WScript.Quit
belouniss nous met des bouts de code.
PositionFile= "C:\script\Deplacement"& myDay 'ca c pr ceer mon dossier cela march tr bien ArgFile= "C:\script\Deplacement" & myDay & Monfichier & ".csv" dosn't work!!!!
PositionFile= "C:\script\Deplacement"& myDay ArgFile= PositionFile & chr(92) & Monfichier & ".csv" msgbox ArgFile 'Chr(92) correspond au ""