Greetings. I am trying to determine if/how one can specify a browser target window for a link inserted into an Excel spreadsheet via a program. I am creating a sheet with one column full of links that is used as part of a work process. Each link by default opens in a new tab of a browser, and after a while this results in a lot of tabs that have to be closed. To avoid this I'd like to specify a target in the browser and give all the links the same target. But is this possible?

I am actually using Perl OLE automation to do the link creation, i.e.

my $range = $Sheet->Range("B".$row);
my $link = "http://foobar.com/show.pl?id=$i";
$Sheet->Hyperlinks->Add({Anchor=>$range,Address=>$link,TextToDisplay=>"Link to $i"});
and I think most people on this board are doing things in VB, but given the way to do it in VB I could translate it.

TIA...

Steve