Mark Wood-Patrick wrote:
> I have some code which needs to set hyperlinks in an Excel document
> and I want the text displayed to be different from the actual link
> address.
>
> The following code works just fine for me:
>
> $worksheet->Hyperlinks->Add({ Anchor =>
> $worksheet->Cells($row, $col),
> Address
> => "http://bugs/$bugID <http://nvbugs/$bugID>",
> });
>
> $worksheet->Cells($row, $col)->{Value} = $bugID;
>
> But if I do:
>
> $worksheet->Hyperlinks->Add({ Anchor => $worksheet->Cells($row,
> $col),
> Address =>
> "http://nvbugs/$bugID";,
>
> TextToDisplay =>
> $bugID,
>
> });
>
>
> I get:
>
> OLE Error Win32::OLE(0.1709) error 0x80070057: "The parameter is
> incorrect"
>
> in METHOD/PROPERTYGET "Add" ....
>
> but it did do what I wanted (the link was added correctly)
>
> anyone know why I get the error message, or how to debug this
>
> Mark
>
>
>
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
