I have a report to run every day but the report is imported from another database into Excel and requires formatting changes. I know how to record a macro to do this but it will only work in the open workbook. How can I record the macro so I can use it every night when I import my data into Excel?