Hi
You can do a query if it is reading and the file is closed. You cannot
change the excel file without opening it though. The memory leak thing
might only happen if you don't release objects in the code (e. Set
myworkbook = Nothing) when you are done. It has nothing to do with
opening the file.
regards
Paul