title: Simple VBA/Macro need to create a new text file with the contents of active sheet without changing filename
body: <p>I need to export data in a sheet to a text file without changing the file name (i.e. not doing "save as".  Also it would be great if the file name could look at the previous like file name in the folder and increase by 1 digit (i.e. :file_1.txt, file_2.txt, etc.)...</p>
  
  <p>Thanks!!</p>