VBA code to run CMD code

[NIPUL JARIWALA]

Hello friends,
I am using Excel 2007


I want the vba code to open CMD and run the following code and close CMD.

CMD code: attrib "d:\test.txt" +s +h +r



Please help

 

[Haluk]

Try this, without being the CMD window visible;

Shell ("attrib d:\test.txt +s +h +r")

 

[ZVI]

The same action but without need of CMD

Sub FileAttribute()
  SetAttr "C:\test.txt", vbSystem + vbHidden + vbReadOnly
End Sub