Update datasource links programmatically

J

Jeff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error 2147467259 (80004005) method return address of object envelope failed 2
Error code - Could not decrypt file 5
Ignoring a runtime error 1
Update Protected Links 5
Pivot tables not refreshing after data source update 1
Exporting data with vba from Excel to an Access 2007 db with password 8
Cannot update links to Excel anymore 0
Finding worksheets with Broken Links to other workbooks 2

Top