Not a VBA guy myself, I found Environ() in a Google search actually, so you may be correct.
Perhaps instead of declaring 'fileX' as a constant, it may be prudent to have a GetFilePath(FileName As String) Function, that is supplied the "MyFile.txt" file name, and Returns the "TMP" path & FileName string.
Just a thought.