Get data from an protect excel workbook.

[Pat]

Hi,

I try to get data from a close and protect excel workbook in word with vba.
Til now, i can get data from a close Excel wordkbook with help from an
ADO.connection. But my question is, is it possible to get data from a
protecet/close Excel workbook and how?

Best regrads,

Pat

 

[Jean-Guy Marcil]

Pat was telling us:
Pat nous racontait que :

Hi,

I try to get data from a close and protect excel workbook in word
with vba. Til now, i can get data from a close Excel wordkbook with
help from an ADO.connection. But my question is, is it possible to
get data from a protecet/close Excel workbook and how?

Wouldn't it be better to ask this an Excel group?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org