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

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...