RE: Most recent file modified in a folder, in a table

Subject: RE: Most recent file modified in a folder, in a table
From: "Weissman, Jessica" <WeissmanJ -at- abacustech -dot- com>
To: Dan Goldstein <DGoldstein -at- nuot -dot- com>, "techwr-l -at- lists -dot- techwr-l -dot- com" <techwr-l -at- lists -dot- techwr-l -dot- com>, Monique Semp <monique -dot- semp -at- earthlink -dot- net>
Date: Wed, 3 Feb 2016 19:14:46 +0000

You could use dirTree to create directory lists on the second page of a workbook, then populate your list on the first page using a combination of the max and hlookup functions.

Alternatively you'd have to write something that iterates through the directory and looks for the most recently edited file. About an hour's work for a journeyman macro writer.

- Jessica
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Visit TechWhirl for the latest on content technology, content strategy and content development | http://techwhirl.com

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-leave -at- lists -dot- techwr-l -dot- com


Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit
http://www.techwhirl.com/email-discussion-groups/ for more resources and info.

Looking for articles on Technical Communications? Head over to our online magazine at http://techwhirl.com

Looking for the archived Techwr-l email discussions? Search our public email archives @ http://techwr-l.com/archives


References:
Most recent file modified in a folder, in a table: From: Dan Goldstein
Re: Most recent file modified in a folder, in a table: From: Monique Semp

Previous by Author: Re: single sourcing to Excel spreadsheets
Next by Author: Re: Pls remind me: batch .fm file update to new Frame template
Previous by Thread: Re: Most recent file modified in a folder, in a table
Next by Thread: RE: Most recent file modified in a folder, in a table


What this post helpful? Share it with friends and colleagues:

Sponsored Ads


Sponsored Ads