>I use the ShellExecute API to open ‘pattern’ files (i.e. Word-Excel-Autocad-jpg files) whose names and path are stored in a dbf-table.
>The user works with these files and then ‘Save As’ the modified files giving them another name and path. I would like to capture this new path+filename given by the user through the original application (Word-Excel-Autocad-Photoshop, …) so as to be able to store it in another dbf-table.
>Is there a way to call (if exists) an API which can return the last filename written to disk (also a network drive), or is there an alternative way to reach the same result?

It might not be the best but having a robot application which would scan specific directories for new recently added files and then add them as new records in your DBF might be a way to go.