求助:从Excel中读取多个SHEET

wzwhu

我用"select * from [sheet1$]"可以正确读取,但是有多个SHEET需要读,我试用了



"select * from [sheet1$],[sheet2$]"发现不可读,



有什么方法可以吗?请高手指点!

zbsyy

dim she as worksheet

for each she in thisworkbook.worksheets

....

next

terryd

这是写代码吗？问题不清楚。