Error:Subscript out of range

  • Thread starter Thread starter Jay
  • Start date Start date
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
 
I think...

Make sure you include the file extension, too.

like:
Application.Workbooks("File_2.xls").SaveCopyAs Filename:=...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging 800 Excel files 1
how to keep formula don't changed when I copy the file the folder 1
Batch file for file list 2
Merging files with nearly identical values in one column 3
Is it possible to recover a deleted sheet after saving the file? 1
formula/a way to find unmatch items in two file 1
Excel Open Error 7
how to get one row out of every two rows? 5

Back
Top