$ dollar signs causing issues in Excel VBA - HTML
- From: mrsharkspoiler@xxxxxxxxx
- Date: Sat, 01 Sep 2007 19:13:19 -0700
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("user$btnSubmit", "",
true, "", "", 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?
.
- Follow-Ups:
- Re: $ dollar signs causing issues in Excel VBA - HTML
- From: gimme_this_gimme_that@xxxxxxxxx
- Re: $ dollar signs causing issues in Excel VBA - HTML
- From: Rick Rothstein \(MVP - VB\)
- Re: $ dollar signs causing issues in Excel VBA - HTML
- Prev by Date: Re: Find same value in continuous Cells
- Next by Date: Re: CheckBox to select pages to print?
- Previous by thread: Re: Fetching 2 values from 20 excel files
- Next by thread: Re: $ dollar signs causing issues in Excel VBA - HTML
- Index(es):
Relevant Pages
|
