Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search All Files Find Newest One Report To Excel 2007
Hello All
I am running Excel 2007 I need to create a VBA script that will allow me to select a folder(Team) then the program would walk the tree and find the newest file based on date modified in each folder(Project) (Must search sub folders of each project as well) The goal here is to provide each team with a list of their project and the latest activity on each project to help them decide which projects are ready to be archived off our main server. Team Project1 Project2 Project 3 Return would look like Team Project Newest File Harry Stadium 10/17/2005 Harry Theater 11/25/2006 I'm looking for some Code ideas as well as concepts. I've never been very good at creating efficient algorithms / searches. Each Project may have 10k files. If doing this in Excel 2003 is easier I can do that as well. Thanks Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search All Files Find Newest One Report To Excel 2007
You can browse for a folder using the code here
http://www.cpearson.com/excel/BrowseFolder.aspx You should be able to glean the date using something here http://www.exceltip.com/st/List_file...Excel/446.html I think I'd look at FileItem.DateLastModified for the date and FileItem.Name for the name -- HTH, Barb Reinhardt "Stever" wrote: Hello All I am running Excel 2007 I need to create a VBA script that will allow me to select a folder(Team) then the program would walk the tree and find the newest file based on date modified in each folder(Project) (Must search sub folders of each project as well) The goal here is to provide each team with a list of their project and the latest activity on each project to help them decide which projects are ready to be archived off our main server. Team Project1 Project2 Project 3 Return would look like Team Project Newest File Harry Stadium 10/17/2005 Harry Theater 11/25/2006 I'm looking for some Code ideas as well as concepts. I've never been very good at creating efficient algorithms / searches. Each Project may have 10k files. If doing this in Excel 2003 is easier I can do that as well. Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a report and have a search funtion to find data | Excel Discussion (Misc queries) | |||
changing default search location in Excel 2007 Find. | Excel Discussion (Misc queries) | |||
How can I find a report manager add-in for Excel 2007? | Excel Discussion (Misc queries) | |||
Use Windows 'search' to find Excel files containing 'a word or phr | Excel Worksheet Functions | |||
How to report Excel 2007 problems? | Excel Programming |