View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default Reading Sheet Names/Index from closed file using Biff8.

keepITcool wrote

Over the weekend I just may try to read a few more
items from the file.(Document Properties etc)


Doing a comparison, I noticed ADO does not expose the worksheet name
as a table if the worksheet is hidden. Defined Names, including
worksheet-level Names, are still exposed and the data can still be
queried as usual using the worksheet name.

Jamie.

--