Hello everyone,
I need some help with the macro below. I have everything working properly except the last part which is supposed to combine the saved excel attachments. Instead of combining theses attachments, Excel just opens a blank workbook. It seems like the macro isn't seeing any of the saved attachments. I've looked everywhere online and I can't find a solution. I even tried using Application.FileSearch instead of Dir().
If the screenshot is not helpful or my notes are making it annoying to read through. Let me know and I can copy and paste just the macro.
Any help would be greatly appreciated!
I need some help with the macro below. I have everything working properly except the last part which is supposed to combine the saved excel attachments. Instead of combining theses attachments, Excel just opens a blank workbook. It seems like the macro isn't seeing any of the saved attachments. I've looked everywhere online and I can't find a solution. I even tried using Application.FileSearch instead of Dir().
If the screenshot is not helpful or my notes are making it annoying to read through. Let me know and I can copy and paste just the macro.
Any help would be greatly appreciated!
