请问怎么实现读取一个文件夹中所有的文件啊,一次读取,包括文件中的子目录里的文件。谢谢了
解决方案 »
- vb 操作EXCE第一次运行可以,第二次运行出错
- 关于类封装的问题,顺便散分!
- 高分,机器名称和Sql服务器名称不同,如何用VB远程连接数据库!
- 求VBA(Excel)代码:打印嵌入Excel工作表中的PDF文件
- 挑战VB高难度(满分)
- 请问如何检测某个端口号是否被占用?希望有代码 大家快快帮忙了!
- 一个关于vb和word的问题,请各位帮忙
- 请问谁有CODE39的字库呀~急急
- 怎么把一个值从一个窗口传递到另一个窗口??
- 超难问题,dataReport中分组中的子集添加序号方法???
- 谁能给VB的MSDN下载地质呢,感激ING,我把所有分都送了!
- 求救! 为什么 我更新记录集的时候 老提示“对象或执行者不能提供所需的操作”
Dim fs As New FileSystemObject ' 建立 FileSystemObject
Dim fd As Folder ' 定义 Folder 对象
Dim sfd As Folder Set fd = fs.GetFolder("c:\")
ListFolder fd
End SubSub ListFolder(fd As Folder)
Dim sfd As Folder
For Each sfd In fd.SubFolders
Debug.Print sfd.Path
List1.AddItem sfd.Path
ListFolder sfd ' 以 sfd 为参数,递归调用
Next
End Sub
Private Declare Function WritePrivateProfileString _
Lib "kernel32" Alias "WritePrivateProfileStringA" _
(ByVal lpApplicationname As String, ByVal _
lpKeyName As Any, ByVal lsString As Any, _
ByVal lplFilename As String) As LongPrivate Declare Function GetPrivateProfileString Lib _
"kernel32" Alias "GetPrivateProfileStringA" _
(ByVal lpApplicationname As String, ByVal _
lpKeyName As String, ByVal lpDefault As _
String, ByVal lpReturnedString As String, _
ByVal nSize As Long, ByVal lpFileName As _
String) As Long'
'读INI文件.
'函数:GetIniStr
'参数:AppName 项目名.In_Key 键名,sFileName 文件名
'返回值:成功:对应的键值.失败或不存在:""
Public Function GetIniStr(ByVal AppName As String, ByVal In_Key As String, ByVal sFileName As String) As String
On Error GoTo GetIniStrErr
If VBA.Trim$(In_Key) = "" Then
GoTo GetIniStrErr
End If Dim GetStr As String
GetStr = VBA.String(128, 0)
GetPrivateProfileString AppName, In_Key, "", GetStr, 256, sFileName
GetStr = VBA.Replace(GetStr, VBA.Chr(0), "")
If GetStr = "" Then
GoTo GetIniStrErr
Else
GetIniStr = GetStr
GetStr = ""
End If
Exit FunctionGetIniStrErr:
Err.Clear
GetIniStr = ""
GetStr = ""
End Function'
'写INI文件.
'函数:WriteIniStr
'参数:AppName 项目名.In_Key 键名,In_Data 键值,sFileName 文件名
'返回值:成功=TRUE.失败=FALSE
Public Function WriteIniStr(ByVal AppName As String, ByVal In_Key As String, ByVal in_data As String, ByVal sFileName As String) As Boolean
On Error GoTo WriteIniStrErr
WriteIniStr = True
If VBA.Trim(in_data) = "" Or VBA.Trim(In_Key) = "" Or VBA.Trim(AppName) = "" Then
GoTo WriteIniStrErr
Else
WritePrivateProfileString AppName, In_Key, in_data, sFileName
End If
Exit Function
WriteIniStrErr:
Err.Clear
WriteIniStr = False
End Function
http://www.yesky.com/20000918/114872.shtml不过,用递归速度是个问题