FSO CopyFolder: sometimes spaces in path?

[EdNerd]

I have a line of code to copy a folder and contents using FileSystemObject (FSO). It works great - until I get a space in the folder name. I'm not sure how to handle this. Any help is appreciated.

In this line, if FldName contains a space, the code errors.

FSO.CopyFolder FromPath, ToPath2 & "\" & FldName, True\

Ed

 

[Domenic]

A space in the folder shouldn't be a problem. However, you have a backslash (\) at the end of your line of code. Is that a typo? Maybe the path to your destination folder is incorrect?

 

[EdNerd]

Yah - it's just a typo. Fat fingers are faster than the brain!! It's not in the code.
Well, I'll keep plugging at it then.
Thanks for the reply.

Ed

 

[AkaTrouble]

does your folder name string have a backslash \ ?? at the other end not the front one you add

 

[EdNerd]

The string makes up just fine. I'm running this to do backups of files in several folders. It will run just fine - until it hits an odd file - and then it kicks out and skips to the next folder. Then only thng that jumped out at me was the possibility of spaces in the FldName variable.

Doesn't seem to be the problem, though. So I'll keep looking. Thanks for chiming in.

Ed

 

[AkaTrouble]

you seem to know what you are doing so ignore this just putting it out there so has been said

your FldName is declared as a string ?

you have put in a folder name in the FldName and tested it with a temp msgbox ?? just to confirm the string is going into the variable correctly ??

 

[EdNerd]

Well, I *thought* everything was making up okay. I mean, I walk through (with F8) and the first fifty or so work just fine. So I figure it's all good and run it. Silly me ....

Going at it differently this time. I'm going to iterate all my folders and write the paths and file names into a worksheet, as well as the strings for where they would wind up. Then I can see where maybe I'm missing a \ or have an extra one, or something like that.

"you seem to know what you are doing" << don't be fooled!! :8>)
If I knew, I'd have this licked by now!

Ed