in reply to Re: Re: Troubles transposing a range in Excel with Win32::OLE
in thread Troubles transposing a range in Excel with Win32::OLE
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.
|
|---|