Use "Name" which includes the full path. You can do this with any file.
Keep the same suffix eg. .xls .doc etc. The syntax is :-


Code:
--------------------
Name "C:\temp\OldName.xls" As "C:\temp\NewName.xls"
--------------------



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