How to get data from a website

[ThrottleWorks]

Sir I have to copy particular data from a website.

At present I have to copy the data manually.


I am trying to capture the data by vb but can not do it.

The data i am trying to capture is not in a table format.


I tried importing the data from Data -> From Web -> New Web Query


But excel gives me pre-defined selected options.

I am not able to select the data I want by using this option.


I am not allowed to share the link, sorry for inconvenience.


Can anyone please guide me on how the data can be fetched from the website.

 

[Debraj]

Hi Sachin,


I tried once..


http://chandoo.org/forums/topic/pull-a-web-page-link-from-website#post-37169


Check if you can adapt the same in your situation..


Regards,

Deb

 

[ThrottleWorks]

Thanks a lot Debraj Sir, I will try this and share the results, have a nice weekend.