Copying files from PC to PC

[Alan Perry]

Using Excel 2003 VBA under XP I want to copy from

\\PC_NAME\C$\DATA
to
H:\DATA_BACK_UP

I have tried FileCopy but it keeps throwing "Permision Denied"
And so does Microsoft Scripting Runtime.

This will probably be some thing obvious....

Last resort is to Shell("cmd /c copy \\PC_NAME\C$\DATA\test.dat H:\DATA_BACK_UP")
But this takes an unkown amount of time and I want to delete the old files


Cheers

Alan

 

[crispbd]

Sounds like the file copy is violating the share permissions on th
network