all files are located same place
vba is placed in a seperate file sample1.xlsm
copy all the data from column A TO COLUMN H complete data from sample2.xls and paste it to sample3.xlsb in same columns
save and close the sample2.xls and sample3.xlsb
i need to do the same by vba so plz help me in slving this problem sir