Can Excel VBA extract data from a file without opening it?

I know how to write a code to automatically open the file, extract the data and then close the file. But the opening and closing are still taking too much time.
1 answer 1