HI

Am looking for the macros program to copy paste Excel data on to IE web form.

1. open IE
2. goto web page url, then enter login and password
3. in webpage goto "search box" and paste complaint number from excel file and click on search icon
4. wait till complaint opens, then there are about 6 fields to enter. enter all six fields.
5. click on close complaint icon
6. go to next complaint number in excel - search complaint - enter six fields - close complaint.
7.loop till all complaints are completed.

am in urgent need, please help me out.

i just tried using below code but i could not execute.


Private Sub cmdTest1_1_Click()
Dim SHELL_OBJECT ' *** Windows Shell Object Constant ***
Dim APP_PATH ' *** Application path to load with shell ***
Dim ie As Object

SHELL_OBJECT = "WScript.Shell"
APP_PATH = "www.abcd.com"

Set objShell = CreateObject(SHELL_OBJECT) ' *** Create Shell Object. Used to pass sendkeys. Avoid use. ***
Set ie = CreateObject("InternetExplorer.Application")
ie.Navigate "www.abcd.com"
ie.Visible = True

While ie.busy
DoEvents
Wend

objShell.AppActivate (APP_PATH) ' goes to the specified path
objShell.SendKeys "{TAB}" ' same as pressing tabs once
objShell.SendKeys "username"
objShell.SendKeys "{TAB}"
objShell.SendKeys "password"

While IE.Busy
DoEvents
ActiveCell.Select
Selection.Copy
Wend
' **********************************************************************
delay 1
IE.Document.getElementById("receipt").Click
delay 1
IE.Document.getElementById("receipt").Paste
delay 2
IE.Document.getElementById("submit").Click

End Sub