Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


scanning Files On C Drive

Posted on 2003-03-24
Medium Priority
Last Modified: 2010-04-07
hi There,

I need to scan drive C and store my files location in a DB. (something like dir /s)
but i can't run the dir function 2 times together, i'm getting an error.

Private Sub Form_Load()

Dim A As String
Dim B As String

A = Dir("C:\2\", vbDirectory)
Do While A <> ""

If A <> "." And A <> ".." Then

    B = Dir("C:\2\" & A, vbDirectory)
        Do While B <> ""
        If B <> "." And B <> ".." Then
            MsgBox B
        End If
        B = Dir()   ' Get next entry.
End If
A = Dir()

End Sub

After scanning the location of B and return to "A = Dir()" I'm geting the error.

What can I do ? I need to scan all the way down to the lowest directory, get the file's name and go up one level to next directory.

Dir() function can't handel it.

Any alternative ?


Question by:computech1

Expert Comment

ID: 8195729
Do you want to use Dir?
Then Balena did it this way (else, you could use FileSystemObject):
GetAllFiles - Search files in a directory or directory tree
Date: 11/18/2000
Versions: VB6 VBS Level: Intermediate
Author: The VB2TheMax Team

' Returns a collection with the names of all the files
' that match a file specification
' The file specification can include wildcards; multiple
' specifications can be provided, using a semicolon-delimited
' list, as in "*.tmp;*.bat"
' If RECURSEDIR is True the search is extended to all subdirectories
' It raises no error if path is invalid

Function GetAllFiles(ByVal path As String, ByVal filespec As String, _
    Optional RecurseDirs As Boolean) As Collection
    Dim spec As Variant
    Dim file As Variant
    Dim subdir As Variant
    Dim subdirs As New Collection
    Dim specs() As String
    ' initialize the result
    Set GetAllFiles = New Collection
    ' ensure that path has a trailing backslash
    If Right$(path, 1) <> "\" Then path = path & "\"
    ' get the list of provided file specifications
    specs() = Split(filespec, ";")
    ' this is necessary to ignore duplicates in result
    ' caused by overlapping file specifications
    On Error Resume Next
    ' at each iteration search for a different filespec
    For Each spec In specs
        ' start the search
        file = Dir$(path & spec)
        Do While Len(file)
            ' we've found a new file
            file = path & file
            GetAllFiles.Add file, file
            ' get ready for the next iteration
            file = Dir$
    ' first, build the list of subdirectories to be searched
    If RecurseDirs Then
        ' get the collection of subdirectories
        ' start the search
        file = Dir$(path & "*.*", vbDirectory)
        Do While Len(file)
            ' we've found a new directory
            If file = "." Or file = ".." Then
                ' exclude the "." and ".." entries
            ElseIf (GetAttr(path & file) And vbDirectory) = 0 Then
                ' ignore regular files
                ' this is a directory, include the path in the collection
                file = path & file
                subdirs.Add file, file
            End If
            ' get next directory
            file = Dir$
        ' parse each subdirectory
        For Each subdir In subdirs
            ' use GetAllFiles recursively
            For Each file In GetAllFiles(subdir, filespec, True)
                GetAllFiles.Add file, file
    End If
End Function


Expert Comment

ID: 8195769
LVL 22

Expert Comment

ID: 8196832
>scan drive C and store my files location in a DB. (something like dir /s)
Why not just use the dir/s ? :

shell(environ("comspec") & " /c dir c: /s /b > c:\AllFiles.txt")

then when done, just open the file ("c:\AllFiles.txt") and move each line into the database as needed.

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 8201796
Cimperiali's code is great but with one problem.

collection object can store only 256 items, I need to scan a full drive (much more then 256 files .... )



Accepted Solution

Cimperiali earned 200 total points
ID: 8201866
Then you can use filesystem object...
Private Sub CmdSearch_Click()
Dim theFolder As Scripting.Folder
Screen.MousePointer = vbHourglass
'use filesystem object:
be sure you reference the "Scripting runtime" libraries
'(menu->project->references-> "Microsoft Scripting runtime"
Private Fso As Scripting.FileSystemObject
Dim theAttributes As Integer
Dim blnStop As Boolean
Const IamLooking As String = "Currently looking: "
'A comandbutton to stop search
Private Sub CmdStop_Click()
  blnStop = True
End Sub

'A commandButton to start search
Private Sub CmdSearch_Click()
blnStop = False
Set Fso = New Scripting.FileSystemObject

Set theFolder = Fso.GetFolder("C:\")
Call searchFiles(theFolder)
'free resources
Set Fso = Nothing
'a label to display info
lblInfo.Caption = IamLooking
Screen.MousePointer = vbDefault
End Sub
'Search files and add them to a listBox
Private Sub searchFiles(theFolder As Scripting.Folder)
 On error resume next 'there are some floders and files you cannot heven search for...
 'list all files
 Dim theFile As Scripting.File
 For Each theFile In theFolder.Files
   if err.number=0 then
      lblInfo.Caption = IamLooking & theFile.Path
      DoEvents 'To avoid program hang
      If blnStop Then Exit Sub
      'add this one
      List1.AddItem theFile.Name & " in: " & theFile.Path
       'do nothing, but try with next file
    end if
 'search in subfolders
 Dim theSubfolder As Scripting.Folder
 For Each theSubfolder In theFolder.SubFolders
   If blnStop Then Exit Sub
   'recursive call
   if err.number=0 then
      Call searchFiles(theSubfolder)
      'Do nothing but try with next folder
   end if
 'not need to set objects to nothing....!
End Sub

Author Comment

ID: 8209556
Great Code !! thanks.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

571 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