Excel, OLE, hyperlinks

From: Lee Marlin (lmarlin_at_yahoo.com)
Date: 03/23/05 

Date: Wed, 23 Mar 2005 07:58:46 -0800 (PST)
To: beginners@perl.org

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 = $work***->Range("A1")->{'Value'};
                            $work***->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

Quantcast