bfreescott
Board Regular
- Joined
- Aug 6, 2015
- Messages
- 115
Hello ADO experts!
I love using ADO to query Excel files because I can forgo Workbook.Open to access the data in the workbook. Much faster execution.
The seemingly major flaw in the ADO design is that you must refer to the sheet name explicitly.
If I don't know the sheet name, what do I do? I've been getting around it by using named ranges since you don't need a sheet name then, but I don't have the named ranges created for the workbooks I want to query in this case. There must be a better way.
I love using ADO to query Excel files because I can forgo Workbook.Open to access the data in the workbook. Much faster execution.
The seemingly major flaw in the ADO design is that you must refer to the sheet name explicitly.
If I don't know the sheet name, what do I do? I've been getting around it by using named ranges since you don't need a sheet name then, but I don't have the named ranges created for the workbooks I want to query in this case. There must be a better way.
