View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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