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

Become an Σxpert at Σxcel.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

  •