IgnoreReadOnlyRecommended not working from Python when opening Excel workbook

Question

I have an excel workbook I need to open from python in a writable mode. The workbook is set up to have the prompt for a read only recommendation and this cannot be removed.

I am using the following:

import win32com.client
xl=win32com.client.Dispatch("Excel.Application")
filepath = 'C:\Users\FullFilePath.xlsm'
xl.Workbooks.Open(Filename=filepath, ReadOnly=False, IgnoreReadOnlyRecommended=True)

It opens the file, but it's still popping up the dialog asking if I want to open in read only. Is it possible to cancel that dialog?

Try using `xl = win32com.client.DispatchEx('Excel.Application')`. This works without a dialog box for me. — mechanical_meat, Mar 29 '17 at 18:16

score 0 · Accepted Answer · answered Mar 29 '17 at 18:23

0

Use instead:

xl = win32com.client.DispatchEx('Excel.Application')

This works without a dialog box for me.

answered Mar 29 '17 at 18:23

mechanical_meat

163,903
24
228
223

IgnoreReadOnlyRecommended not working from Python when opening Excel workbook

1 Answers1

Linked