2 Replies Latest reply: Jan 2, 2015 4:40 PM by Massimo Grossi RSS

    Load a file with a constantly changing name

    Nate Schroeder

      We have an automatically generated file that gets stored in a folder dated for the current date each Monday in mm-dd-yy format, let's call it "Report - 12-29-14.xlsx".  It gets stored in a folder with the same date so, "Z:\12-29-14\Report - 12-29-14.xlsx".


      Would it be possible to write a load script that:

      A. Looks for a file always dated for the Monday prior


      B. Will loop through folders & files to find the newest folder and or file with a certain naming format?


      Thanks for your help!