代码
twb=ThisWorkbook.Name Workbooks.Open file1 Windows(twb).active'本来是ThisWorkbook.active,但是奇怪的是Thisworkbook值会随着切换窗口改变 dim fst(3) for i=0 to 2 fst(i)=Cells(i+7,2).Value next
执行后一般情况正确,小概率fst会等于file1的cells