I have many Excel files that are used by many users.
The problem I have is that after these files are opened by the users, they always tend to forget closing them.
When my VB program needs to update these files, I am unable to do it since I can only have read-only access. And the agony is that it is done after office-hours and I cannot get the files closed.
I would like to have a program run in the computers of the users that will automatically check for any of these opened files.
But I am not sure how I can get this done as all the various methods that I know of cannot help me. I tried the GetObject but if there is more than one Excel open, it seems only able to read one. I am able to get the handle of the Excel window containing the file but do not how to use it to help me go through the opened Excel files in that window and how to close only one file instead of the whole window.
I hope there's someone who can enlighten me on this issue.
Thank you.
