View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
davidc davidc is offline
external usenet poster
 
Posts: 1
Default How to "Set alias for worksheet in other excel file"

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?