Win32::OLE.pm and Hyperlinks

From: -b (docuswear_at_yahoo.com)
Date: 07/22/04


Date: 22 Jul 2004 12:09:16 -0700

I am using Perl and OLE.pm to read and modify an Excel spread***.

I can read the hyperlinked value of a cell using the following code:

        my $cellObject = $work***->Range("A2");
        my $hyperlink = $cellObject->Hyperlinks(1)->Address;

Can anyone explain how to modify the value of an Excel cell's
hyperlink, or to add one to a cell if it has no hyperlink?

-docuSwear