Macro won't open excel files in specified directory. HELP!

[ShawnTMc]

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!

 

[Anthony47]

For sure this line need to be amended as follows:

Set XclCurWB=XclApp.Workbooks.Open(TempFolder & "\" & TempFolderFile)

Try...