List Search Time & Then List Next Search Results on Next Available Line

**R_S_6** · 03-04-2009, 09:14 AM

I have a macro (can't remember where from, probably the net), that searches within a folder that the user specifies for file types of specified extensions. I have found that by leaving the extension input blank it returns all file types within the designated folder as I require.

What I would like to do is run the macro every say '60' seconds to record file creations within a folder. Therefore I require:

A way of Starting the Macro.
A way to insert two clear columns below the search results.
A timer to rerun the file search 60 seconds after its last search.
List the new files below the 2 clear rows created earlier.
& Repeat.
Finally a stop button or a stop macro after 1hour limit.

The code I mentioned earlier is:

Please Login or Register  to view this content.

If the current date and time that each file was found could be listed in columns B and C respectively it would be great! File names and types should be listed in column A.

I have attached an Example *.xls to show what the outcome should look like.

Hope someone can help,

Cheers
Mark

**R_S_6** · 03-04-2009, 12:43 PM

Okay I have had a play with the code using some code I have found on the forum,

Please Login or Register  to view this content.

It seems to work fine, the only issue is that it repeats the file names over the originals. I need it to list the files, then list the next lot of search results 2 rows down from the end of the first search results, and so on.

Also still not sure about how to get it to also list the dates in column B and Times in Column C for which each file was found.

Any help appreciated!

Cheers