Need to Edit Existing Export Button in Workbook

[Aashna]

Hello there,

I am using Excel 2010
Issue: On clicking the 'export' button embedded on worksheet gives the undesired result. So need to edit the code.
Result: After clicking the button a dialogue box shows up with text 'Export Complete. Export files have been saved in XXXXXXXXXXXXX'


Desired result: On-clicking that button I want to generate a text file of data entered into that worksheet and save the text file to the user's desktop.

Please let me know if you need any further information.
Your help will be highly appreciated.