View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FayettevilleEagles FayettevilleEagles is offline
external usenet poster
 
Posts: 1
Default What codes can make Excel Macro to submit forms on web

How can I write a macro in excel (Office 2003 version)
to perform web form submit? For example, I want to
run a macro from excel to make IE browser search for
Local Information at MSN.com HomePage. The macro
should excute the following steps:

1. Activates IE browser
2. Enter €œhttp://www.msn.com€ in the address line,
then wait for the page to complete.
3. Go to the Local Information section
4. Enter Zip code
5. Submit

What will be the code to handle this very typical
action on internet web? Your help is appreciated.

Regards,

id