Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating Javascript with excel Part 2
I am now trying to Edit a filter called 'Priority' which is referenced in the
source code as : <tdPriority: </td<td<span id="Priority_Desc"All</span <a href="javascript:editFilter('[Priority]');"Edit</a</td and then place a tick in the second Check Box displayed. Help would be very much appreciated -- jason36 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating Javascript with excel Part 2
If this is the only link on the page with the text "Edit":
dim lnk for each lnk in IE.document.links if lnk.innerText="Edit" then lnk.click exit for end if next l No idea for the next part without having the source code for the checkboxes. Tim "jason36" wrote in message ... I am now trying to Edit a filter called 'Priority' which is referenced in the source code as : <tdPriority: </td<td<span id="Priority_Desc"All</span <a href="javascript:editFilter('[Priority]');"Edit</a</td and then place a tick in the second Check Box displayed. Help would be very much appreciated -- jason36 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating Javascript with excel Part 2
Tim, This is not the only edit link, the source code has this edit by the id :
<span id="Priority_Desc"All</span. Is there a way to For Next to find that specific id? Many Thanks -- jason36 "Tim Williams" wrote: If this is the only link on the page with the text "Edit": dim lnk for each lnk in IE.document.links if lnk.innerText="Edit" then lnk.click exit for end if next l No idea for the next part without having the source code for the checkboxes. Tim "jason36" wrote in message ... I am now trying to Edit a filter called 'Priority' which is referenced in the source code as : <tdPriority: </td<td<span id="Priority_Desc"All</span <a href="javascript:editFilter('[Priority]');"Edit</a</td and then place a tick in the second Check Box displayed. Help would be very much appreciated -- jason36 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating Javascript with excel Part 2
try document.getElementById("Priority_Desc").parentEle ment.getElementsByTagName("A")(0).click watch out for wrapping there. Untested: might be ....getElementsByTagName("A")(1).click Tim "jason36" wrote in message ... Tim, This is not the only edit link, the source code has this edit by the id : <span id="Priority_Desc"All</span. Is there a way to For Next to find that specific id? Many Thanks -- jason36 "Tim Williams" wrote: If this is the only link on the page with the text "Edit": dim lnk for each lnk in IE.document.links if lnk.innerText="Edit" then lnk.click exit for end if next l No idea for the next part without having the source code for the checkboxes. Tim "jason36" wrote in message ... I am now trying to Edit a filter called 'Priority' which is referenced in the source code as : <tdPriority: </td<td<span id="Priority_Desc"All</span <a href="javascript:editFilter('[Priority]');"Edit</a</td and then place a tick in the second Check Box displayed. Help would be very much appreciated -- jason36 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating Javascript with excel Part 2
Tim,
Brilliant, I now have an issue that now I am presented with box that has a URL which is security protected so that I cannot view the source code. I can see checkboxes which have text next to them and a button which simply says OK next to it. I can check these manually but it would save me an awful lot of time if I could automate it. Am I now at a dead end? -- jason36 "Tim Williams" wrote: try document.getElementById("Priority_Desc").parentEle ment.getElementsByTagName("A")(0).click watch out for wrapping there. Untested: might be ....getElementsByTagName("A")(1).click Tim "jason36" wrote in message ... Tim, This is not the only edit link, the source code has this edit by the id : <span id="Priority_Desc"All</span. Is there a way to For Next to find that specific id? Many Thanks -- jason36 "Tim Williams" wrote: If this is the only link on the page with the text "Edit": dim lnk for each lnk in IE.document.links if lnk.innerText="Edit" then lnk.click exit for end if next l No idea for the next part without having the source code for the checkboxes. Tim "jason36" wrote in message ... I am now trying to Edit a filter called 'Priority' which is referenced in the source code as : <tdPriority: </td<td<span id="Priority_Desc"All</span <a href="javascript:editFilter('[Priority]');"Edit</a</td and then place a tick in the second Check Box displayed. Help would be very much appreciated -- jason36 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating Javascript with excel Part 2
There are always ways to view the HTML source - after all, it has
already been downloaded to your browser. Try the IE developer toolbar (if you use IE) or Firebug (if you use Firefox). On Sep 28, 12:01 pm, jason36 wrote: Tim, Brilliant, I now have an issue that now I am presented with box that has a URL which is security protected so that I cannot view the source code. I can see checkboxes which have text next to them and a button which simply says OK next to it. I can check these manually but it would save me an awful lot of time if I could automate it. Am I now at a dead end? -- jason36 "Tim Williams" wrote: try document.getElementById("Priority_Desc").parentEle ment.getElementsByTagName*("A")(0).click watch out for wrapping there. Untested: might be ....getElementsByTagName("A")(1).click Tim "jason36" wrote in message ... Tim, This is not the only edit link, the source code has this edit by the id : <span id="Priority_Desc"All</span. Is there a way to For Next to find that specific id? Many Thanks -- jason36 "Tim Williams" wrote: If this is the only link on the page with the text "Edit": dim lnk for each lnk in IE.document.links if lnk.innerText="Edit" then lnk.click exit for end if next l No idea for the next part without having the source code for the checkboxes. Tim "jason36" wrote in message ... I am now trying to Edit a filter called 'Priority' which is referenced in the source code as : <tdPriority: </td<td<span id="Priority_Desc"All</span <a href="javascript:editFilter('[Priority]');"Edit</a</td and then place a tick in the second Check Box displayed. Help would be very much appreciated -- jason36- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating Javascript with excel Part 2
What kind of "box" is it ? Pop-up window or something else ? In what way is it "security protected" tim On Sep 28, 4:01 am, jason36 wrote: Tim, Brilliant, I now have an issue that now I am presented with box that has a URL which is security protected so that I cannot view the source code. I can see checkboxes which have text next to them and a button which simply says OK next to it. I can check these manually but it would save me an awful lot of time if I could automate it. Am I now at a dead end? -- jason36 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating Javascript with excel Part 2
Thanks to Andrew I have obtained the web site and viewed the source code for
what I now know is a dialog box. The problem is that the dialog box appears only to work when it appears on the web page from which it was fired up from. If I try to run my saved queries from the dialog boxes unique url nothing happens. Two things I need to do. 1/ interact with the dialog box, source code for where I want to interact - AGM CLEANING SF - is : <option value="U816" allowEdit="True"AGM CLEANING SF</option which in turn will need to activate the open query button : <td<input id="btnOpen" style="WIDTH: 75px" disabled onclick="javascript:openQuery();" type="button" value="Open" 2/ Make sure it interacts with the source page and returns some data. Regards -- jason36 "Tim Williams" wrote: What kind of "box" is it ? Pop-up window or something else ? In what way is it "security protected" tim On Sep 28, 4:01 am, jason36 wrote: Tim, Brilliant, I now have an issue that now I am presented with box that has a URL which is security protected so that I cannot view the source code. I can see checkboxes which have text next to them and a button which simply says OK next to it. I can check these manually but it would save me an awful lot of time if I could automate it. Am I now at a dead end? -- jason36 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating javascript with excel | Excel Programming | |||
How to enable javascript in Excel? | Excel Programming | |||
Help: Javascript to Excel VBA? | Excel Programming | |||
Open a webpage using Javascript in Excel | Excel Programming | |||
Activating / Closing workbook using part name and a wild character | Excel Programming |