Export to Snapshot

[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?

 

[Graham Mandeno]

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.