• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Accessing websites which work on Javascript

BBD

Member
Hi,

I have been trying to input data to websites and click on buttons. The experiment has been fairly well with the use of looping through the objectcollections by tagnames,id,etc.

When trying to access into more complex websites, I noticed that the URL remains the same but the presentation or the options change in the IE contents due to javascripts running in the website. So when I looked at the object collections after the contents changed, it was same as the previous page. When I tried to look at the source codes, a page in the website gives different source codes when picked from different places from the same page (one relating to the URL and others relating to a particular section of the page). I am not able to modify or assign values to the source code of specific sections since I am not able to access it through the object collection. I will have to resort to sendkeys which is not a robust way.

How do we take care of above scenarios through VBA ?
 
Hi, BBD!
I've done a lot of that stuff, so I'm bad news. If it's all done thru JavaScript, game over. :(
Regards!
 
Hi SirJB7,

I have tried searching all places .. but in vain. Isn't there anyway to do it? Or anyone who could help me with it?

And Thanks for the reply :)
 
Last edited by a moderator:
Hi, BBD!
I'm afraid that from Excel and VBA it's impossible. Now if you go to Java or a web development environment like Visual Studio .NET, then you'd have more chances, but I can't assure that you'll succeed. It'll all depend on how the website exposes its data.
So regarding these forums' scope, I'm bad news: no, there isn't and you can't.
Regards!
 
Back
Top