Excel Macros in a workbook that gets generated each month
Posted on 2014-11-12
What's the best way to handle this situation? A user has data that is exported to Excel each month from another system - the data changes each time. He created a macro that he wants to run on the data each month. Is it better to have a shell workbook (blank) containing only the macro and copy/paste the data into this workbook, or is it better to copy/paste the macro into the workbook already containing the data, which will be different each time the report is run? Or is there even a better way to handle this? Just looking for some suggestions. Thanks.