Automated .txt Data manipulation in Excel using Python

I need a python program which will process .txt files from one directory one-by-one in Excel and after running add-ins tool on the data, save files with the same name and format in another directory. .txt files which will have errors should be saved separately.