+ Reply to Thread
Results 1 to 2 of 2

Renaming open PDF files

  1. #1
    Valued Forum Contributor
    Join Date
    11-26-2012
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    422

    Renaming open PDF files

    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:
    Please Login or Register  to view this content.
    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?

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Renaming open PDF files

    Depends what program you are "opening" with
    if i open txt file with notepad/wordpad i can rename while its open
    however if i open the file with msword, it wont let me rename it

    i can open PDF file in internet explorer and rename the pdf
    however if i open with adobe i cannot rename it

    dont know the "official" reasoning for it

    however i can copy pdf when its open in adobe so dont know why your original doesnt work?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. macro to open files and copy specific sheet into new workbook (have open files part)
    By dangerdavedsp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2015, 02:23 PM
  2. [SOLVED] Renaming files using VBA
    By AdamParker in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-14-2012, 08:28 AM
  3. [SOLVED] Open all files in a SharePoint folder (Problem: Files open out of order)
    By holmstarrunner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2012, 10:13 AM
  4. Renaming Files
    By scottmik in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-10-2010, 07:40 PM
  5. Renaming files?
    By DarkSoul in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-22-2009, 11:11 PM
  6. [SOLVED] Renaming files
    By Gordon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2006, 06:45 AM
  7. [SOLVED] Renaming Files
    By Bear in forum Excel General
    Replies: 2
    Last Post: 12-05-2005, 05:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1