LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
haven104
 
Posts: n/a
Default Periodically listing files in a folder


Hi

I have a folder containing photos which are updated on a daily basis
(added to,replaced and removed.) I'm trying to set up a tracking
system to monitor the folder contents.

Can anyone point me in the right direction to listing the contents of a
folder using VBA?

Ideally I'd like to have the code associted with a button which updates
the file listing completely within excel.

I currently generate a txt file from a dos prompt, link to this and
update whenever neccesary.

Cheers
Tom


--
haven104
------------------------------------------------------------------------
haven104's Profile: http://www.excelforum.com/member.php...o&userid=30254
View this thread: http://www.excelforum.com/showthread...hreadid=499610

 
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
Unable to load files from alternate startup folder Bill.Carlson Excel Discussion (Misc queries) 3 November 24th 05 03:36 PM
finding all empty excel files in a folder. jackm1 Excel Discussion (Misc queries) 4 July 20th 05 11:23 PM
Export html page to Excel - support files folder Export html page to Excel - support file Excel Discussion (Misc queries) 1 June 24th 05 12:36 PM
Files and folder library Shayne Excel Discussion (Misc queries) 3 February 20th 05 03:05 PM
Copy files from spreadsheet into folder Intotao Excel Discussion (Misc queries) 3 January 27th 05 11:38 PM


All times are GMT +1. The time now is 12:00 AM.

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

About Us

"It's about Microsoft Excel"