Results 1 to 5 of 5

Thread: Word Macro opens excel as Read only even though ReadOnly:=False

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Apr 2018
    Location
    MUMBAI
    Posts
    13
    Location
    Hey Thanks,
    well that could be the most possible reason, but the subsequent code has closure of excel workbook and excel application quit as well.

    Quote Originally Posted by macropod View Post
    Most likely you already had the workbook open. Your code now won't work if Excel isn't running.

  2. #2
    VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,273
    Location
    Quote Originally Posted by nkpan View Post
    well that could be the most possible reason, but the subsequent code has closure of excel workbook and excel application quit as well.
    The fact you can subsequently close the workbook and quit Excel is irrelevant. When you start a new Excel session, as 'Set Xl = New Excel.Application' does, that new session can only update workbooks it opens; if the workbook was already open, the new session can only open it in read-only mode..
    Last edited by macropod; 08-23-2018 at 04:53 PM.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Posting Permissions

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