Web Query
Hello All
Can we run any javascript using Web query in excel? Javascript function pull some data in excel? Thanks in advance |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 07:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com