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/