Forum Discussion
Microsoft 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...
Not necessarily, can you provide two sample files that differ as you've described. Remove/change any sensitive data.
This will make it easier for us to offer a solution.
Thanks for your quick reply! I don't see a way to attach the files on the forum, can you provide your email?
The attaching is restricted unfortunately.
Just share using Google Drive, Drop Box etc.
Hi 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.