Re^2: Win32:OLE errors when running same code on Windows XP

bulk88: sounds quite right. I will try it and report.

Meanwhile, can you explain a couple of questions:

1. What is a tied/magic scalar, and how is it involved here?

2. Why don't I get this "deluge" of OLE exceptions at the original installation on the Windows 7 system?

Many TIA

Helen

Comment on Re^2: Win32:OLE errors when running same code on Windows XP

Replies are listed 'Best First'.
Re^3: Win32:OLE errors when running same code on Windows XP by bulk88 (Priest) on Aug 11, 2012 at 03:52 UTC
Some tiny settings difference in Eclipse I bet. Maybe a "+" is open on 1 machine and not the other. `* - Package Win32::OLE::Tie Implements properties as tied hash` [download] From Win32::OLE. Object methods and properties The object returned by the new() method can be used to invoke methods +or retrieve properties in the same fashion as described in the docume +ntation for the particular OLE class (eg. Microsoft Excel documentati +on describes the object hierarchy along with the properties and metho +ds exposed for OLE access). Optional parameters on method calls can be omitted by using undef as a + placeholder. A better way is to use named arguments, as the order of + optional parameters may change in later versions of the OLE server a +pplication. Named parameters can be specified in a reference to a has +h as the last parameter to a method call. Properties can be retrieved or set using hash syntax, while methods ca +n be invoked with the usual perl method call syntax. The keys and eac +h functions can be used to enumerate an object's properties. Beware t +hat a property is not always writable or even readable (sometimes rai +sing exceptions when read while being undefined). If a method or property returns an embedded OLE object, method and pro +perty access can be chained as shown in the examples below. [download] Your answer is in the quote above. More specifically, a little bit of googling leads to this http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel._application.activechart. I dont know what "Nothing" translates to in Win32::OLE.	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^3: Win32:OLE errors when running same code on Windows XP
by bulk88 (Priest) on Aug 11, 2012 at 03:52 UTC

 * - Package Win32::OLE::Tie        Implements properties as tied hash
[download]

Win32::OLE

Object methods and properties

The object returned by the new() method can be used to invoke methods 
+or retrieve properties in the same fashion as described in the docume
+ntation for the particular OLE class (eg. Microsoft Excel documentati
+on describes the object hierarchy along with the properties and metho
+ds exposed for OLE access).

Optional parameters on method calls can be omitted by using undef as a
+ placeholder. A better way is to use named arguments, as the order of
+ optional parameters may change in later versions of the OLE server a
+pplication. Named parameters can be specified in a reference to a has
+h as the last parameter to a method call.

Properties can be retrieved or set using hash syntax, while methods ca
+n be invoked with the usual perl method call syntax. The keys and eac
+h functions can be used to enumerate an object's properties. Beware t
+hat a property is not always writable or even readable (sometimes rai
+sing exceptions when read while being undefined).

If a method or property returns an embedded OLE object, method and pro
+perty access can be chained as shown in the examples below.
[download]

http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel._application.activechart

[reply]
[d/l]
[select]