Error:Subscript out of range

J

Jay

Thanks in advance.

My Excel file (File1) wants to use SaveCopyAs to save File2 in a differnent
folder.
---- From File1 -----
Application.Workbooks("File_2").SaveCopyAs Filename:=

This code gives an error:Subscript out of range.
How can I access File2 from File1 where they reside in different folders.

Jae
 
D

Dave Peterson

I think...

Make sure you include the file extension, too.

like:
Application.Workbooks("File_2.xls").SaveCopyAs Filename:=...
 
Top