I currently use scheduler to produce pdf versions of impromptu reports. These are placed on a file server so that users can access them. The users tend to forget to close the pdf reports down when they use them, which prevents my macros from over writing the old version of the report. I used to have an error trap in my macro that published the reports to a different folder, but since I have moved to impromptu 7 on an XP box I get an error dialog saying that the pdf file I am trying to create is locked by another user. This stalls my macro, and all other reports that have been scheduled.
Does anyone know how to either check whether a file is open, or kick a user off the file so that it can be updated?
Does anyone know how to either check whether a file is open, or kick a user off the file so that it can be updated?