Hi,



We have 36 excel files, each excel file consists 9 sheets. The 36 excel
files are copy of the some excel file. In some sheets of excel files may
contain data and some may not contain data.



So in my main excel file I have written a macro which copies the data (my
macro wont copy whole sheet it copies data sheets which is having data in
the cells, if any row not containing any data then that row is not copied)
from all these 36 excel files into a new sheets of new workbook, for this I
have used

Paste special pate: = xlPasteValues etc.

This is working fine but I want to achieve exact functionality with out
using Paste methods, is it possible to do this requirement with out using
paste method? If yes can you tell me how to do this?



Are there any alternative methods?