$ dollar signs causing issues in Excel VBA - HTML

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

Rick Rothstein \(MVP - VB\)

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
 
G

gimme_this_gimme_that

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()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top