Export to Snapshot

  • Thread starter Thread starter hlam
  • Start date Start date
H

hlam

I have VBA to export report to snapshot on a designated drive. However the
file is not exported if it is being viewed and there is no message reported
to the user. Is there a way I can test if the snapshot is being viewed
before export?
 
When you say the file is being viewed, do you mean that a previous version
of the SNP file already exists and is being viewed?

If so, try to delete the file first:
Kill "C:\some path\some file.snp"

If the file is open, then it cannot be deleted, and an error will be raised.
 
Back
Top