Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query
Hello All
Can we run any javascript using Web query in excel? Javascript function pull some data in excel? Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query
Need a clearer outline of what you want to do.
Tim "singh" wrote in message ... Hello All Can we run any javascript using Web query in excel? Javascript function pull some data in excel? Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query
Hi Tim
Thanks for replying my query. I am doing a daily activity in my office for which i have to download transaction and report from our client and it's taking a lot of time for me to do the same work again and again. I want to create a macro which will download those data for me. Client site has id and password and Button to download has Javascript. "Tim Williams" wrote: Need a clearer outline of what you want to do. Tim "singh" wrote in message ... Hello All Can we run any javascript using Web query in excel? Javascript function pull some data in excel? Thanks in advance |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query
That's not really much more detail :-)
Password is a popup or a form on a page ? Button should be clickable whether or not it has javascript document.formname.buttonname.click Tim "singh" wrote in message ... Hi Tim Thanks for replying my query. I am doing a daily activity in my office for which i have to download transaction and report from our client and it's taking a lot of time for me to do the same work again and again. I want to create a macro which will download those data for me. Client site has id and password and Button to download has Javascript. "Tim Williams" wrote: Need a clearer outline of what you want to do. Tim "singh" wrote in message ... Hello All Can we run any javascript using Web query in excel? Javascript function pull some data in excel? Thanks in advance |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query
Hi
Password is a form and button is clickable with javascript "Tim Williams" wrote: That's not really much more detail :-) Password is a popup or a form on a page ? Button should be clickable whether or not it has javascript document.formname.buttonname.click Tim "singh" wrote in message ... Hi Tim Thanks for replying my query. I am doing a daily activity in my office for which i have to download transaction and report from our client and it's taking a lot of time for me to do the same work again and again. I want to create a macro which will download those data for me. Client site has id and password and Button to download has Javascript. "Tim Williams" wrote: Need a clearer outline of what you want to do. Tim "singh" wrote in message ... Hello All Can we run any javascript using Web query in excel? Javascript function pull some data in excel? Thanks in advance |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query
What have you got so far ?
Tim "singh" wrote in message ... Hi Password is a form and button is clickable with javascript "Tim Williams" wrote: That's not really much more detail :-) Password is a popup or a form on a page ? Button should be clickable whether or not it has javascript document.formname.buttonname.click Tim "singh" wrote in message ... Hi Tim Thanks for replying my query. I am doing a daily activity in my office for which i have to download transaction and report from our client and it's taking a lot of time for me to do the same work again and again. I want to create a macro which will download those data for me. Client site has id and password and Button to download has Javascript. "Tim Williams" wrote: Need a clearer outline of what you want to do. Tim "singh" wrote in message ... Hello All Can we run any javascript using Web query in excel? Javascript function pull some data in excel? Thanks in advance |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query
My report will be generated after clicking the button
From where to get the name of the button and form...Is it the Text code provided for website?? Is the code below valid IE.document.getElementById("ID name").click and for javascript IE.document.getElementById("button name").click Pankaj "Tim Williams" wrote: What have you got so far ? Tim "singh" wrote in message ... Hi Password is a form and button is clickable with javascript "Tim Williams" wrote: That's not really much more detail :-) Password is a popup or a form on a page ? Button should be clickable whether or not it has javascript document.formname.buttonname.click Tim "singh" wrote in message ... Hi Tim Thanks for replying my query. I am doing a daily activity in my office for which i have to download transaction and report from our client and it's taking a lot of time for me to do the same work again and again. I want to create a macro which will download those data for me. Client site has id and password and Button to download has Javascript. "Tim Williams" wrote: Need a clearer outline of what you want to do. Tim "singh" wrote in message ... Hello All Can we run any javascript using Web query in excel? Javascript function pull some data in excel? Thanks in advance |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query
You'll have to look at the HTML source to find the names or id's of the form
elements you need to interact with. Note that "id" is not the same as "name" and many form elements will have a name but not an id. getElementByID only works with id's. Whether or not a button has javascript attached, it's still the same type of element, so you don't need to distinguish based on this. All form elements should be accessible via: document.formName.elementName If the form has no name then use: document.forms[0].elementName Tim "singh" wrote in message ... My report will be generated after clicking the button From where to get the name of the button and form...Is it the Text code provided for website?? Is the code below valid IE.document.getElementById("ID name").click and for javascript IE.document.getElementById("button name").click Pankaj "Tim Williams" wrote: What have you got so far ? Tim "singh" wrote in message ... Hi Password is a form and button is clickable with javascript "Tim Williams" wrote: That's not really much more detail :-) Password is a popup or a form on a page ? Button should be clickable whether or not it has javascript document.formname.buttonname.click Tim "singh" wrote in message ... Hi Tim Thanks for replying my query. I am doing a daily activity in my office for which i have to download transaction and report from our client and it's taking a lot of time for me to do the same work again and again. I want to create a macro which will download those data for me. Client site has id and password and Button to download has Javascript. "Tim Williams" wrote: Need a clearer outline of what you want to do. Tim "singh" wrote in message ... Hello All Can we run any javascript using Web query in excel? Javascript function pull some data in excel? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import New Database Query (Union Query) in Spreadsheet | Excel Discussion (Misc queries) | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Stop to modify the SQL query manually entered into query ! | Excel Programming |