VBA app - filecopy failure with - Chinese/Japanese characters

[r4qm4n]

Hi All,

I've developed a VBA app to copy ~15,000 files from server A to server B.
I'm about halfway through the copy, so far so good, except that I have a few
hundred files owned by foreign students (generally Japanese/Chinese but
others also) in a character set that the VBA filecopy will not copy
(filecopy just errors, and refers to the file something like \Application
Data\Microsoft\Office\Recent\?????.txt).

Copying the files manually in explorer works fine.

Any ideas how I work round this ?

cheers

Steve

 

[Chirag]

Try using SHFileOperation() Shell API. It should do the job.

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html

 

[r4qm4n]

Thanks for the suggestion Chirag, found some useful code over at VBnet:
http://vbnet.mvps.org/index.html?code/shell/shdirectorycopy.htm

r4q