Oops. Sorry. Name doesn't work across devices. I guess you do need the
KILL after all.

"Tim Coddington" wrote in message
...
Name is actually a move, not a copy. I'm sure you could do the
name command, then open the sheet on the D: drive to use it. A
little modification of Tom's code should do the trick.

But, for future reference, the keyword to look up in help is KILL.

"Jako " wrote in message
...
Many thanks that works a treat.

Could you please tell me how i delete the file from

"C:\CASTLE\NORTH WEST\"

after copying it.

Also i don't want to be prompted if i want to delete the file.

Cheers


---
Message posted from http://www.ExcelForum.com/