ExcelBanter - Getting readonly & password properties without opening file

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Getting readonly & password properties without opening file (https://www.excelbanter.com/excel-programming/341386-getting-readonly-password-properties-without-opening-file.html)

Eithne R[_2_]

Getting readonly & password properties without opening file

Hi, is there a way to check the following properties of Excel files without
actually opening up the file? I need to call this in batch from a macro

ActiveWorkbook.ReadOnly
ActiveWorkbook.ReadOnlyRecommended

ActiveWorkbook.SaveAs ... Password:="pwd",
ActiveWorkbook.SaveAs ... WriteResPassword:="",

Cheers

All times are GMT +1. The time now is 09:00 AM.