Activating Javascript with excel Part 2

[Guest]

I am now trying to Edit a filter called 'Priority' which is referenced in the
source code as :

<td>Priority: </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

 

[Tim Williams]

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

 

[Guest]

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

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

I am now trying to Edit a filter called 'Priority' which is referenced in
the
source code as :

<td>Priority: </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

 

[Tim Williams]

try

document.getElementById("Priority_Desc").parentElement.getElementsByTagName("A")(0).click

watch out for wrapping there.

Untested: might be ....getElementsByTagName("A")(1).click

Tim

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

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

I am now trying to Edit a filter called 'Priority' which is referenced
in
the
source code as :

<td>Priority: </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

 

[Guest]

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

try

document.getElementById("Priority_Desc").parentElement.getElementsByTagName("A")(0).click

watch out for wrapping there.

Untested: might be ....getElementsByTagName("A")(1).click

Tim

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

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



I am now trying to Edit a filter called 'Priority' which is referenced
in
the
source code as :

<td>Priority: </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

 

[Andrew Taylor]

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).

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. Ican
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 lotof
time if I could automate it. Am I now at a dead end?
--
jason36

try

watch out for wrapping there.

Untested: might be ....getElementsByTagName("A")(1).click

Tim

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 tofind
that specific id?
Many Thanks
--
jason36
:
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
I am now trying to Edit a filter called 'Priority' which is referenced
in
the
source code as :
<td>Priority: </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

- Show quoted text -

 

[Tim Williams]

What kind of "box" is it ? Pop-up window or something else ?
In what way is it "security protected"

tim

 

[Guest]

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="javascriptpenQuery();" type="button" value="Open">

2/ Make sure it interacts with the source page and returns some data.

Regards