把 "ABC.xlsx"改为:thisworkbook.sheets("3").range("Z1") & ".xlsx"
activeworkbook.sheets(1).name=actveworkbook.sheets(3).range("Z1")