VBA monitor folder for new files
<p>So I'm trying to write a VBA program that will monitor a folder for new files and then do stuff with them. I've found some promising examples on using the WMI api:</p>

<p><a href="https://stackoverflow.com/questions/18242252/receive-notification-of-file-creation-in-vba-without-polling">Receive notification of file creation in VBA without polling</a></p>

<p><a href="http://www.mrexcel.com/forum/excel-questions/211547-monitor-new-files-folder.html" rel="nofollow noreferrer">http://www.mrexcel.com/forum/excel-questions/211547-monitor-new-files-folder.html</a></p>

<p><a href="https://blogs.technet.microsoft.com/heyscriptingguy/2004/10/11/how-can-i-automatically-run-a-script-any-time-a-file-is-added-to-a-folder/" rel="nofollow noreferrer">https://blogs.technet.microsoft.com/heyscriptingguy/2004/10/11/how-can-i-automatically-run-a-script-any-time-a-file-is-added-to-a-folder/</a></p>

<p>But here's the thing: It seems like the tack everyone takes with these examples is to wire the VBA into an Excel spreadsheet as a macro. People treat Excel as a poor-man's programming environment. Fair enough. The problem is, I need this to run when the user is closed out out this magic excel file with the macro. </p>

<p>Something tells me I need to make a full windows application in visual studio with VB6.0 or C# and run the application in the background as some kind of a scheduled task. Is that the right path to take or is there something simple that I'm missing in these Excel/VBA tutorials?</p>

<p>(Apologies for the generality of the question. I know that the community appreciates specific questions.)</p>