Error:Subscript out of range
 

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

Error:Subscript out of range
 

I think...

Make sure you include the file extension, too.

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

Jay wrote:

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

--

Dave Peterson