Hi
I have two excel reports input and there's a column showing the reporting date for each file. So after some processes, I need to export a file with dynamic sheets with the output Options chosen as "Overwrite Sheet (Drop)" and at the bottom "Change Entire File Path" selected. But as observed, say if there's a sheet3 created last time and today there's only actually sheet1 and sheet2 updating, the sheet3 still exists with the old data.
So now I think I need to dynamically name the exported file with a date to the file name and I'd like to concatenate the two dates in the reporting date column and add it to the file name. But now I have no idea of how to do this step. I was trying to find a way to get the max and min value or string from the column, but don't know how.
Anyone can help me on this? Thanks a lot!
Solved! Go to Solution.