How to close an open .txt file.

[OaklandJim]

I have an open .txt file. I know where it is (path). How do I close it?

Dim sPath as string

Dim sFileName as string

sPath = "C:\Users\Bob\Desktop\"

sFileName = "Test.txt"

Application.DisplayAlerts = False

Close sPath & sFileName

 

[cmowla]

Did you open the .txt file using VBA?

If so, then the easy way is to put that code and the code to close it in the same sub.

If not (which actually seems to be the case), the only way to close it is to close the application that's viewing it by accessing the Windows Task Manager with VBA. (So notepad, notepad++, etc.)

Please let us know which it is (and if the latter, the name of the application that your .txt file is opened in as it appears in Task Manager).

 

[OaklandJim]

I am trying to determine if I can help the person who made this post Close all Hyperlinked Files

They are trying to close files opened via hyperlinks that are in the workbook.

I'm guessing that the file was opened using associated programs. So .txt probably Notepad? (I use Notepad++ on my computer so I may have to change the association temporarily.) They say Word files too. Of course closing all excel files is easy.