Forum Discussion
Soc3
Helper I
Helper IMicrosoft Exchange - Excel files with multiple tabs
I'm using Microsoft Exchange to insert attachments from emails that come monthly. Within the attachment, there are multiple tabs. I need to filter to the specific tab I want to be combined each month...
KNP
Super User
Super UserHi Soc3,
Have a look at the attached PBIX file.
First thing, change the pFileDirectory parameter to wherever you have the files stored locally. (This can be altered later obviously if they aren't going to be local files)
I made some assumptions.
- That you wanted the sheets in the workbooks named 'January Usage Report', 'February Usage Report' etc.
- You weren't interested in the other sheets.
- That each workbook will only have one sheet with 'Usage Report' in the name. If it doesn't, the function I built will only pickup the first one.
This should be a good starting point, let me know if you have questions.
