VBA: Update Read-Only Workbook

[JennV]

Hello there,

I'm not sure if this is even a possibility... I'm hoping so!

Currently, in wb1, I have a macro that opens wb2 to update data and if wb2 is read-only, it will ExitSub. My concern is, wb2 will be accessed VERY frequently by other users so I’m wondering if I set wb2 as read-only to those users, is there a code that will allow me to still update data from wb1 despite of wb2 being read-only? For example, when I run the macro in wb1, it will temporarily take away the read-only function and then re-add it once I’m done updating it?

Thank you in advance!

 

[ismii]

https://www.mrexcel.com/forum/excel-questions/1006725-vba-saving-read-only-file.html
might be of some help

 

[mshelton23]

You should be able to accomplish what you need by using SetAttr

SetAttr <full workbook name>, vbReadOnly will make the file read only
SetAttr <full workbook name>, vbNormal will give you read/write access