Jump to content



Recommended Posts

Hello GuysI'm currently running this script inside MS Excelnow this works (may have typos below) however when using this line ".body1:_id3:Number.Value=Range("B1")" it returns an error due to the _ However this is the Name & ID of this field. this CANNOT be change is their anyway i can still reference this field without changing the name and id of this field? If it's any use i know its the 3rd input box down?

Dim ObjIE as objectSet ObjIe = createobject ("internetExplorer.Application")with ObjIe.Navigate = "http://localhost/test.php"Do While .busy:DoEvents:LoopDo While .ReadyState<>4:DoEvents:Loop.Visible = Truewith .Documents.forms("myForm").body1:_id3:Number.Value=Range("B1").SubmitEnd WithEnd WithSet ObjIe = Nothing

Second Question is:on a second form (no relation to the first form)to submit the form the button is <input type="submit" name="test" value="Search" /> that needs to be clicked however their is also another submit button which has the value of <input type="submit" name="test" value="Clear" />i have tried this..test.Value="Search"but with no joy so i triedwith .Documents.forms("myForm").value="Search".submitbut again with no joyanyone able to help with either of these questions?thanks Very MuchJonathon Morris

Link to comment
Share on other sites

  • 11 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...