'VBA Code to copy specified cells from all the files in a folder
Option Explicit
Dim objFso As Object, pathname As String, eachfile, objFolder As Object, wb As Workbook
Sub getDatafromAnotherfile()
Set objFso = New Scripting.FileSystemObject
Set wb = ThisWorkbook
pathname = "C:\Users\AJS-Client\Desktop\Check\GMU-Dubai21.12.2013"
Set objFolder = objFso.GetFolder(pathname)
For Each eachfile In objFolder.Files
MsgBox objFso.GetExtensionName(eachfile)
If objFso.GetExtensionName(eachfile) = "xls" Then
Call Openfile(eachfile)
End If
Next
Set wb = Nothing
End Sub
Public Sub Openfile(eachfile)
Workbooks.Open eachfile
ActiveWorkbook.Sheets(1).Range("A2:C2").Copy wb.Sheets(1).Range("A2")
ActiveWorkbook.Close
End Sub
Option Explicit
Dim objFso As Object, pathname As String, eachfile, objFolder As Object, wb As Workbook
Sub getDatafromAnotherfile()
Set objFso = New Scripting.FileSystemObject
Set wb = ThisWorkbook
pathname = "C:\Users\AJS-Client\Desktop\Check\GMU-Dubai21.12.2013"
Set objFolder = objFso.GetFolder(pathname)
For Each eachfile In objFolder.Files
MsgBox objFso.GetExtensionName(eachfile)
If objFso.GetExtensionName(eachfile) = "xls" Then
Call Openfile(eachfile)
End If
Next
Set wb = Nothing
End Sub
Public Sub Openfile(eachfile)
Workbooks.Open eachfile
ActiveWorkbook.Sheets(1).Range("A2:C2").Copy wb.Sheets(1).Range("A2")
ActiveWorkbook.Close
End Sub
No comments:
Post a Comment