Thread: Getting readonly & password properties without opening file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eithne R[_2_] Eithne R[_2_] is offline
external usenet poster
  
Posts: 2
Default 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
Reply With QuoteReply With Quote