title: How do I know when a file has been modified in a VBA Macro?
body: <p>Is there a way to watch a file in VBA (which is essentially VB6), so that I know when the file has been modified? -- similar to <a href="https://stackoverflow.com/questions/205222/vba-watch-file-in-use">this</a> only I don't want to know when a file is <em>unused</em>, just when its <em>modified</em>.</p>
  
  <p>The answers I've found have recommended using "FileSystemWatcher" and the Win32 API "FindFirstChangeNotification". I can't figure out how to use these though, any idea?</p>