Is it possible to detect (in a access form/VBA) when the user returns from a program called by the Shell command? (e.g. WINWORD.EXE "blablabla.doc" ...) I want to refresh a list of files created in VBA+Access listbox when the user is done using word (saved a .doc/Word file that needs to be displayed in the list). It currently works in the Form_Activate+Form_Open functions. The script clears the list and adds the existing files of a directory (with further specifications already implemented, based on another form that's opened).
It needs to catch the return of the Word application (user giving focus to access). It should then execute the already explained code.