Select a file

[Guest]

I want to select a file and close it. But when execution reaches the line:

Windows("Scope1.txt").Activate

I get the error message:

Subscript out of range (Error 9).

The same command worked for an .xls file earlier in the program. Perhaps
the command is coded differently for a text file?

Appreciate anyone's help in how to do this. Thanks.

 

[Guest]

If scope1.txt is the workbook name, then try using

Workbooks("Scope1.txt).Activate

 

[Guest]

Thanks Tom; it worked! (See separate post for the next question arising.)