Re: Re: Troubles transposing a range in Excel with Win32::OLE

Problem Solved

Should this be considered a bug in OLE ?
Knowing that c-era could replicate the problem in VB, why was there no refs of this found in google ?
Is Transpose such a rare creature or is it just me ??

Kudos to jmcnamara and c-era!

Thanks²

Comment on Re: Re: Troubles transposing a range in Excel with Win32::OLE

Replies are listed 'Best First'.
Re:(3) Troubles transposing a range in Excel with Win32::OLE by jmcnamara (Monsignor) on Jan 10, 2002 at 19:10 UTC
I don't think that this is a bug. However, it is often hard to match Perl's variable types with those expected by VBA. That is why the Win32::OLE::Variant module is so useful. A good resource for Win32::OLE related information is the ActiveState mailing lists. In particular the perl-win32-users list. Jan Dubois, the author of Win32::OLE, often answers questions there. As an aside, Win32::OLE is an extremely powerful module and potentially very useful. However, it is let down by a lack of comprehensive documentation and examples. -- John.	[reply]

Replies are listed 'Best First'.

Re:(3) Troubles transposing a range in Excel with Win32::OLE
by jmcnamara (Monsignor) on Jan 10, 2002 at 19:10 UTC

However, it is often hard to match Perl's variable types with those expected by VBA. That is why the Win32::OLE::Variant module is so useful.

A good resource for Win32::OLE related information is the ActiveState mailing lists. In particular the perl-win32-users list. Jan Dubois, the author of Win32::OLE, often answers questions there.

As an aside, Win32::OLE is an extremely powerful module and potentially very useful. However, it is let down by a lack of comprehensive documentation and examples.

--
John.

[reply]