VBA to create column of hyperlinks and any selected hyperlink in the same tab

Hi, I have got a list of hyperlinks in column Y of my table, labeled "Link" - Then in column D I am using this formula for users to click on and follow the link =HYPERLINK([Link],"Link") This is working, but each link is opening in a new tab on the default browser (Chrome) - and what I would like to have happen is each link to open in the same tab, if its open.

I am aware there is a setting that opens new links in the same tab in Chrome but thats not what I want... I only want these link to use the same tab... was thinking there was a way to name that tab and if its open, use it, if its not open, create it...

does anyone know??

I was able to located a similar question in another forum post. The solution appears to be the second answer and not the one voted up.

I hope this helps
~Frab

You are saying this one?

I am confused as to what I actually need to do here...



Try using Spreadsheet::WriteExcel

#!/usr/bin/perl -w
use strict;
use Spreadsheet::WriteExcel;

# Create a new workbook called simple.xls and add a worksheet
my $workbook = Spreadsheet::WriteExcel->new('Example.xls');
my $worksheet = $workbook->add_worksheet();

# The general syntax is write($row, $column, $token). Note that row and
# column are zero indexed
# Write a hyperlink
$worksheet->write(10, 0, 'http://perldoc.perl.org/');
$worksheet->write(11, 0, 'http://stackoverflow.com/');

__END__
the hyperlinks are opened in same browser tabs(works fine in IE,Firefox,Chrome)

That was the one I was referring to, yes, however it is a very lengthy post with several solutions to different task and I did not read up on it fully. From everything I found it was the only information on opening internet links in the same tab of the browser without change the 'open in new tabs' setting in the browser itself.

I have not tested it, but as I said, it was the only (possible) solution I could find for what you are asking. Perhaps someone else will be more knowledgeable on the situation than I

~Frab