$ dollar signs causing issues in Excel VBA - HTML

  • Thread starter Thread starter mrsharkspoiler
  • Start date Start date
M

mrsharkspoiler

My goal is to automate a login process however the name of the Submit
button on the webpage is : "user$btnSubmit"

and when i put the following code in excel VBA, it will automatically
put a space after the $ as though its some kind of special character
and the code doesnt work


With ie2
With .Document.user$btnSubmit.Click()
End With
End With


HTML code:

<td><input type="submit" name="user$btnSubmit" value="Submit"
onclick="javascript:WebForm_DoPostBackWithOptions(new
WebForm_PostBackOptions(&quot;user$btnSubmit&quot;, &quot;&quot;,
true, &quot;&quot;, &quot;&quot;, false, false))" id="user_btnSubmit"
accesskey="S" />


i've managed to get it working with:

With ie2
With .Document.all.Item(158).Click()
End With
End With

however sometimes under certain circumstances, the button isnt located
under item 158.
and im also wanting to call other txt input boxes by name (which also
have $'s rather then item #s

Suggestions?
 
I've never worked with web "stuff" before, so this is only a guess... does
this work?

With .Document.all.Item("user$btnSubmit").Click()

Rick
 
Suggestions. Experiment with variants of

..Document.Elements("user$btnSubmit").Click()
..Document.getElementsById("user_btnSubmit").Click()

Try braces too which matches the syntax for some scripting languages
as in:

..Document.Elements["user$btnSubmit"].Click()


Also, look for a form tag as in "<form name='aForm' method=POST>

Then try

..Document.Forms("aForm").getElementsById("usr_btnSubmit").Click()
 
Back
Top