?
Solved

Read-only - all files and folder in a folder

Posted on 2002-06-28
7
Medium Priority
?
198 Views
Last Modified: 2012-05-04
Hi experts,

suppose i want to make all files in a folder read-only (or the other way around not-read-only), how can i do this with code?
There can be several levels of folders with files in them.

thanx
ExpertNot
0
Comment
Question by:ExpertNot
7 Comments
 
LVL 4

Expert Comment

by:kpkp
ID: 7116519
You need to write a recursive function.  

The function accepts a folder name as a parameter.  Then finds all the files and folders in that folder.  Updates the attributes of all the files found, and then the functions calls itself for each folder found, passing in the name of one of the folders found.

some _pseudo_ code:

function UpdateReadonlyFlag(string folderName)
{
  itemArray[] = GetListOfFilesAndFolders(folderName);
  for n = 1 to numberOfItemsFound
  {
     if itemArray[n] is a file
         then UpdateReadOnlyFlag(itemArray[n])
     else
     if itemArray[n] is a directory
         then UpdateReadonlyFlag(itemArray[n])
  }
}
0
 
LVL 5

Accepted Solution

by:
rpai earned 800 total points
ID: 7116530
0
 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 7116533
To get the list:
http://www.mvps.org/vbnet/code/fileapi/recursive.htm

To change atributtes for a file use intrinsic SetAttr function
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 7116536
rpai, you beat me!
0
 
LVL 28

Expert Comment

by:vinnyd79
ID: 7116567
Not the greatest way,but you could use:

Private Sub Command1_Click()
Shell "command.com /c attrib +r D:\Test\*.* /s", vbHide
End Sub

change the +r to -r to remove the read only attribute.
The /s will change attributes on files in sub directories
0
 
LVL 26

Expert Comment

by:EDDYKT
ID: 7116729


Public Sub FileAttribute(FileName)
    Dim fso
    Dim folder
    Dim f
    Dim Files
    Dim File
    Dim SubFolders
    Dim SubFolder
   
    On Error Resume Next
    If (Dir$(FileName, vbDirectory) = "") Then Exit Sub
    Set fso = CreateObject("Scripting.FileSystemObject")
    Set folder = fso.GetFolder(FileName)
   
    Set SubFolders = folder.SubFolders
    If SubFolders.Count <> 0 Then
        For Each SubFolder In SubFolders
            FileAttribute (SubFolder)
        Next
    End If
   
    Set Files = folder.Files
    If Files.Count <> 0 Then
        For Each File In Files
            Set f = fso.GetFile(File)
            f.Attributes = f.Attributes or 1
            Set f = Nothing
        Next
    End If
End Sub


To call:

FileAttribute("c:\winnt")

0
 

Author Comment

by:ExpertNot
ID: 7133643
sorry this took so long,
had the flu.

thanx
ExpertNot
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question