Excel2000: ODBC query from protected Excel file

A

Arvi Laanemets

Hi

Is it possible to force ODBC query
(Data.GetExternalData.NewDatabaseQuery.ExcelFiles) from another (closed)
Excel table to work, when this another table is protected with password
(File.SaveAs.Tools.GeneralOptions.PasswordToOpen). At moment I get 'Could
not decrypt file.' message, and data aren't retrieved, whenever the source
table isn't opened before.
 
Top