| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ListObject does not update DataSource when cell value changes | Excel Programming | |||
| Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
| Suppress Update Links dialog AND don't update links | Excel Programming | |||
| programmatically retrieve links from web page | Excel Programming | |||
| Excel 2003 - Update or Don't Update Links Problem | Excel Programming | |||
Linear Mode
