VBA code for converting excel files to *.xls format in a folder
Option Explicit
Dim pathname As String, fso As New Scripting.FileSystemObject, folder, fl As Object
Sub renameFiles()
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "Select folder"
If .Show = True Then
pathname = .SelectedItems(1)
Else
MsgBox "Folder not selected"
End If
End With
Set folder = fso.GetFolder(pathname)
For Each fl In folder.Files
If fso.GetExtensionName(pathname & "\" & fl.Name) Like "xl*" Then
fl.Name = "Somu.xls"
End If
Next
Set folder = Nothing
Set fso = Nothing
End Sub
https://drive.google.com/file/d/0B23eJ2xd9ODyc21jdXpkaUtLVUk/edit?usp=sharing
Option Explicit
Dim pathname As String, fso As New Scripting.FileSystemObject, folder, fl As Object
Sub renameFiles()
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "Select folder"
If .Show = True Then
pathname = .SelectedItems(1)
Else
MsgBox "Folder not selected"
End If
End With
Set folder = fso.GetFolder(pathname)
For Each fl In folder.Files
If fso.GetExtensionName(pathname & "\" & fl.Name) Like "xl*" Then
fl.Name = "Somu.xls"
End If
Next
Set folder = Nothing
Set fso = Nothing
End Sub
https://drive.google.com/file/d/0B23eJ2xd9ODyc21jdXpkaUtLVUk/edit?usp=sharing
No comments:
Post a Comment