|
-
May 12th, 2005, 01:36 AM
#1
Thread Starter
New Member
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
-
May 12th, 2005, 02:57 AM
#2
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???
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
May 12th, 2005, 05:05 AM
#3
Thread Starter
New Member
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..
outputFiles_s(SummarySize) = "C:\Sp\mmmyyyy\Report\24hrs\Summary" & File.Name
Where File.Name contains the files in the outputFiles_s(SummarySize)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|