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

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

--
crispb
-----------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...fo&userid=1088
View this thread: http://www.excelforum.com/showthread.php?threadid=26288