vba copy column from one workbook to another without opening

[catchsomnath]

Hi,

I want to copy column from workbook "SOURCE" column "D" values to workbook "DESTINATION" column "IN".

Regards,
Somnath

 

[catchsomnath]

yes. thats the master file.

 

[catchsomnath]

hi...

I found this code on the website. This open everyfile and close it. will it be helpful to us

Public Sub test()
'DECLARE AND SET VARIABLES
Application.ScreenUpdating = False


Dim wbk As Workbook
Dim Filename As String
Dim Path As String
Path = "D:\vba\test" 'CHANGE PATH
Filename = Dir(Path & "*.xls")
'--------------------------------------------
'OPEN EXCEL FILES
Do While Len(Filename) > 0 'IF NEXT FILE EXISTS THEN
Set wbk = Workbooks.Open(Path & Filename)



MsgBox Filename & " has opened" 'OPTIONAL- CAN COMMENT OUT
wbk.Close True
Filename = Dir
Loop
End Sub