Re: $$Excel-Macros$$ query for getting external data from a website

2012-12-31 Thread Kenil Gala
: Dhaval Shah todhavals...@gmail.com Subject: Re: $$Excel-Macros$$ query for getting external data from a website To: excel-macros@googlegroups.com Cc: keni...@yahoo.com Date: Monday, December 31, 2012, 12:24 PM Kenil pls click the below mention link to download data of any eq series stocks

$$Excel-Macros$$ query for getting external data from a website

2012-12-30 Thread Kenil Gala
Hi, I want data of last 3months of a particular stock from a website. i have link of that website but dont know how to import it.i just want if i change just symbol of that particular script i get the data of that particular script i want. pls find the file attached for details.   Pls help

Re: $$Excel-Macros$$ query for getting external data from a website

2012-12-30 Thread Dhaval Shah
Kenil pls click the below mention link to download data of any eq series stocks www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012 *TCS*EQN.csv www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012RELIANCE **EQN.csv just u have to change the

Re: $$Excel-Macros$$ query for getting external data from a website

2012-12-30 Thread Anoop K Sharma
Hi Kenil, Make changes to below code as per your requirement. If you get stuck then let me know. *What you need to do:* -change cURL as per your required time period. -change the range and sheet. -change the query table. Public Const cURL =