I want create a macro such that it can save my excel sheet into .txt file.
If my workbook has more than one sheet, then a message should appear and shows all the sheets in my workbook and ask me to choose one sheet that I want to save into .txt file.
Lastly, the user can select the directory where he wants to save the .txt file