Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Macro to hit "Save" on an IE Form

Status
Not open for further replies.

makavity

Programmer
Nov 23, 2003
36
US
I'm using and application in Excel to fill out a form in IE.
I've got the fields set, however I don't seem to be able to find the correct command to hit the "Save" button on the form. I'm new to using Excel to manipulate IE, and haven't found any reference to clicking on a button. Best I can find is below, but it doesn't seem to hit the Save OR Cancel button, so I'm at a loss.
With objParent
.submit
End With

I ran the GetFields macro listed on the site, and it lists the buttons as:
Form_Name:
Form_ID: form1
Element_Name: _finish
Element_ID:
Element_nodeName: INPUT
Element_Type: submit
Element_Value: Save

There is also a "Cancel" button with the differences of:
Element_Name: _cancel
Element_ID: _cancel
Element_Value: Cancel

Can anyone post the actual command to hit "Save"?
 
Also, while I have you... I'm having trouble getting IE to settle after manipulation.

While objWindow.Busy
Wend
While objWindow.Document.ReadyState <> "complete"
Wend

doesn't seem to be enough wait time. Is there a better alternative, or more things to wait for?
 
Is there more information necessary to help get an answer on this question? I may be able to find more information if I knew what I have omitted.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top