Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Nov 2009
    Location
    Surrey, UK
    Posts
    17
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Windows 2010 autoexec macro open file will only open read only

    I have been using an autoexec macro for over a decade. One of the things it does is open a ToDo file.

    Some time ago - perhaps when we upgraded to Word 2010 - the ToDo file started opening as read only.

    I've tried using:

    Documents.Open FileName:="\\fileset01\peter.english\To_Do.docx"

    And also using:

    Documents.Open FileName:="\\fileset01\peter.english\To_Do.docx" ConfirmConversions:=False, ReadOnly _
    :=False, AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate _
    :="", Revert:=False, WritePasswordDocument:="", WritePasswordTemplate:="" _
    , Format:=wdOpenFormatAuto

    but whichever I've tried, the file always opens as read only, and I can't work out why.

    Any ideas?

  2. #2
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,077
    Thanks
    0
    Thanked 259 Times in 248 Posts
    Quote Originally Posted by pmbework View Post
    I have been using an autoexec macro for over a decade. One of the things it does is open a ToDo file.

    Some time ago - perhaps when we upgraded to Word 2010 - the ToDo file started opening as read only.

    I've tried using:

    Documents.Open FileName:="\\fileset01\peter.english\To_Do.docx"

    And also using:

    Documents.Open FileName:="\\fileset01\peter.english\To_Do.docx" ConfirmConversions:=False, ReadOnly _
    :=False, AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate _
    :="", Revert:=False, WritePasswordDocument:="", WritePasswordTemplate:="" _
    , Format:=wdOpenFormatAuto

    but whichever I've tried, the file always opens as read only, and I can't work out why.

    Any ideas?
    Your Subject line and question are in conflict, there is no Windows 2010. Office 2010 has version 14 for the applications in the suite, i.e. Word is version 14. Office 2016 is the first time Microsoft has the applications version numbers the same as the suite number, 16 and 2016.

    I've seen problems with Office files having the default of Read-only when they came from the Internet, in E-Mail, Network storage and even from External drives attached to the computer but usually get a yellow bar to click to allow Editing. All files on a CD-R or DVD+R/DVD-R are stored as Read-only but usually has that attribute removed by Windows/File Explorer/Windows Explorer when copied to an HDD.

  3. #3
    Star Lounger Graham Mayor's Avatar
    Join Date
    Mar 2016
    Location
    Cyprus
    Posts
    68
    Thanks
    0
    Thanked 24 Times in 24 Posts
    Check that there is no orphan lock file associated with your document, in the folder containing the file (check your other documents and templates folders while you are about it) - see http://www.gmayor.com/what_to_do_when_word_crashes.htm
    Graham Mayor - Word MVP
    http://www.gmayor.com

  4. #4
    New Lounger
    Join Date
    Nov 2009
    Location
    Surrey, UK
    Posts
    17
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Sorry, I meant Office/Word 2010.

    This will have been a file converted from a previous version of Word.

  5. #5
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    Delaware, US
    Posts
    1,169
    Thanks
    19
    Thanked 99 Times in 88 Posts
    Are the files stored in a OneDrive directory by any chance? People, myself included, have run into issues where files stored on OneDrive open as read only.
    Graham Smith
    DataSmith, Delaware
    "For every expert there is an equal and opposite expert.", Arthur C. Clarke (1917 - 2008)

  6. #6
    New Lounger
    Join Date
    Nov 2009
    Location
    Surrey, UK
    Posts
    17
    Thanks
    4
    Thanked 0 Times in 0 Posts
    No, not stored in a OneDrive directory.

    I'm stumped!

  7. #7
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Check whether the files have the read-only attribute set in Windows (not Word) as part of the file's properties.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  8. The Following User Says Thank You to macropod For This Useful Post:

    pmbework (2016-08-25)

  9. #8
    New Lounger
    Join Date
    Nov 2009
    Location
    Surrey, UK
    Posts
    17
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Thanks for the suggestion.

    I had tried that. Didn't work. Still stumped!

  10. #9
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts
    If you open the file without using a macro do you get the same result?
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Tags for this Thread

Posting Permissions

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