VBA Query to Download a CSV file and to import in the sheet

**sathis** · 07-04-2015, 12:24 AM

Hi,

Need web query in Excel for the below mentioned website.

http://www.nseindia.com/live_market/...tock_watch.htm

When executed with excel web query throws error

Thanks

Sathish

CSV Download.xlsm

**AB33** · 07-04-2015, 05:50 AM

I have corrected few errors, but unlikely to help you further as the site requires password ad user name.
You need to tick the box Microsoft HTML object Library in the tools-reference- before you run the code.

Please Login or Register  to view this content.

**sathis** · 07-04-2015, 08:41 AM

Hi,

Thanks for your reply.
Need to mention to add the "Microsoft Internet Controls" Library in the tools-reference.
As you mentioned it stuck at username and password.
Forget to mention the website haven't use username and password.
http://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm"
Any Insights

Sathish

**JasperD** · 07-04-2015, 10:05 AM

Assuming you want to get the table as displayed on the screen, then use the code below.
There's no way to just download the CSV from the document response as it is generated from a JSON object (as well as the table on the screen), so doing a simple webscrape won't work.
You have to get and process the json object, which is exactly what the code below does.

I advice you to paste this in an empty workbook.
Only reference you need to set is to Microsoft Script Control 1.0

Please Login or Register  to view this content.

as you know, noone gets paid on this site, so I'd appreciate it if you'd press the * below if this helps.
Enjoy!

**sathis** · 07-04-2015, 11:03 AM

Hi,

It Works , Thanks a lot.

I did (*) as you required.

Sathish

**JasperD** · 07-04-2015, 11:15 AM

Glad to hear.
Thanks for the rep.

Please mark this thread as solved.

VBA Query to Download a CSV file and to import in the sheet

LinkBack

Thread Tools

Rate This Thread

Display

VBA Query to Download a CSV file and to import in the sheet

Re: VBA Query to Download a CSV file and to import in the sheet

Re: VBA Query to Download a CSV file and to import in the sheet

Re: VBA Query to Download a CSV file and to import in the sheet

Re: VBA Query to Download a CSV file and to import in the sheet

Re: VBA Query to Download a CSV file and to import in the sheet

Thread Information

Users Browsing this Thread

Similar Threads

Download attachement from Outlook and import the content from multiple files into one file

Download .xls from web then import it in a sheet

Import text file via Query

File import - select file and import sheet(1) from closed workbook

macro to download file from FTP and import to excel

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions