ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"http://www.google.com/";
This is the VBA for doing it where Anchor:=Selection indicates the currently
selected Cell... so a Range object...
so something like...
$MySheet->Hyperlinks->Add(Anchor=>$MySheet->Range("a1") , Address=>$url);
Kind regards,
Mark Anderson
Service Improvement Project
Level 2, 113 Dundas Street
Edinburgh, EH3 5DE
Tel: 0131 523 8786
Mob: 07808 826 063
> -----Original Message-----
> From: steve [SMTP:[EMAIL PROTECTED]
> Sent: Tuesday, January 11, 2005 3:00 PM
> To: perl-win32-users@listserv.ActiveState.com
> Subject: Win32 inserting URLs into excel sheet
>
> *** WARNING : This message originates from the Internet ***
>
>
> I am inserting URLs into an Excel spreadsheet (after opening the book and
> selecting the worksheet) like so:
>
> $sheet->Cells($i,$j)->{'Value'} = $url;
>
> However, Excel is not recognizing the entry as a URL, i.e., it does not
> appear as a link in the sheet. If I go to the sheet, manually place the
> cursor at the end of the URL and hit return, it is recognized as a URL.
> So I guess there is some process I need to trigger or some property I need
> to set to make Excell to recognize the entry as al ink. Does anyone know?
>
> Thanks...
>
> Steve << File: ATT187481.txt >>
The Royal Bank of Scotland plc, Registered in Scotland No. 90312. Registered
Office: 36 St Andrew Square, Edinburgh EH2 2YB
The Royal Bank of Scotland plc is authorised and regulated by the Financial
Services Authority and represents The Royal Bank of Scotland Marketing Group.
The Bank sells life policies, collective investment schemes and pension
products and advises only on the Marketing Group's range of these products and
on a With-Profit Bond produced by Norwich Union Life (RBS) Limited.
This e-mail message is confidential and for use by the addressee only. If the
message is received by anyone other than the addressee, please return the
message to the sender by replying to it and then delete the message from your
computer. Internet e-mails are not necessarily secure. The Royal Bank of
Scotland plc does not accept responsibility for changes made to this message
after it was sent.
Whilst all reasonable care has been taken to avoid the transmission of viruses,
it is the responsibility of the recipient to ensure that the onward
transmission, opening or use of this message and any attachments will not
adversely affect its systems or data. No responsibility is accepted by The
Royal Bank of Scotland plc in this regard and the recipient should carry out
such virus and other checks as it considers appropriate.
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
