Web Query in Excel

[Navin Agrawal]

Hi guys:

I am trying to create a web-query to open the following link in excel:

http://www.nseindia.com/live_market/...atch.htm?cat=N

Can someone help me with it? Its urgent....

Cheers,

[Dennis7849]

There is something that stop the normal web data access for this URL.

There is a workaround though.

That web page does allow DOWNLOAD as csv file. What I would do is;

In Firefox or IE, write a short iMacro to access and download the file.
Then use a VBA macro to open the csv file.

[AlvaroSiza]

I couldn't really follow how Dennis interpreted your original post, but if you really just need to open it, here you go:

Please Login or Register  to view this content.

Edit: Dennis' response does speak to 'open IN excel', while I have provided 'open FROM excel'.

[Navin Agrawal]

Thanks a lot.....

Can you help me with a sample excel sheet pls....

Secondly, I dont need to merely open the page, I want to create a web query using excel so that I can extract data and use it in my file....

Thanks & Cheers,

[Dennis7849]

To get the full data in a usable form, it should be "Downloaded As CSV". This can be done manually(you browsing and clicking on the buttons). Or it can be done in a semi-automated fashion using iMacros. For IE or Firefox, it is a good add-on. It is free.

The macro to navigate to the URL and "Downloaded As CSV" is

iMacro Code:

Please Login or Register  to view this content.

Then just open the csv file in excel. This can be done manually or with a macro.