Import Excel Sheet Based on Last Modified

[kobiashi]

hi all

im assuming this is possible, but im still quite new to VBA, but is there any way i can select and import an excel spreadsheet based on last modified date?

Also would there be a way to select worksheets as a pose to the whole workbook?

 

[arnelgp]

it requires VBA.
need FileDialog to show and sort the Excel WB by date.
Open the WB and recurse through each Sheets and present to user which one to import.

 

[Cronk]

If you're only interested in importing the latest date, you'd store the date of the last spreadsheet imported.


Then loop through spreadsheet files looking for the latest after the date of the last one imported.