TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
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
