Option Explicit
Private Sub Command1_Click()
MsgBox "Número de archivos: " & CountFiles("C:\WINDOWS\system32")
End Sub
Function CountFiles(strDir As String) As Long
Dim strSpec As String
Dim strFile As String
Dim lngNumOfFiles As Long
If strDir <> "" Then
strSpec = strDir + "\*.*"
strFile = Dir(strSpec, vbSystem + vbHidden + vbReadOnly + vbArchive)
lngNumOfFiles = 1
Do While strFile <> ""
strFile = Dir
lngNumOfFiles = lngNumOfFiles + 1
Loop
CountFiles = lngNumOfFiles - 1
End If
End Function