Thread: Web Query
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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