Re: $$Excel-Macros$$ Re: Multiple Web Page Extraction

2014-07-18 Thread Bill Q
Maybe the trick would be to implement some sort of delay to allow it to load properly. On Wednesday, July 16, 2014 11:00:10 PM UTC-4, pramodb35 wrote: Hi Bill, The website is so heavy so it is taking lot of time to load .I am also working on it from another method. Regard

$$Excel-Macros$$ Re: Multiple Web Page Extraction

2014-07-16 Thread Bill Q
Pramod, Would you have any idea why it stops ? On Monday, July 14, 2014 7:16:58 AM UTC-4, Bill Q wrote: A great first effort Pramod. I called it up a few times. I always get the same 3 first lines returned - then I get the following error from your code and it stops: wk.Cells(i,

Re: $$Excel-Macros$$ Re: Multiple Web Page Extraction

2014-07-16 Thread Pramod Singh
Hi Bill, The website is so heavy so it is taking lot of time to load .I am also working on it from another method. Regard Pramod On Thu, Jul 17, 2014 at 7:23 AM, Bill Q ronsmith...@gmail.com wrote: Pramod, Would you have any idea why it stops ? On Monday, July 14, 2014 7:16:58 AM

$$Excel-Macros$$ Re: Multiple Web Page Extraction

2014-07-14 Thread Bill Q
A great first effort Pramod. I called it up a few times. I always get the same 3 first lines returned - then I get the following error from your code and it stops: wk.Cells(i, x).Value = TDelement.innertext Perhaps it has something to do with the amount of time that the site needs to load.