To: Seers of Perl I am new to OLE Automation for Excel with Perl. I have a cell A1 containing text "123" and an associated hyperlink such as( http://www.somewhere.com/get.php?id=123) I want to go to A1, get the text for the hyperlink at A1, and place to contents of the text in E1. I tried: $cellA1 = $worksheet->Range("A1")->{'Value'}; $worksheet->Range("E1")->{'Value'} = $cellA1;
instead of getting the text of the hyperlink, I get the entire contents of A1 in E1. How can I get just the text of the hyperlink in E1? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
