none
ExcelApplication.Workbooks.Count is showing zero even when I have a document open RRS feed

  • Question

  • ExcelApplication.Workbooks.Count is showing zero even when I have a document open. 

    ExcelApplication.Workbooks.Count shows count = 1 when the document opened is not in protected view. But when the opened document is protected view the ExcelApplication.Workbooks.Count shows 0.

    Why the workbook count is zero in case of protected view excel?

    Friday, October 18, 2019 8:03 PM