Web Query

[singh]

Hello All

Can we run any javascript using Web query in excel? Javascript function pull
some data in excel?

Thanks in advance

 

[Tim Williams]

Need a clearer outline of what you want to do.

Tim

 

[singh]

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]

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]

Hi

Password is a form and button is clickable with javascript

 

[Tim Williams]

What have you got so far ?

Tim

Hi

Password is a form and button is clickable with javascript

 

[singh]

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]

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