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

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

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

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

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

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 -

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

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