javascript

Can't set object variable in HTMLDocument for scraping data from website  #angularjs #reactjs

  • Or just any other creative ways to pull the data.
  • Click While ie.Busy DoEvents Wend ‘ is the page with the return data on it ie.navigate caRetPage While ie.
  • Stack Overflow works best with JavaScript enabled
  • When I get an error in a long expression, I break it up into smaller pieces.
  • It’s a matter of the site won’t let me set the variables.

I have seen this question posted before, but my situation is somewhat different so I was hoping I could get some help from the community and maybe a fresh perspective. I have a macro written in vba that’s supposed to pull return data from this company’s online db, things like returns for MSCI World Index, S&P 500, etc. The code I have works on other pages, but I think this one is different. I talked to the webmaster and he told me that the code was not designed to be scraped, but that is not restricted by their usage policy. It would be a huge time saver for me if I could, indeed, get the data by scraping so I’m trying really hard to figure out a way to do it. I’ve tagged this under java-script as well, as I think the code would be very similar and I want to accept as many solutions as possible to solve this problem.

@ng_real_ninja: Can’t set object variable in HTMLDocument for scraping data from website #angularjs #reactjs

I have seen this question posted before, but my situation is somewhat different so I was hoping I could get some help from the community and maybe a fresh perspective. I have a macro written in vba that’s supposed to pull return data from this company’s online db, things like returns for MSCI World Index, S&P 500, etc. The code I have works on other pages, but I think this one is different. I talked to the webmaster and he told me that the code was not designed to be scraped, but that is not restricted by their usage policy. It would be a huge time saver for me if I could, indeed, get the data by scraping so I’m trying really hard to figure out a way to do it. I’ve tagged this under java-script as well, as I think the code would be very similar and I want to accept as many solutions as possible to solve this problem.

The situation is this: I have the following code that throws me an “Object variable not set” error when it comes to the actual scraping of the data (the line that begins ‘set els = htmlDoc….” I’ve tried many combinations of the getElement(s) function thinking that may have been the problem, but I’ve drawn a blank. Anybody know any other ways to set the object variable in this environment? Or just any other creative ways to pull the data.

I can’t give out the login info, but I think by just navigating to the ‘caRetPage’ site, you can see the html code that I’m trying to scrape/parse.

Any help would be greatly appreciated.

javascript

You might also like More from author

Comments are closed, but trackbacks and pingbacks are open.