Hi, In the below link I need to extract data by name i.e.*Chandra Shekar *in comments columns.
Thank you in advance. http://chandoo.org/wp/2010/01/27/pivot-table-tricks/ On Thu, Jul 28, 2011 at 8:32 AM, ashish koul <koul.ash...@gmail.com> wrote: > can you send me link and text you want to extract > > > On Thu, Jul 28, 2011 at 11:54 AM, Chandra Shekar < > chandrashekarb....@gmail.com> wrote: > >> Hi Ashish, >> >> Any solution for this. Thanks in advance. >> >> ---------- Forwarded message ---------- >> From: Chandra Shekar <chandrashekarb....@gmail.com> >> Date: Fri, Jul 22, 2011 at 1:21 PM >> Subject: Re: $$Excel-Macros$$ Extracting data from Website >> To: excel-macros@googlegroups.com >> >> >> Hi Asish, >> >> How to pull out particular lines or paragraphs in any site. Can we do this >> without using webquery method. Please let me know about this. >> >> Thanks, >> >> Chandra Shekar B >> >> On Fri, Jul 22, 2011 at 1:00 PM, Chandra Shekar < >> chandrashekarb....@gmail.com> wrote: >> >>> Thank u Ashish. I will check it out and come back to u If I have any >>> clarification. Thanks! >>> >>> >>> On Thu, Jul 21, 2011 at 3:07 PM, ashish koul <koul.ash...@gmail.com>wrote: >>> >>>> >>>> http://akoul.blogspot.com/2011/06/macro-to-import-data-from-webpage-to.html >>>> >>>> >>>> http://akoul.blogspot.com/2011/06/copy-data-of-webpage-to-excel-using.html >>>> >>>> >>>> http://akoul.blogspot.com/2011/06/macro-to-copy-text-from-webpage-to.html >>>> >>>> >>>> On Thu, Jul 21, 2011 at 6:30 PM, Chandra Shekar < >>>> chandrashekarb....@gmail.com> wrote: >>>> >>>>> Any link is ok. Just I need to learn how to do this task. Thanks. >>>>> >>>>> On Thu, Jul 21, 2011 at 2:15 PM, ashish koul <koul.ash...@gmail.com>wrote: >>>>> >>>>>> can you send the direct link >>>>>> >>>>>> >>>>>> On Thu, Jul 21, 2011 at 4:34 PM, Chandra Shekar < >>>>>> chandrashekarb....@gmail.com> wrote: >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> How to extract data from websites for ex: Yahoo News Columns. could >>>>>>> anyone provide VBA code for this. Thanks! >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> ---------------------------------------------------------------------------------- >>>>>>> Some important links for excel users: >>>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>>> http://twitter.com/exceldailytip >>>>>>> 2. Join our LinkedIN group @ >>>>>>> http://www.linkedin.com/groups?gid=1871310 >>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>>>> >>>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>>> >>>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>>> Like our page on facebook , Just follow below link >>>>>>> http://www.facebook.com/discussexcel >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> *Regards* >>>>>> * * >>>>>> *Ashish Koul* >>>>>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >>>>>> http://akoul.posterous.com/ >>>>>> *akoul*.wordpress.com <http://akoul.wordpress.com/> >>>>>> My Linkedin Profile<http://in.linkedin.com/pub/ashish-koul/10/400/830> >>>>>> >>>>>> >>>>>> P Before printing, think about the environment. >>>>>> >>>>>> >>>>>> -- >>>>>> >>>>>> ---------------------------------------------------------------------------------- >>>>>> Some important links for excel users: >>>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>>> http://twitter.com/exceldailytip >>>>>> 2. Join our LinkedIN group @ >>>>>> http://www.linkedin.com/groups?gid=1871310 >>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>>> >>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>> >>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>> Like our page on facebook , Just follow below link >>>>>> http://www.facebook.com/discussexcel >>>>>> >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Join our LinkedIN group @ >>>>> http://www.linkedin.com/groups?gid=1871310 >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> Like our page on facebook , Just follow below link >>>>> http://www.facebook.com/discussexcel >>>>> >>>> >>>> >>>> >>>> -- >>>> *Regards* >>>> * * >>>> *Ashish Koul* >>>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >>>> http://akoul.posterous.com/ >>>> *akoul*.wordpress.com <http://akoul.wordpress.com/> >>>> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> >>>> >>>> >>>> P Before printing, think about the environment. >>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel >>>> >>> >>> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > http://akoul.posterous.com/ > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > P Before printing, think about the environment. > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel