A couple years ago, I had to write some code that would copy PDFs from one location to another. Unfortunately, if the PDF was open by a user, this would fail.

I got around this problem by first renaming the pdf with something like this:
Name "C:\Test\Test.pdf" as "C:\Test\Delete Me.pdf"
Once the file was renamed, there was no problem copying the latest version across.

Today, I'm trying to do the same thing, but I get Run-time error 75. Renaming works if the PDF is closed. It also works if it is a .txt file that is open or closed.

Any ideas?