$ dollar signs causing issues in Excel VBA - HTML
 

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?

$ dollar signs causing issues in Excel VBA - HTML
 

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


wrote in message
ups.com...
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?

$ dollar signs causing issues in Excel VBA - HTML
 

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_btn Submit").Click()