Re: $$Excel-Macros$$ extracting data from Website

2012-12-22 Thread ashish koul 
try these

http://www.dailydoseofexcel.com/archives/2006/11/29/html-tables/
http://vbadud.blogspot.in/2009/08/how-to-login-to-website-using-vba.html
http://www.tushar-mehta.com/publish_train/xl_vba_cases/vba_web_pages_services/index.htm



On Fri, Dec 21, 2012 at 2:10 PM, ganesh acharya
wrote:

> Hello Group,
>
>
> Is any VBA code is there where I can extract the data from website
> directly.
>
> Website is User and Password protected.
>
>
> Thanks
> Ganesh
>
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Extracting data from Website

2011-07-28 Thread Chandra Shekar 
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  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 
>> 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 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 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
>&g

Re: $$Excel-Macros$$ Extracting data from Website

2011-07-27 Thread ashish koul 
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 
> 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 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 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
>>>>>
>>>>> <><><><><><><><><><><><><><><><><><><><>

Re: $$Excel-Macros$$ Extracting data from Website

2011-07-22 Thread Chandra Shekar 
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 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 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.posterous.com/
 *akoul*.wordpress.com 
 My Linkedin Profile 


 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.posterous.com/
>> *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> 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 tr

Re: $$Excel-Macros$$ Extracting data from Website

2011-07-22 Thread Chandra Shekar 
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  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 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.posterous.com/
>>> *akoul*.wordpress.com 
>>> My Linkedin Profile 
>>>
>>>
>>> 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.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> 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

<><><><><><><><><><><><><><><><><><><><><>

Re: $$Excel-Macros$$ Extracting data from Website

2011-07-21 Thread ashish koul 
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 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.posterous.com/
>>  *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> 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.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


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

Re: $$Excel-Macros$$ Extracting data from Website

2011-07-21 Thread Chandra Shekar 
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  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.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> 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

Re: $$Excel-Macros$$ Extracting data from Website

2011-07-21 Thread ashish koul 
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.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


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