The key is Python for Windows : http://starship.python.net/crew/mhammond/win32/ See here for an Excel dispatch example: http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/325735 When doing such operations, I generally save all the Excel files to CSV files and do the operations on them using the csv module.