Why not mix ‘em? Use `FileSystemObject` for text files and `Workbooks.Open` for Excel.
For vba read file options, there’s no one-size-fits-all. ADO is fast but complex. `Open` is simple but limited.
If you’re feeling fancy, try `GetObject` for Excel files—it’s faster than `Workbooks.Open` sometimes.
For vba read file options, there’s no one-size-fits-all. ADO is fast but complex. `Open` is simple but limited.
If you’re feeling fancy, try `GetObject` for Excel files—it’s faster than `Workbooks.Open` sometimes.
