修改VBA代码 Set fo = CreateObject("Scripting.FileSystemObject"),增加限制调键位*.CSV格式
时间: 2023-12-14 13:39:24 浏览: 24
您可以使用FileSystemObject的GetExtensionName方法来获取文件的扩展名,然后再判断是否为CSV格式。以下是修改后的VBA代码示例:
```
Sub ProcessCSVFiles()
Dim fo As Object
Dim folder As Object
Dim file As Object
Dim fileName As String
Set fo = CreateObject("Scripting.FileSystemObject")
Set folder = fo.GetFolder("C:\YourFolderPath\") '替换成您要处理的文件夹路径
For Each file In folder.Files
fileName = file.Name
If LCase(fo.GetExtensionName(fileName)) = "csv" Then '判断文件扩展名是否为CSV格式
'处理CSV文件的代码
'...
Debug.Print fileName & " has been processed."
End If
Next file
Set file = Nothing
Set folder = Nothing
Set fo = Nothing
End Sub
```
在上面的代码中,我们使用了LCase函数将文件扩展名转换为小写字母,以便与“csv”进行比较。请将“C:\YourFolderPath\”替换为要处理的文件夹路径。