FollowHyperlink
 

Hello.

I am programming an excel macro that needs to access an
organizational intranet page and fill in a form with some
varialbles assigned in the excel macro. FollowHyperlink
and SendKeys works fine if IE is already open on the task
bar, however, SendKeys is premature if an instance of IE
is not already open. Is there a better way of passing the
variables when the page does not accept parameters in the
address bar? Or is there a way to make excel recognize
when the page is done loading prior to SendKeys.

ThisWorkbook.FollowHyperlink Address:= "mypage.html"
SendKeys "some typing"

TIA
Mike