View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jay Jay is offline
external usenet poster
 
Posts: 671
Default 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