Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-26 Thread sourav devrani
Yo man.hehe On Sat, Nov 26, 2016 at 11:27 AM, amar takale wrote: > Dear Sourav Sir > > Done! > > You are Rock Sir,Excellent Work. > > Many Many Thanks Again. > > Regards > Amar > > On Sat, Nov 26, 2016 at 11:08 AM, sourav devrani < > souravdevrani1...@gmail.com> wrote: >

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-25 Thread amar takale
Dear Sourav Sir Done! You are Rock Sir,Excellent Work. Many Many Thanks Again. Regards Amar On Sat, Nov 26, 2016 at 11:08 AM, sourav devrani < souravdevrani1...@gmail.com> wrote: > Create one txt file example > Test.txt then change Test.xml. > i don't know about excel 2003 please use it and

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-25 Thread sourav devrani
Create one txt file example Test.txt then change Test.xml. i don't know about excel 2003 please use it and let me know. i have sent you request on hangout accept it man On Sat, Nov 26, 2016 at 10:56 AM, amar takale wrote: > Dear Sourav > > Good morning > > but how can I

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-25 Thread amar takale
Dear Sourav Good morning but how can I create & save .xml file on desktop.I use excel 2003.Then where I create & how it possible. Regards Amar On Fri, Nov 25, 2016 at 4:03 PM, sourav devrani wrote: > keep one Xml file [image: Inline image 2] like this on your

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-25 Thread sourav devrani
keep one Xml file [image: Inline image 2] like this on your desktop and the use this tool and let me know if you need any changes. Xml file name will be "Test.xml" Do Formatting in Sheet2 hehe. On Fri, Nov 25, 2016 at 2:36 PM, amar takale wrote: > no > > On Fri, Nov 25,

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-25 Thread amar takale
no On Fri, Nov 25, 2016 at 11:15 AM, sourav devrani < souravdevrani1...@gmail.com> wrote: > Hi Amar any Progress > > On Fri, Nov 25, 2016 at 10:13 AM, amar takale > wrote: > >> ok >> >> >> On Fri, Nov 25, 2016 at 10:00 AM, sourav devrani < >> souravdevrani1...@gmail.com>

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-24 Thread sourav devrani
Hi Amar any Progress On Fri, Nov 25, 2016 at 10:13 AM, amar takale wrote: > ok > > > On Fri, Nov 25, 2016 at 10:00 AM, sourav devrani < > souravdevrani1...@gmail.com> wrote: > >> i'll create one macro for you. >> >> On Thu, Nov 24, 2016 at 11:41 PM, Kush Shama

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-24 Thread amar takale
ok On Fri, Nov 25, 2016 at 10:00 AM, sourav devrani < souravdevrani1...@gmail.com> wrote: > i'll create one macro for you. > > On Thu, Nov 24, 2016 at 11:41 PM, Kush Shama > wrote: > >> Bhai I have that excel sheet .will mail you as I get time. I create it >> whenever

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-24 Thread sourav devrani
i'll create one macro for you. On Thu, Nov 24, 2016 at 11:41 PM, Kush Shama wrote: > Bhai I have that excel sheet .will mail you as I get time. I create it > whenever i lose it. > On 24 Nov 2016 18:18, "amar takale" wrote: > >> how to it? >> >>

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-24 Thread Kush Shama
Bhai I have that excel sheet .will mail you as I get time. I create it whenever i lose it. On 24 Nov 2016 18:18, "amar takale" wrote: > how to it? > > On Thu, Nov 24, 2016 at 6:12 PM, sourav devrani < > souravdevrani1...@gmail.com> wrote: > >> Do one thing bro Scrap the

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-24 Thread amar takale
how to it? On Thu, Nov 24, 2016 at 6:12 PM, sourav devrani wrote: > Do one thing bro Scrap the data from Web. > > On Thu, Nov 24, 2016 at 6:09 PM, amar takale wrote: > >> See screen shot.If possible you also try why it show like that. >> >>

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-24 Thread sourav devrani
Do one thing bro Scrap the data from Web. On Thu, Nov 24, 2016 at 6:09 PM, amar takale wrote: > See screen shot.If possible you also try why it show like that. > > On Thu, Nov 24, 2016 at 12:47 PM, sourav devrani < > souravdevrani1...@gmail.com> wrote: > >> i think web

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-23 Thread sourav devrani
i think web data is not in the table thats why its coming like that way use web scrapping. On Wed, Nov 23, 2016 at 3:34 PM, amar takale wrote: > Dear Kush & Sourav > > I will try it import wizard but not success.{ls see see sheet how to > import data. > > Regards > Amar >

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-23 Thread amar takale
Dear Kush & Sourav I will try it import wizard but not success.{ls see see sheet how to import data. Regards Amar On Wed, Nov 23, 2016 at 11:37 AM, sourav devrani < souravdevrani1...@gmail.com> wrote: > in this case if you want to update data on every click you will have to > use web scrapping

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-22 Thread sourav devrani
in this case if you want to update data on every click you will have to use web scrapping and fetch data from web into excel and every Click of Button your data will be refreshed accordingly your web data. On Wed, Nov 23, 2016 at 11:26 AM, Kush Shama wrote: > Use

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-22 Thread Kush Shama
Use import wizard. Select web query and paste the link. On 18 Nov 2016 12:58, "amar takale" wrote: > I want update below link excel.All data show in excel like in website & > update data after click refresh button > > https://www.nse-india.com/live_market/dynaContent/live_

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-22 Thread amar takale
On Mon, Nov 21, 2016 at 10:00 AM, amar takale wrote: > Any experts help me on this issue? > > On Fri, Nov 18, 2016 at 12:57 PM, amar takale > wrote: > >> I want update below link excel.All data show in excel like in website & >> update data after

Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-20 Thread amar takale
Any experts help me on this issue? On Fri, Nov 18, 2016 at 12:57 PM, amar takale wrote: > I want update below link excel.All data show in excel like in website & > update data after click refresh button > > https://www.nse-india.com/live_market/dynaContent/live_ >

$$Excel-Macros$$ Required VBA Code update NSE website data in excel

2016-11-17 Thread amar takale
I want update below link excel.All data show in excel like in website & update data after click refresh button https://www.nse-india.com/live_market/dynaContent/live_watch/equities_stock_watch.htm Is it possible in excel Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And