以下两句代码,区别就是选择的excel区域,第一句就可以顺利运行,第二句就报错说找不到对象,请问是什么原因呢?谢谢。
第一句:SQL = "select * from [" & ThisWorkbook.Path & "\" & ThisWorkbook.Name & "].[Order$A1:B118]"
第二句:SQL = "select * from [" & ThisWorkbook.Path & "\" & ThisWorkbook.Name & "].[Order$A78901:B79018]"
http://www.360doc.com/content/18/0809/22/57425815_777085609.shtml