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 decade agoFavorite Answer
It should not take more than a fraction of a second to open a simple file, get a bit of data from it, and then close the file.
But since you did not say what version of MS-Excel you are using, nor what file type that you are accessing, nor what kind of data (nor how much), there is no way to figure out if there is some problem with your current coding.
And the only way to get data from a file is to be able to read that file, and one must open the file before it can be read from.
If you wish to give sufficient information, then I will do my best to assist you.