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.
--
|