为什么总是告诉我WorkSheet的Paste方法无效?
tmpWorkBook.Worksheets(1).Select
tmpWorkBook.Worksheets(1).UsedRange.Copy
xlsWorkBook.Worksheets(index).Activate
xlsWorkBook.Worksheets(index).UsedRange.Clear
xlsWorkBook.Worksheets(index).Range("A1").Select
xlsWorkBook.Worksheets(index).Paste