View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
jason36 jason36 is offline
external usenet poster
 
Posts: 9
Default 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