By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

expertatexcel.com

 


SetAttr

This command can be useful to set a file to read-only, if you don't want other who edit a file to lock it so you can't change it, it's better to set the file to read-only when you're not processing it.

Why you process the file turn off the read-only and then after you finish turn it back on

SetAttr sfilename,attrbute

where attribute can be
  • vbReadOnly
  • vbNormal
  • vbArchive
  • vbSystem
  • vbHidden
  • vbDirectory

  •