change the directory of the of a list of arrays file
Hi, :)
i wanted to change the directory of the of a list of arrays file..
But i am having problem when i wrote the code as shown below.. Its part of what i have wrote..
When i tried to run.. there is a compile error.("CopyFile" was highlighted) Its says " Compile error: Expected Function or variable" I am still very new to VB so does not know what is the problem.. Anyone plz help me ??
VB Code:
If InStr(file.Name, "24_Hours") > 0 Then
outputFiles_s(SummarySize) = Replace(inputFiles_s(SummarySize), ".txt", ".doc")
outputFiles_s(SummarySize) = Replace(outputFiles_s(SummarySize), "_MMM_", thisMonth)
outputFiles_s(SummarySize) = fso.CopyFile(C:\Sp\mmmyyyy\Source", "C:\Sp\mmmyyyy\Report\24hrs\Summary", True)
ElseIf InStr(file.Name, "Mon-Fri") > 0 Then
outputFiles_s(SummarySize) = Replace(outputFiles_s(SummarySize), ".txt", ".doc")
outputFiles_s(SummarySize) = Replace(outputFiles_s(SummarySize), "_MMM_", thisMonth)
outputFiles_s(SummarySize) = fso.CopyFile("C:\Sp\mmmyyyy\Source", "C:\Sp\mmmyyyy\Report\Mon-Sat\Summary", True)
End If
Re: change the directory of the of a list of arrays file
does fso.copyfile actually return anything? If not then you do no need to assign it to the array
Code:
fso.CopyFile "C:\Sp\mmmyyyy\Source", "C:\Sp\mmmyyyy\Report\Mon-Sat\Summary", True
Also, just looking at that above code, would you not need to specify what file you want to copy and the name of the destination to copy to???
Re: change the directory of the of a list of arrays file
Hi Ecniv,
The fso.copyfile doesn't return anything.. In fact i cant compile the code due to it ! Well i have tried the following and it works..
Quote:
outputFiles_s(SummarySize) = "C:\Sp\mmmyyyy\Report\24hrs\Summary" & File.Name
Where File.Name contains the files in the outputFiles_s(SummarySize)