I have 2 different folders, each of them usually with the same Excel files inside it. However, depending on the folder where the Excel files are saved I need to perform different actions like formating cells to copy them to an Outlook eMail.
My question is regarding to what is the best logical approach you can suggest for this sort of task?
I mean, doesn’t make sense to have an Excel application scope to each file so… maybe a For each with an Excel application scope where the workbook path would change? Basically, what’s the suggested approach for anyone who faced that already?