Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 5th 07, 03:18 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2
Default 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   Report Post  
Old September 6th 07, 02:24 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,355
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create a report and have a search funtion to find data JJ Excel Discussion (Misc queries) 1 September 20th 08 03:34 PM
changing default search location in Excel 2007 Find. David Pedersen Excel Discussion (Misc queries) 3 September 4th 08 04:32 PM
How can I find a report manager add-in for Excel 2007? Dave Kramer Excel Discussion (Misc queries) 1 February 5th 07 03:41 PM
Use Windows 'search' to find Excel files containing 'a word or phr David Excel Worksheet Functions 1 December 15th 06 11:56 AM
How to report Excel 2007 problems? Josh Sale Excel Programming 3 June 5th 06 03:36 AM


All times are GMT +1. The time now is 07:20 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017