Opening a URL in a cell without a mouse click
 

I am trying to automate a task with a macro recorder where I open a
hyperlink in a cell in a spreadsheet, save the displayed page then move
to the next cell and repeat. The problem I am experiencing is when I
use the mouse to click the hyperlink, the recorder always goes back to
the first cell I clicked when recording the session.

I need to use keystrokes to open the hyperlink. I have not found a
solution as of yet on how to open the web page with anything other than
a mouse. Any suggestions would be most welcome.

Terry


--
trountree
------------------------------------------------------------------------
trountree's Profile: http://www.excelforum.com/member.php...o&userid=27833
View this thread: http://www.excelforum.com/showthread...hreadid=473433