I am looking for a way to automate opening & repairing Excel workbooks via VBA. A process that is run by another department creates a file daily that my team needs to ingest in order to identify particular events which then drive the output in a report we produce.