Excel Web-Import Issue

**chopperocker** · 01-29-12, 02:26 PM

im sure you know more than i do. is it a file on the web your trying to open? maybe try downloading to file and than open?

**JohnAnthony** · 01-29-12, 03:53 PM

Originally posted by chopperocker

im sure you know more than i do. is it a file on the web your trying to open? maybe try downloading to file and than open?

Hmmm, It's not a file, no. It's some sort of dynamic AJAX table. And I'm already doing the manual import of each league after each round, but that takes quite a while if you have 20 leagues on a Saturday.

**thom321** · 01-29-12, 07:10 PM

If you tell me the URL (and the exact tables you want to import) I can take a look.

From my experience, using standard Excel web query is most likely not going to work and depending on how the web page is structured, it might require quite a bit of work to get it done, if at all possible.

**JohnAnthony** · 01-29-12, 07:29 PM

Originally posted by thom321

If you tell me the URL (and the exact tables you want to import) I can take a look.

From my experience, using standard Excel web query is most likely not going to work and depending on how the web page is structured, it might require quite a bit of work to get it done, if at all possible.

I PM'ed you.

**icancount2one** · 01-30-12, 04:35 AM

If he can not get it to import the way you want it, I can parse it for you.

**thom321** · 01-30-12, 07:07 AM

JohnAnthony,

Feel free to take icancount2one up on the offer (assuming it is free). I PM'd you what I have so far. In any event, I wouldn't charge you for anything since I do it for fun (really but voluntary donations e.g. of points are always appreciated) and if the underlying URL structure would be changed on the web site, the data import would no longer work. If you paid to have something like this done, you should expect it to continue to work and I would not make any promise of continuing to maintain a working solution.

**thom321** · 01-30-12, 07:36 AM

JohnAnthony,

Sorry, I spoke to soon. I don't have enough posts to send you a PM. If you PM me a way to send you what I have so far, I will do so.

**JohnAnthony** · 01-30-12, 09:52 AM

Guys thank you both for your kind help, I really really appreciate it

Originally posted by icancount2one

If he can not get it to import the way you want it, I can parse it for you.

What is parsing? sorry =/

Originally posted by thom321

JohnAnthony,

Feel free to take icancount2one up on the offer (assuming it is free). I PM'd you what I have so far. In any event, I wouldn't charge you for anything since I do it for fun (really but voluntary donations e.g. of points are always appreciated) and if the underlying URL structure would be changed on the web site, the data import would no longer work. If you paid to have something like this done, you should expect it to continue to work and I would not make any promise of continuing to maintain a working solution.

Ok, I'll PM you my email address.

**thom321** · 01-30-12, 10:44 AM

I sent you a response.

"Parse" in this context to me means taking some text that has a structure to it, e.g. raw html code from a web page and go through it and extract the data you want.

**JohnAnthony** · 01-30-12, 11:24 AM

Originally posted by thom321

I sent you a response.

"Parse" in this context to me means taking some text that has a structure to it, e.g. raw html code from a web page and go through it and extract the data you want.

That also seems like a viable solution, how do we get around the Ajax thing though? because when you initially load the page, the two tables I need are not displayed.

Anyway, I just replied to your email, we can can go on from there!

**MonkeyF0cker** · 01-30-12, 07:21 PM

You likely need to use a browser to access the DOM after the page is updated. Here's a tutorial on using IE controls in VBA...

Working with Internet Explorer Using VBA - Collection of VBA Code Snippets and Useful Excel Knowledge — LiveJournal

http://vba-corner.livejournal.com/4623.html