HarrisLFC
03-13-2008, 12:32 PM
Hi, I'm trying to automate an account transaction using Internet Explorer. I've been partially successful based on the code that I've on this site.
I submit a set of notes using Internet Explorer:
' The account notes...
IE.Document.all("txtNotes1").Value = "Service Termination Notice"
IE.Document.all("txtNotes2").Value = "mailed 3/11/2008"
.
.
' submit the note...
IE.Document.all("submit1").Click
If the note is successfully submitted, Internet Explorer returns an OK / Cancel dialog box saying that the notes have been "successfully added."
If the note failed, Internet Explorer returns a regular web page, but with a SQL error. I'm guessing for this I will have to load the web page into VBA to do a find.
How would I trap for the OK / Cancel dialog box and click OK or Cancel (it's an ambiguous box) on it to loop to the next account (or load the error page for a find operation)?
I submit a set of notes using Internet Explorer:
' The account notes...
IE.Document.all("txtNotes1").Value = "Service Termination Notice"
IE.Document.all("txtNotes2").Value = "mailed 3/11/2008"
.
.
' submit the note...
IE.Document.all("submit1").Click
If the note is successfully submitted, Internet Explorer returns an OK / Cancel dialog box saying that the notes have been "successfully added."
If the note failed, Internet Explorer returns a regular web page, but with a SQL error. I'm guessing for this I will have to load the web page into VBA to do a find.
How would I trap for the OK / Cancel dialog box and click OK or Cancel (it's an ambiguous box) on it to loop to the next account (or load the error page for a find operation)?