FileSystemObject.CopyFile is not able to copy file from one folder to another

Question

I have a piece of VBS code where a file(C:\test.txt) should be copied to a newly created temporary folder. But it fails to copy the file. Weird thing is that the same function works fine when I have wild characters in the source parameter (C:\ *est.txt). Any advice would be really helpful.

set fso = createobject("Scripting.FileSystemObject")
if fso.FileExists(src_temp) then
    'src_temp contains the file path.

    'Path of the temporary folder
    Set tmp_fld = fso.GetSpecialFolder(TemporaryFolder)
    tmp_fld = tmp_fld & "\OldFiles_tmp"

    'Create the temporary folder if does not exist
    If Not fso.FolderExists(tmp_fld) Then 
        fso.CreateFolder(tmp_fld)   
    End If

'Copy the files to temporary path
On Error Resume Next
fso.CopyFile src_temp, tmp_fld, True 'last parameter is set as true for overwriting the existing
On Error Goto 0

End If

I have verified if destination temporary folder is created and also the path and other stuffs. How can a wild character in the path makes the CopyFile work and same does not work for complete file name. Also how to solve this issue?

It might have something to do with windows not properly detecting whether tmp_fld is supposed to be a file or a folder. In this case it would help if you replace tmp_fld = tmp_fld & "\OldFiles_tmp" with tmp_fld = tmp_fld & "\OldFiles_tmp\" (trailing backspace). This is just a wild guess though. — Syberdoor
– Syberdoor, Commented Dec 16, 2015 at 13:02
src_temp contains the file path... Does it include file name? — ManishChristian
– ManishChristian, Commented Dec 16, 2015 at 13:38

Eduardo Poço · Accepted Answer · 2015-12-16 23:49:26Z

2

Put a backslash (\) at the end of the destiny folder:

tmp_fld = tmp_fld & "\OldFiles_tmp\" 'note the \

I tested and it worked for me. But, strangely, the wildcard thing was not working for me in the original source code.

answered Dec 16, 2015 at 23:49

Eduardo Poço

3,1492 gold badges21 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

FileSystemObject.CopyFile is not able to copy file from one folder to another

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related