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