[Sorry for the top post, only got a few seconds to get this in...]
For what it's worth, the Excel 2003 VBA Help offers this clue to the
'UpdateLinks':
UpdateLinks Property
Returns or sets an XlUpdateLink constant indicating a workbook's setting for
updating embedded OLE links.
Read/write.
[Sorry again, left out the most important part]
Const xlUpdateLinksUserSetting = 1
Const xlUpdateLinksNever = 2
Const xlUpdateLinksAlways = 3
-Original Message-
From: Jarvis, John
Sent: Thursday, April 20, 2006 11:03 AM
To: 'Lynn. Rickards'; Suresh Govindachar
Cc:
---8
When I manually open an Excel file, it bring up a dialog box
stating that the workbook contains links to other data sources
and asking if the data should be updated.
---8
Try and see if you can supress the pop up with this:-
$Excel-{DisplayAlerts} = 0;
Hello,
Issue: opening an excel file brings up a dialog box
stating that the workbook contains links to
other data sources and asks if the data
should be updated.
Just-in's suggestion of adding $Excel-{DisplayAlerts} = 0;
to modify the code to be:
---8---
Just-in's other suggestion was If not you may have to fudge
something with Win32::GuiTest, but didn't elaborate on
the something ...
---8---
Going down the GuiTest path is forcing things in a less than elegant
way.
Why not have a dig around in the Object browser
Check Tools--Options--Calculation Tab and try changing the Calculation
radio button to Manual. That might get rid of the message. You just
have to keep in mind that you need to manually recalculate your values
if you want to see the current data.
-Original Message-
From: [EMAIL
Lynn. Rickards Sent: Wednesday, April 19, 2006 6:02 PM
Suresh Govindachar wrote:
Hello,
Issue: opening an excel file brings up a dialog box
stating that the workbook contains links to
other data sources and asks if the data
should be