I have trouble by importing data table from ohter exel file, that is located in the server.
It is really anoing that the exel will open the source file! Tested the methods in exel 2007 and there it works!

Even if i use Microsoft querry wizard and ODBC, it even then open it!

I solved it by use a VBA code

Please Login or Register  to view this content.

My question is, is it a bug or what is the reason why exel open the data source file?

Best Regards