Good afternoon,
I need to automate a process. Every quarter, I need to import a bunch of Excel templates (they all contain 1 worksheet and are identical , only a few data cells change values) for each of my staff.
I was wondering if a macro can do the importing into the active workbook.
Let's say that an employee sends me 8 of those templates, I can store them in the same folder and get this code to import those 8 worksheets into my active workbook.
Any clues that can guide me?
I need to automate a process. Every quarter, I need to import a bunch of Excel templates (they all contain 1 worksheet and are identical , only a few data cells change values) for each of my staff.
I was wondering if a macro can do the importing into the active workbook.
Let's say that an employee sends me 8 of those templates, I can store them in the same folder and get this code to import those 8 worksheets into my active workbook.
Any clues that can guide me?