Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
$ 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("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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
$ 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("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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
$ 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() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, what do the dollar signs mean in $A$1 | Excel Worksheet Functions | |||
Dollar signs on all tabs | Excel Discussion (Misc queries) | |||
Dollar signs in VBA | Excel Programming | |||
Get excel 2005 to line up damn dollar signs properly. Idiots. | Excel Discussion (Misc queries) | |||
Dollar signs | New Users to Excel |