title: Close text file when I already use Workbooks.OpenText to open it
body: <p>i'm new in this forum and I would like to share my wisdom and you convey me yours.</p>
  
  <p>I have enough experience with Excel Macros but this problem I couldn't find a solution. </p>
  
  <p>I open a text file with Workbooks.OpenText to work in Excel.</p>
  
  <p><code>Workbooks.OpenText Filename:=myfile, DataType:=xlDelimited, Origin:=xlWindows, Other:=True, OtherChar:=","</code></p>
  
  <p>But when I will close it, I can't. I try with the next instructions:</p>
  
  <ul>
  <li>Workbooks(myfile).Close</li>
  <li>ActiveWorkbook.Close</li>
  </ul>
  
  <p><code>myfile = "path\file.txt"</code></p>
  
  <p>When i use this instructions, Excel says that i cant use it. I only need to take some information of this text files and close it without save.</p>
  
  <p>Can anybody help me with these?</p>