I tried your codes below and I got an run-time error 91 on the followingline:

UserName.Children(0).Value = myname

Thanks,

TP

"Joel" wrote:

try this. Put your password into the code.


Sub OpenWeb()

'put your user name and password here
myname = "UserName"
mypassword = "Password"

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

URL = "https://alertweb.omgeo.net/cleartrust/ct_logon.jsp"

'get web page
IE.Navigate2 URL
Do While IE.Readystate < 4 And IE.busy = True
DoEvents
Loop



Set UserName = IE.document.getElementById _
("app_login_acronym_selector_dd_user_id")
Set Password = IE.document.getElementById _
("app_login_acronym_selector_dd_password")
Set form = IE.document.getElementsBytagname("Form")

UserName.Children(0).Value = myname
Password.Children(0).Value = mypassword
form(0).submit


Do While IE.busy = True And IE.Readystate < 4
DoEvents
Loop

'dump the document to the worksheet
RowCount = 1
'---------------------------------------------------------------------------
For Each itm In IE.document.all
Range("A" & RowCount) = itm.tagname
Range("B" & RowCount) = itm.classname
Range("C" & RowCount) = itm.tagname
Range("D" & RowCount) = Left(itm.innertext, 1024)
RowCount = RowCount + 1
Next itm
'---------------------------------------------------------------------------

IE.Quit


End Sub






"fi.or.jp.de" wrote:

this is the web https://alertweb.omgeo.net/cleartrust/ct_logon.jsp

On Jul 21, 6:31 pm, Joel wrote:
This task isn't simple. I need to know how much programming experience you
have to determine if I cna help you through the process. I assume you don't
want to give out a pasword for me to do the task. If you give me the login
URL I can at least get you started by setting up a macro where you can enter
the account and password your self.

Each webpage is diferent so there isn't any generalized code that will work.
Each webpage requires custom software to retrieve the data.



"fi.or.jp.de" wrote:
Hi, I need to do the foll. from excel vba

I need to login to the website
then I need to choose the list from dropdown
Select particulat in web
then I need to copy any row which has check box.
add new workbook
paste the data.- Hide quoted text -

- Show quoted text -