Is there a better option than Getobject to access a .xls?
Tell me more...
If your file is set up like a database
Do I have to do anything special to do this?
My workbook has a few worksheets with standard columns of numeric numbers.
and you just want to retrieve the data, you can treat an excel file
as a database file and use ADO or DAO.
I have vague memories that ADO is newer than DAO. Correct?
Which is better/faster of the two?
Are they faster than using GetObject, which definately slows my routine
down?
Thanks in advance
Dave F.
|