set ws1 = worksheet("sheet1")
this is used to set alias for the local worksheet
But how to set alias for worksheet located in other excel
file?

Hi
one way:
...
Dim wbk as workbook
Dim wks as worksheet
set wbk = workbooks("other workbook.xls")
set wks = wbk.worksheets("sheet1")
....

--
Regards
Frank Kabel
Frankfurt, Germany

davidc wrote:
set ws1 = worksheet("sheet1")
this is used to set alias for the local worksheet
But how to set alias for worksheet located in other excel
file?