Most recent file modified in a folder, in a table

[Dan Goldstein <DGoldstein -at- nuot -dot- com>]

I'd like to use either an Excel spreadsheet or a Word table to do the following:

* I create a column that lists certain folder paths:
	* C:\Users\dgoldstein\Documents\Unicorns
	* C:\Users\dgoldstein\Documents\Milkshakes
	* C:\Users\dgoldstein\Documents\ChocolateMilkshakes, etc.
* Excel or Word populates the column next to it with the most recent date that any file in that folder was modified.
* If the macro/field code requires that the folder path not have spaces, etc., I can adjust for that.

TIA,

Dan
(cross-posted to Techshoret)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
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