Export worksheet to txt format

I am new to VBA/macro and trying to import and export txt data format.

In this code/attached sample Excel file, I have successfully imported the text data into Excel and changed the data from text to column. But I cannot export to txt data format.

After I change it to the column, I get a message box:

"There's already data here. Do you want to replace it?" OK/Cancel

Is there any way it can automatically click OK with the VBA code?

After this I would like to save/export the 'Finalize' worksheet data to txt data file where the file name for the txt data should be the value of Worksheet 'Original' C3 and save the txt data into "C:\Users\Bishnu\Desktop\Work" directory.

Please Login or Register  to view this content.

Thank you in advance for your valuable suggestions/help.

Thank you @Kaper. The alert message is disabled with this code.
Any suggestion for exporting the 'finalize' worksheet data to txt data file, where the file name for the txt data should be the value of Worksheet 'Original' and cell C3 and save the txt data into "C:\Users\Bishnu\Desktop\Work" directory?