Update datasource links programmatically
 

Greetings,
I am trying to query a closed workbook that has datasource links. Is there a
way to update datasource links programmatically? I can query and return info
from other workbooks without links perfectly but I get Runtime error
-2147467259(80004005) Could not decrypt file, when I try it with one with
links. Ideas?

***
WinXP
Excel 2002-2007