read vs write file

[Alberto Ast]

If I open a file with macros... it could had been opened as read only or as
read/write....

Then how do I check with a macro if it was opened as read only or as
read/write?

 

[Peter T]

bReadOnly = wb.ReadOnly

where wb refers to the workbook you want to know about

Regards,
Peter T

 

[Alberto Ast]

Will the statement read as follows?

if wb.ReadOnly then
wb.Close False
else
wb.Close True
end if

 

[Jacob Skaria]

Yes..provided you have the wb object...

Dim wb as workbook
Set wb = ActiveWorkbook

If this post helps click Yes