orkbook."
End Select
End Sub
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Lynn. Rickards
Sent: Wednesday, April 19, 2006 6:02 PM
To: Suresh Govindachar
Cc: perl-win32-users@listserv.ActiveState.com
Subject: Re: Opening an Excel workbook with links
in32-users@listserv.ActiveState.com
Subject: RE: Opening an Excel workbook with links to other data sources
[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
Return
> 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
>>
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 updated.
Just-in's suggestion of adding "$Excel->{DisplayAlerts} = 0;"
to
ustin Devanandan; perl-win32-users@listserv.ActiveState.com
Subject: RE: Opening an Excel workbook with links to other data sources
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
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Allegakoen, Justin Devanandan
Sent: Wednesday, April 19, 2006 3:59 PM
To: perl-win32-users@listserv.ActiveState.com
Subject: RE: Opening an Excel workbook with links to other data sources
---8<---
Just-in's other suggestion w
---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 br
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<
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} =
Hello,
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. The following perl code
brings up a similar dialog box:
use Win32::OLE qw(in with);
use Win32::OLE::
10 matches
Mail list logo
