FSO.copyfile issue.

[Devonair]

Hi guys,

I have a problem, I made a Sub function that copies files to multiple folder.
its working fine except for one particular folder. I don't understand why it is keep copying 1 level below of target sub folder and the filename is changed to April - 1901-04-2019 <filename>.<ext>. All other files in different folders are copied normally without issue.

I used debug.print to see the source location and the print out

-Source-
the sub directory OK
the filename

-Destination-
the sub directory OK
the filename CHANGED

and after copy seeing the result its below 1 level sub directory.

Ex
M:\sub1\sub2\sub3\<filename>.<ext>
copied to....

M:\sub1\sub2\<date with 1909 year><filename>.<ext>​

Anybody has an Idea why it is doing like this?
I copy to network server by the way.



Thanks again guys

 

[Fluff]

Maybe missing a \ after the last directory.

 

[Devonair]

Maybe missing a \ after the last directory.

thank you for your fast reply

I think My excel is having issues again. now its showing different error 1004
same as before I had the IT team re install excel here.

 

[bobsan42]

Most probably you are missing a \ at the end of the path so the last folder becomes part of the filename.
To be on the safe side always add a \ at the end of the path - FSO treats consecutive \ as one so you don't have to worry about that too.

And it is always best to post at least the relevant part of your code - esp. if you are getting weird errors.

 

[Fluff]

Please post the entire code that you are using, mark which line is causing the error & include the full error message