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"?
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"?