Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
followhyperlink Mike Archer[_2_] Excel Programming 0 December 18th 03 03:19 PM
followhyperlink failure Ron Dahl Excel Programming 2 November 4th 03 02:51 PM
FollowHyperlink then Save File Keith[_7_] Excel Programming 2 October 13th 03 08:29 PM
followhyperlink event for textboxs Ignatius Excel Programming 0 August 11th 03 11:25 PM


All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"