Save single sheet from workbook as text file

[Zibi]

Hi

I need to save single sheet from workbook (sheet7) as text file in specific folder (c:\Test) if the file exists a warning should show if you would like to over-write the file. And et the end change file extension from .txt to .dat

Thanks
Zibi

 

[xenou]

Duplicate: http://www.mrexcel.com/forum/excel-...fic-sheet-work-book-txt-file.html#post3292526

Please allow time in the original thread for an answer - duplicate posts on the same topic are against forum rules. Please see rule #9 in Forum Rules