View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default $ 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?