View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave F[_4_] Dave F[_4_] is offline
external usenet poster
 
Posts: 4
Default 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.