恳请老鬼版主看看Excel连接表数据转移问题！

foxxp

cause I found there were some sheets in OLE CALLING，see the code below

...

Debug.Print xlsApp.Workbooks.Count

...

the last one was the OLE OBJECT,others sheets were PERSONAL.XLS , XLA , XLL etc

but they were all unvisible 。

so i thought if this was the reason .

"All Were Unvisible " = "There Were No ActiveSheet" = "There Were No Current Sheet"

so we must gave the absolute reference of the sheet .

but i was puzzled why it was no error in the second try.

thanks.

foxxp

cause I found there were some sheets in OLE CALLING，see the code below

...

Debug.Print xlsApp.Workbooks.Count

...

the last one was the OLE OBJECT,other sheets were PERSONAL.XLS , XLA , XLL etc

but they were all unvisible 。

so i thought if this was the reason .

"All Were Unvisible " = "There Were No ActiveSheet" = "There Were No Current Sheet"

so we must gave the absolute reference of the sheet .

but i was puzzled why it was no error in the second try.

thanks.

大熊

many tks. at least we know how to deal with it now.

foxxp

熊版见笑了.本想用英文和熊兄交流一下,没成想不仅错发了两次,语法还有多个错误.惭愧!

大熊

No.I will often  make mistakes too. But My teacher tell me that making Mistakes is the necessary step to study a foreign language.[em04]