Copy data from diff workbooks but without opening sheets
 

i want to copy data from different workbooks(s1,s2) to s3
but without opening the worksheets(s1,s2)..
if the sheets r opened ,it works fine..
if not,it says "error"-subscription out of range..

kindly help me

Copy data from diff workbooks but without opening sheets
 

http://www.ozgrid.com/VBA/ExtractFromClosedWorkbook.htm

"raja" wrote:

i want to copy data from different workbooks(s1,s2) to s3
but without opening the worksheets(s1,s2)..
if the sheets r opened ,it works fine..
if not,it says "error"-subscription out of range..

kindly help me