Is it possible to make a macro that copy data from a Excel sheet to a txt-file?

I need a macro that can copy to or save as txt, every time a save the Excel file, so it's always updated.
Also it has to save the txt-file next to the Excel-file, so I'm able to move it or copy the Excel-file to a new location.


I'll hope that someone can assist me?

Thank you