Thread: Select a file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hmm hmm is offline
external usenet poster
 
Posts: 175
Default Select a file

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.