''I wanted to retrieve values from multiple cells,that is return a column of data(like B7:B13) from a closed workbook and assign it as a cells value in another sheet.I have done it like the following but it is giving error at the executeexcel4ma cro step.Could somebody tell the reason for this error and any alternative solution.

Thanks in advance

Saptarshi


Sub read()
Dim foldername As String,...