We help IT Professionals succeed at work.

Internet Explorer

I use the Excel web query feature extensively within Excel 2000 programs.
That feature works fine when I can go directly to the Web page; but there are instances where I must:
1.     go to the portal home page
2.     identify myself with an ID and password
3.     then navigate through several web pages until I reach the appropriate page that has the data I need
Is it possible to do the above three functions all programically without any user intervention?
Basically I currently accomplish the above as follows:
1.     issue a followURL, with an address of the home page
2.     issue a msgbox which suspends the Excel program
3.     paste the clipboard
When issuing the followURL, control passes to the web browser. Then the user does the following:
1.     keys in the ID and password
2.     navigates to the proper web page
3.     does a right click
4.     left click select all
5.     another right click
6.     left click copy
7.     click the Excel program on the task bar, which returns control to the Excel program
When returning to the Excel program, the clipboard contains the information of the appropriate web page. Then the clipboard can be pasted to a sheet, which then emulates a Web QUERY.
The above works, but it?s not neat and clean, and error prone.
My inclination tells me it?s not trivial what I?m asking for. I believe basically I need some direction of where to obtain documentation such that I can educate myself in this area. Any general snippet of code that might lead me in a direction of investigation might be helpful.
It seems to me the only way possible to accomplish the above, is something as follows:
1.     obtain a copy of the HTML program,. which is no problem
2.     learn it?s internals I?m not proficient in HTML, but I can get there.
3.     emulate the actions the user would do.
It?s step 3 that I have no idea how to do.
Thanks for any help.
Stephen L. Showler
Comment
Watch Question

Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
1.     obtain a copy of the HTML program,. which is no problem
3.     emulate the actions the user would do.
You don't need to know 2 specifically.
A time ago i did a similar program for a question here. The steps were:
1)Navigate to web page and write user and password and submit that information.
2) When logged, write text on a text box to get stock quotes for a given company.
3) Navigate to desired page and save it to disk in special folder.
This could be similar, don't you think so?

Commented:
hi

Have you done a "record macro"  in Excel and then gone through the steps that you noted. Even if it does not work the first time it should give you a framework from which to refine the effort...

I just did start excel and it is not clear how to open a web page ...guess I better do some reseach first...

Your question piques my interest because I often go to the CBOE to download the Stock Option data to put in Excel and it would be much more efficient to have a technique to do it the way you wish to do it.

I will research this and report back. ...  leo

Author

Commented:
Hi Leo,
It's nice to meet you.
It?s interesting what you say about your application. My application is somewhat in the same vain. My professional career was an IBM mainframe programmer for 35 years. I?ve been retired for 9+ years. I have zero professional experience with PCs. Everything I know in this environment is self taught. My son is a financial analyst, and I am the IS guy for his office. No pay of course. Oh well, I guess ?Once a parent always a parent!?.
Your possible solution:
1.     saving a web page: My experience has shown you loose the variable information.
2.     opening a web page: That can be accomplished by issuing the command:
                                    ActiveWorkbook.FollowHyperlink Address:= URLaddress
                                    of desired web page
3.     recording a macro: I use that technique within Excel extensively; but if you go out of Excel and then return, none of the actions out of Excel will be recorded. The only way I see using that technique is Scripting. I?ve been investigating Scripting for some time, but I?m yet to get my arms around it. I?ve found documentation of the language on the MS website. But so what! If you don?t know the objects and their associated properties and methods within an environment, you can not do much. Even though you may know the basics of VB, you?re a worthless piece of ****, if you don?t know the objects. My problem is, I haven?t found that documentation on Windows objects. Any leads on that, I would be greatly interested.

Stephen L. Showler
CERTIFIED EXPERT

Commented:
Hi!

Not much experience with your html thingys, but here's some code to help you to emulate the clicks : )

Download...
http://www.vb-helper.com/HowTo/mseevnt.zip

Description: Move the mouse and click a button programmatically (3K)

and/or

Download...
http://www.vb-helper.com/HowTo/mvmouse.zip

Description: Move the mouse programmatically (2K)

Let me know if you want me to break down the coding into their seperate parts so that it's easy just to call the functions : )

That's it!

glass cookie : )
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
Just for clarification, there is no need to move mouse to create a click event in a web page.
CERTIFIED EXPERT

Commented:
Oh yes, having what Richie_Simonetti has said in mind, you could also use sendkeys to do stuff like that.
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
SShowler, if you could provide HTML code for target page, i think i can acomplish what you need.
Cheers

Author

Commented:
Great!
Here is the entire sequence I would like to accomplish without user intervention:
1.     Go to https://www.hartfordadvisor.com/portal/signin.jsp. The ID is 041966. The password is: swimmer. The password is case sensitive. Click Login.
2.     Click ?Director Suite? within the ?Performance & Rates? tab.
3.     Click Daily Rates within Director Outlook.
4.     copy contents of web page to clipboard.
Stephen L. Showler
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
Stephen, lately, you must change those values..., it is a public site!
here is 7:24 pm, i could try it at home.

Author

Commented:
Richie,

I don't undertand what you're trying to tell.

Steve

Author

Commented:
Richie,

I don't undertand what you're trying to tell me.

Steve
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
Don't post your passwords and id in a public site.
By the way, i have some code working but i don't know at which level of.
Please, open your vba ide and set a reference  to
Microsoft Internet control
Microsoft HTML object library.

Paste this code on thisworkbook module:

Option Explicit

Dim WithEvents IE As InternetExplorer
Sub StartIE()
Set IE = New InternetExplorer
With IE
    .navigate "https://www.hartfordadvisor.com/portal/signin.jsp"
    .Visible = True
End With
End Sub

Sub WaitTo()
Do While IE.Busy <> False
    DoEvents
Loop
IE.navigate "https://www.hartfordadvisor.com/common/unit_values/individual_annuities/uv_dir_outlook_daily.htm"
End Sub


Private Sub IE_DocumentComplete(ByVal pDisp As Object, URL As Variant)
If (pDisp Is IE) Then
    Select Case UCase$(URL)
        Case UCase$("https://www.hartfordadvisor.com/portal/signin.jsp")
            Dim inp As IHTMLInputTextElement
            For Each inp In IE.document.all.tags("INPUT")
                On Error Resume Next
                If inp.Name = "hauser" Then
                    inp.Value = "041966"  'replace with your id
                ElseIf inp.Name = "password" Then
                    inp.Value = "swimmer"  'replace with your password
                End If
                Dim img As HTMLImg
                Set img = IE.document.all.tags("login")
                img.Click
                Call WaitTo
                Exit For
            Next
        Case UCase$("https://www.hartfordadvisor.com/common/unit_values/individual_annuities/uv_dir_outlook_daily.htm")
            Dim txtrng As IHTMLTxtRange
            Set txtrng = IE.document.body.createTextRange
            txtrng.Select
            txtrng.execCommand "Copy", False
    End Select
End If
End Sub


Run StartIE macro to begin.
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
Hi, any progress/problem?
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
Hi leo, i hope this could be useful to you too ;)

i just did a little change:

Option Explicit

Dim WithEvents IE As InternetExplorer
Sub StartIE()
Set IE = New InternetExplorer
With IE
    .navigate "https://www.hartfordadvisor.com/portal/signin.jsp"
    .Visible = True
End With
End Sub

Sub CloseIE()
On Error Resume Next
IE.Quit
Set IE = Nothing
End Sub


Private Sub IE_DocumentComplete(ByVal pDisp As Object, URL As Variant)
If (pDisp Is IE) Then
    Select Case UCase$(URL)
        Case UCase$("https://www.hartfordadvisor.com/portal/signin.jsp")
            Dim inp As IHTMLInputTextElement
            For Each inp In IE.document.all.tags("INPUT")
                On Error Resume Next
                If UCase$(inp.Name) = "HAUSER" Then
                    inp.Value = "041966"  'replace with your id
                    Debug.Print "ID: OK"
                ElseIf UCase$(inp.Name) = "PASSWORD" Then
                    inp.Value = "swimmer"  'replace with your password
                    Debug.Print "PWD: OK"
                End If
             Next
            Dim img As HTMLImg
            Set img = IE.document.body.all("login")
            img.Click
                       
        Case UCase$("https://www.hartfordadvisor.com/portal/index.jsp?pageID=mypage")
            IE.navigate "https://www.hartfordadvisor.com/common/unit_values/individual_annuities/uv_dir_outlook_daily.htm"
           
        Case UCase$("https://www.hartfordadvisor.com/common/unit_values/individual_annuities/uv_dir_outlook_daily.htm")
            Dim txtrng As IHTMLTxtRange
            Set txtrng = IE.document.body.createTextRange
            txtrng.Select
            txtrng.execCommand "Copy", False
    End Select
End If
End Sub



Author

Commented:
Richie,
Thanks so much for the reply. The code illustration is exactly what I need to get off of square one. I don?t know how much hand holding you can do, but here are the questions I currently have:
1.     I didn?t understand your statement ?Don't post your passwords and id in a public site?.
2.     Reference libraries have always been a great mystery to me and their associated documentation. The only one I?ve ever referenced is DAO. The way I found about that library was studying SQL language, because I update several MS Access databases within this program. I only guessed DAO because I saw that phrase several times within the book I was reading, but I have no idea the difference .between version 2.5/3.5 compatibility vs version 3.5 vs version 3.6. To me, it?s terribly frustrating guessing at things.
3.     Which now brings the issue of the HTML library. Obviously Internet Explorer is an object with its associated properties, methods and commands. What book or documentation do I obtain to educate myself?
4.     I was looking at the web site, Fatbrain. Is that the best web site for technical books? I?m not buying hundreds of books, so cost is not an issue to me. What book do you recommend on HTML programming?
5.     The compiler states the line of code ?Dim WithEvents IE As InternetExplorer? must be within an object module. I?ve not done anything with events, so I have a bit of studying to do; but at least I think I know where to study that subject. I?ve seen it referenced in the VB Programming Reference Guide.
6.     I surmise with the sample code you?ve given me, it logs me into the Hartford web site. But then how do I navigate to the subsequent proper web pages? Let me attempt to master what you have given me, and see if I can go the next step alone.
It?s pretty obvious that I have a fairly steep learning curve to climb, if I am going to become proficient in this area, but that?s OK.

Thanks again for your help.

Stephen L. Showler
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
1). It is not a good idea post a private id and password in internet where everybody could get it and use it. That's all.
2). When you reference a library, all objects associated with a given COM dll are now enabled to creates objects variables to use them.
In example,
if you reference DAO object library (any version), you could acces its objects by code and declare variables of that type.

dim dbmain as DAO.Database
dim rset as DAO.Recordset
........

In our specific case, you need to go to Tools, references... and navigate list to locate Internet explorer controls and microsoft html objects.

now, we can create variables of thtat type of object, like

dim withevents IE as internetExplorer

This creates an object var of type Internetexplorer and we can access its events too.

.....
more on this later....


Author

Commented:
Richie,

I understand everything you have said, and I've done that with DAO; and used it successfully for several years. But my point being I found a book within the VB CD ROM on SQL that enabled me to learn the commands, properties & methods of the SQL COM. Where do I gain that same knowledge for Internet Explorer?

Steve
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
3). Take a look at http://msdn.microsoft.com/library/officedev/odeomg/deovrmicrosoftinternetexplorer5documentobjectmodel.htm
www.angelfire.com/realm/vb-shared/index.html to start with.

4). Sorry, i never use a book to know HTML, give a shot at www.w3c.com

5). that code must be pasted in general declarations section of thisworkbook (Are you using excel, aren't you?)
We manage here just one event DocumentComplete which is the door to open IE's DOM .

6). That code not only log you, but navigate to page desired and pasted contents in clipboard. I did a test and works more or less without any problem.
Please, use my LAST code.
Cheers
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
.....
"Where do I gain that same knowledge for Internet Explorer?"
.....

Good luck! ;)
It took me some time to found how IE COM/DOM works. The urls posted is a good start.
Also, take a look at MSDN, the documentation is obscure but... better than nothing.
Also check object browser (F2) from VBA IDE could help given you some clue.
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
Well, well...
I did a little cleaning session on code posted and get some valuable advantages:

1). In your project, reference Internet explorer controls ONLY (One object less, less resources wasted).
2) Change the code from "old" IE_DocumentComplete event to this one:
Private Sub IE_DocumentComplete(ByVal pDisp As Object, URL As Variant)
If (pDisp Is IE) Then
    Select Case UCase$(URL)
        Case UCase$("https://www.hartfordadvisor.com/portal/signin.jsp")
            Dim inp As Object 'IHTMLInputTextElement
            Set inp = IE.document.all.Item("hauser")
            inp.Value = "041966"  'replace with your id
            Set inp = IE.document.all.Item("password")
            inp.Value = "swimmer"  'replace with your password
            IE.document.Scripts.checkIdpass
                       
        Case UCase$("https://www.hartfordadvisor.com/portal/index.jsp?pageID=mypage")
            IE.navigate "https://www.hartfordadvisor.com/common/unit_values/individual_annuities/uv_dir_outlook_daily.htm"
           
        Case UCase$("https://www.hartfordadvisor.com/common/unit_values/individual_annuities/uv_dir_outlook_daily.htm")
            With IE
                .ExecWB OLECMDID_SELECTALL, OLECMDEXECOPT_DODEFAULT
                .ExecWB OLECMDID_COPY, OLECMDEXECOPT_DODEFAULT
            End With
        End Select
End If
End Sub

3). It is 3 times faster than previous one.
4). I am learning too.

Commented:
hi all,

I just returned from a camping trip and see a lot of very interesting ideas here...will take some time for me to work through it all. This sort of exchange really does look like EE at it's very best.

leo
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
Welcome leo, take a look at comments and let me know if, with variations, it could apply to you too.
Cheers

Author

Commented:
Leo,

I am a new member, so I didn't know what to expect; but I am super impressed! Most of these types of services I've dealt with in the past are bull****! Richie hasn't given me bull**** answers. Before I read your comment, I had sent the following email to EE:
============
I am a new member, and I would like to ask a few questions that I couldn't seem to find within help.
1. Can you have an attachment with a question?
2. Can a question be revisited once the questioner has accepted the answer?
3. What's the common guideline timeframe for accepting an answer? I know help says "as soon as possible". Maybe I'll feel more comfortable when I get an answer to question #2.
4. Can you ask for a certain person?

My first impression has been very positive. I consider my 1st question not easy. The response time in answering is excellent.
============
I now need time to assimilate everything given me. If you want, I?ll close this out now.
If I never hear from you people again, I am light years ahead of where I was before.

Stephen L. Showler
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
Stephen, if you have any question regarding on how to proceed for a given matter, post a question at:

http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt

Cheers
Richie
PS: How about code, it works or not?, do you need more help or clarification?

Author

Commented:
Hi,
I having trouble executing the code. Let?s first establish I have copied the correct version of the code. It is as follows between the dashed lines:
============
Dim WithEvents IE As InternetExplorer
Option Explicit
Sub StartIE()
Set IE = New InternetExplorer
    With IE
       .navigate "https://www.hartfordadvisor.com/portal/signin.jsp"
       .Visible = True
    End With
End Sub
Sub CloseIE()
    On Error Resume Next
    IE.Quit
    Set IE = Nothing
End Sub
Private Sub IE_DocumentComplete(ByVal pDisp As Object, URL As Variant)
    If (pDisp Is IE) Then
       Select Case UCase$(URL)
           Case UCase$("https://www.hartfordadvisor.com/portal/signin.jsp")
               Dim inp As IHTMLInputTextElement
               For Each inp In IE.Document.all.tags("INPUT")
                   On Error Resume Next
                   If UCase$(inp.Name) = "HAUSER" Then
                       inp.Value = "041966"  'replace with your id
                       Debug.Print "ID: OK"
                   ElseIf UCase$(inp.Name) = "PASSWORD" Then
                       inp.Value = "swimmer"  'replace with your password
                       Debug.Print "PWD: OK"
                   End If
                Next
               Dim img As HTMLImg
               Set img = IE.Document.body.all("login")
               img.Click
                         
           Case UCase$("https://www.hartfordadvisor.com/portal/index.jsp?pageID=mypage")
               IE.navigate "https://www.hartfordadvisor.com/common/unit_values/individual_annuities/uv_dir_outlook_daily.htm"
               
           Case UCase$("https://www.hartfordadvisor.com/common/unit_values/individual_annuities/uv_dir_outlook_daily.htm")
               Dim txtrng As IHTMLTxtRange
               Set txtrng = IE.Document.body.createTextRange
               txtrng.Select
               txtrng.execCommand "Copy", False
       End Select
    End If
End Sub
============
This code is within ThisWorkbook module.
I have set the reference to:
1.     Microsoft Internet control
2.     Microsoft HTML object library
Even though I don?t have any documentation on InternetExplorer, the code looks solid to me.
I assume DocumentComplete is a standard event, and the subroutine IE_DocumentComplete would gain control when a web page has been loaded. Then you look at the URL to determine which web page has been loaded, and take the appropriate action.
When I execute StartIE, the first web page gets loaded; but the program never traps back to IE_DocumentComplete. Therefore no further action takes place.
Obviously some environmental control in my system has not been set.

Steve

Author

Commented:
Hi,
I having trouble executing the code. Let?s first establish I have copied the correct version of the code. It is as follows between the dashed lines:
============
Dim WithEvents IE As InternetExplorer
Option Explicit
Sub StartIE()
Set IE = New InternetExplorer
    With IE
       .navigate "https://www.hartfordadvisor.com/portal/signin.jsp"
       .Visible = True
    End With
End Sub
Sub CloseIE()
    On Error Resume Next
    IE.Quit
    Set IE = Nothing
End Sub
Private Sub IE_DocumentComplete(ByVal pDisp As Object, URL As Variant)
    If (pDisp Is IE) Then
       Select Case UCase$(URL)
           Case UCase$("https://www.hartfordadvisor.com/portal/signin.jsp")
               Dim inp As IHTMLInputTextElement
               For Each inp In IE.Document.all.tags("INPUT")
                   On Error Resume Next
                   If UCase$(inp.Name) = "HAUSER" Then
                       inp.Value = "041966"  'replace with your id
                       Debug.Print "ID: OK"
                   ElseIf UCase$(inp.Name) = "PASSWORD" Then
                       inp.Value = "swimmer"  'replace with your password
                       Debug.Print "PWD: OK"
                   End If
                Next
               Dim img As HTMLImg
               Set img = IE.Document.body.all("login")
               img.Click
                         
           Case UCase$("https://www.hartfordadvisor.com/portal/index.jsp?pageID=mypage")
               IE.navigate "https://www.hartfordadvisor.com/common/unit_values/individual_annuities/uv_dir_outlook_daily.htm"
               
           Case UCase$("https://www.hartfordadvisor.com/common/unit_values/individual_annuities/uv_dir_outlook_daily.htm")
               Dim txtrng As IHTMLTxtRange
               Set txtrng = IE.Document.body.createTextRange
               txtrng.Select
               txtrng.execCommand "Copy", False
       End Select
    End If
End Sub
============
This code is within ThisWorkbook module.
I have set the reference to:
1.     Microsoft Internet control
2.     Microsoft HTML object library
Even though I don?t have any documentation on InternetExplorer, the code looks solid to me.
I assume DocumentComplete is a standard event, and the subroutine IE_DocumentComplete would gain control when a web page has been loaded. Then you look at the URL to determine which web page has been loaded, and take the appropriate action.
When I execute StartIE, the first web page gets loaded; but the program never traps back to IE_DocumentComplete. Therefore no further action takes place.
Obviously some environmental control in my system has not been set.

Steve
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
Well, that is OLD one.
Since that, i did some modifications and posted here. You NEED to see my last code for DocumentComplete event.

Regarding your thougths:
What you are understood about code is correct.
We can manage URLs in that event, if it is what we want, go further, if it is not. we stay.
We could navigate all route to the target page but i was seeing that it appears to be not necessary.
Instead of go url to url, i only go to login page, put id and password and navigate to next one which is second stage of your requirement.
From there, we only need to go url to url to gain access to page we need to copy to clipboard.
We assume that we are already connected to internet.

To me, site doesn't evaluate your id/password every time you load a page. So, once we are inside, just navigate to target page directly (Since i know its url).
After that, select contents and put it in clipboard. I did a test and it works like a charm.
I beg you use my last code. Just in case we are lost between all postings, i put it here again:

'Newest code for DocumentComplete event, replace old one with THIS:
' READ COMMENTS inside code

Private Sub IE_DocumentComplete(ByVal pDisp As Object, URL As Variant)
If (pDisp Is IE) Then
   Select Case UCase$(URL)
       Case UCase$("https://www.hartfordadvisor.com/portal/signin.jsp")
           Dim inp As Object ' We are in login page           Set inp = IE.document.all.Item("hauser")
' Set value id in textbox
           inp.Value = "041966"  'replace with your id
           Set inp = IE.document.all.Item("password")
' Set value Password in textbox
           inp.Value = "swimmer"  'replace with your password
' Click on login button to gain access to the site
           IE.document.Scripts.checkIdpass
                     
       Case UCase$("https://www.hartfordadvisor.com/portal/index.jsp?pageID=mypage")
' If we are here, we have passed identification.
' So, navigate to our final target.
           IE.navigate "https://www.hartfordadvisor.com/common/unit_values/individual_annuities/uv_dir_outlook_daily.htm"
           
       Case UCase$("https://www.hartfordadvisor.com/common/unit_values/individual_annuities/uv_dir_outlook_daily.htm")
' We are in target page, select all contents and put it in cliboard
           With IE
               .ExecWB OLECMDID_SELECTALL, OLECMDEXECOPT_DODEFAULT
               .ExecWB OLECMDID_COPY, OLECMDEXECOPT_DODEFAULT
           End With
' we have finished, congratulations!
       End Select
End If

End Sub

Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
I hope that make sense to you. I missed some carriage returns.
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
oops!
I made a mistake, sorry:

Private Sub IE_DocumentComplete(ByVal pDisp As Object, URL As Variant)
If (pDisp Is IE) Then
    Select Case UCase$(URL)
        Case UCase$("https://www.hartfordadvisor.com/portal/signin.jsp")
            Dim inp As Object
            Set inp = IE.document.all.Item("hauser")
            inp.Value = "041966"  'replace with your id
           
            Set inp = IE.document.all.Item("password")
            inp.Value = "swimmer"  'replace with your password
           
            Set inp = IE.document.all.Item("login")
            inp.Click
           
        Case UCase$("https://www.hartfordadvisor.com/portal/index.jsp?pageID=mypage")
            IE.navigate "https://www.hartfordadvisor.com/common/unit_values/individual_annuities/uv_dir_outlook_daily.htm"
           
        Case UCase$("https://www.hartfordadvisor.com/common/unit_values/individual_annuities/uv_dir_outlook_daily.htm")
            With IE
                .ExecWB OLECMDID_SELECTALL, OLECMDEXECOPT_DODEFAULT
                .ExecWB OLECMDID_COPY, OLECMDEXECOPT_DODEFAULT
            End With
        End Select
End If
End Sub

Author

Commented:
Hi Richie,
The code works fine, but not without a silly problem! I reported last time that when the 1st web page got loaded, the system did not seem to acknowledge the documentcomplete event. I could not figure out why. I screwed around for hours trying to figure out why. For some stupid reason, if you touch the code in any way, something gets screwed up. What, I don?t know. For the most part, I was merely setting breakpoints, so I could follow the flow. So in shear desperation, I completely exited out of Excel and started over. When doing that, and just executing the macro; it works fine! I?ll figure out why; but in the meantime, I?ll get around the problem.
VBA for Excel is still a stepchild, as compared to the regular VB. With each release of Excel, VBA for Excel is still a stepchild; but it?s getting better. The 1st release going from macro 4.0 to VB, was horrible!
Enough of the bull****. Thanks for your help.
I still need to pursue finding decent documentation on:
1.     events
2.     properties
3.     methods
for Internet Explorer. What you showed me was great, but I need to do know more if I?m going to do other things my son needs.
If you come across any other documentation that you think might help, notifying me would be greatly appreciated. My handle is: s.slshowler@verizon.net
Thanks again.
Steve
IT Operations
CERTIFIED EXPERT
Commented:
Strange, last night i did a complete test and works OK!
To use StartIE again, you need to use CloseIE first du to object refrences in code.
I will send you my workbook and do a try by yourself. Just keep in touch until we finished this crap ;)
As i said before, documentation is obscure. You could go to MSDN. I am sorry. I can't post other sites since i'm still learning and i am a bit confuzed too.
There is an excelent graphic regarding IE object model at:
http://msdn.microsoft.com/library/en-us/dnie40/html/msdn_lassesen.asp?frame=true

Author

Commented:
As I said before, if I never get another question answered, the price I paid for this service, was a great bargin!
From what I can see, Mr. Simonetti knows his stuff.

Stephen L. Showler
Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
Glad to help you!
and i hope this comment reaches your place.
Cheers

Commented:
How would you change this if it was a form button instead of an image?

       Dim img As HTMLImg
               Set img = IE.document.all.tags("login")
               img.Click
               

looking at it and was wondering how to submit if it wasn't an image like the example solved before.

Richie_SimonettiIT Operations
CERTIFIED EXPERT

Commented:
You could use:

IE.document.all.tags("login").click

or submit the form (something like this):
IE.document.forms("form1").submit

(that's not too accurate since i don't know the exact layout of your target page)

Explore More ContentExplore courses, solutions, and other research materials related to this topic.