Help for this page

Select Code to Download


  1. or download this
    Sub Macro1()
    ' Right-click a cell
    ...
    ' Right-click cell again, do "Edit Hyperlink..." and s/foo/bar/
        Selection.Hyperlinks(1).TextToDisplay = "bar"
    End Sub
    
  2. or download this
    use strict;
    use warnings;
    ...
    #  warn $Sheet->Hyperlinks($_)->Anchor;  # This errors with "Member no
    +t found"
    }
    $Book = $Excel->Workbooks->Close();