如何使用VBA引用外部指定excel单元格

Workbooks("C:\Documents and Settings\Administrator\桌面\黄石成美自施\K01(总的部分)\K0101第一册\K0101ml.xls").open workbooks(1).sheets("sheet1").cells(1,1).value=Workbooks("K0101ml.xls").sheets("sheet1"