Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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






  #5   Report Post  
Posted to microsoft.public.excel.programming
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








  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 225
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 114
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Activating javascript with excel jason36 Excel Programming 6 September 25th 07 01:22 PM
How to enable javascript in Excel? CC Excel Programming 1 August 17th 06 09:46 PM
Help: Javascript to Excel VBA? Ron J Excel Programming 3 April 6th 06 03:28 AM
Open a webpage using Javascript in Excel [email protected] Excel Programming 5 January 17th 06 09:05 PM
Activating / Closing workbook using part name and a wild character sharman Excel Programming 5 June 24th 05 04:00 PM


All times are GMT +1. The time now is 04:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"