copy data cell from another file in excel
 

Dear Expert,


I am just beginning on vb programming. Could you please help to solve my
problem.
I want to make small program on excel ( file name sample.xls), this program
can :
1. transfer or copy from another excel file to sample.xls.
2. The copy its self for example start from cell C6 until empty data ( for
example on cell C100 data was empty and program stop to copy)

Please advice me.

Regards
novan