What Are the Best VBA Read File Options for Efficient Data Handling? Alternatively: Which VBA Read Fi

14 Replies, 1759 Views

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.

Messages In This Thread



Users browsing this thread: 1 Guest(s)