My "process" macro cycles through a folder and opens each workbook and does
stuff to it. When it is finished, it closes the workbook and moves it to a
"completed" folder.

The workbooks are sent to this folder by our cost centers with another
macro. During month-end, the volume of worbooks submitted by the cost
centers increases significantly.

I've noticed the "process" macro only processes workbooks submitted prior to
starting this macro. Any workbook submitted by the cost centers after the
macro has started (and is running) does not get processed. I have to
re-start the "process" macro and cycle through the folder again to get the
"new" workbooks processed.

Is it possible to programmatically "refresh" the folder each time a workbook
is processed so any "new" workbook submitted while the macro is running is
processed?

Thanks for the help.
--
JT