Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
Yo man.hehe On Sat, Nov 26, 2016 at 11:27 AM, amar takalewrote: > 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 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 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 < >>> souravdevrani1...@gmail.com> wrote: >>> 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, 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> wrote: >>> i'll create one macro for you. On Thu, Nov 24, 2016 at 11:41 PM, Kush Shama < kushleshsha...@gmail.com> 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? >> >> On Thu, Nov 24, 2016 at 6:12 PM, sourav devrani < >> souravdevrani1...@gmail.com> wrote: >> >>> Do one thing bro Scrap the data from Web. >>> >>> On Thu, Nov 24, 2016 at 6:09 PM, amar takale < >>> amartak...@gmail.com> 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 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 < > amartak...@gmail.com> wrote: > >> 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 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 < >>> kushleshsha...@gmail.com> wrote: >>> 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_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 do you > wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook > page of this > forum @ https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread > titles, like Please Help, Urgent, Need Help, Formula Problem, > Code Problem, > and Need Advice will not get quick attention or may not be > answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing > any security measure.
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
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 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 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 < >> souravdevrani1...@gmail.com> wrote: >> >>> 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, 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> wrote: >> >>> i'll create one macro for you. >>> >>> On Thu, Nov 24, 2016 at 11:41 PM, Kush Shama < >>> kushleshsha...@gmail.com> 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? > > On Thu, Nov 24, 2016 at 6:12 PM, sourav devrani < > souravdevrani1...@gmail.com> wrote: > >> Do one thing bro Scrap the data from Web. >> >> On Thu, Nov 24, 2016 at 6:09 PM, amar takale < >> amartak...@gmail.com> 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 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 < amartak...@gmail.com> wrote: > 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 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 < >> kushleshsha...@gmail.com> wrote: >> >>> 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_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 do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed.
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
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 takalewrote: > 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 < > souravdevrani1...@gmail.com> wrote: > >> 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, 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> wrote: > >> i'll create one macro for you. >> >> On Thu, Nov 24, 2016 at 11:41 PM, Kush Shama < >> kushleshsha...@gmail.com> 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? On Thu, Nov 24, 2016 at 6:12 PM, sourav devrani < souravdevrani1...@gmail.com> 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. >> >> On Thu, Nov 24, 2016 at 12:47 PM, sourav devrani < >> souravdevrani1...@gmail.com> wrote: >> >>> 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 < >>> amartak...@gmail.com> wrote: >>> 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 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 < > kushleshsha...@gmail.com> wrote: > >> 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_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 do you >>> wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook >>> page of this >>> forum @ https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, >>> like Please Help, Urgent, Need Help, Formula Problem, Code >>> Problem, and >>> Need Advice will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any >>> security measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not >>> allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the >>> Google Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
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 devraniwrote: > 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, 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> 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 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 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 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 < >> amartak...@gmail.com> wrote: >> >>> 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 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 < kushleshsha...@gmail.com> wrote: > 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_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 do you >> wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page >> of this >> forum @ https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, >> like Please Help, Urgent, Need Help, Formula Problem, Code >> Problem, and >> Need Advice will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any >> security measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not >> allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the >> Google Groups "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from >> it, send an email to excel-macros+unsubscribe@googl >> egroups.com. >> To post to this group, send email to >> excel-macros@googlegroups.com. >> Visit this group at https://groups.google.com/grou >> p/excel-macros. >> For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
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 takalewrote: > 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> 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 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 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 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 >> >> 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 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 < >>> kushleshsha...@gmail.com> wrote: >>> 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_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 do you > wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page > of this > forum @ https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, > like Please Help, Urgent, Need Help, Formula Problem, Code > Problem, and > Need Advice will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any > security measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from > it, send an email to excel-macros+unsubscr...@googlegroups.com > . > To post to this group, send email to > excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/grou > p/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles,
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
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> 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 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 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 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 > > 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 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 < >> kushleshsha...@gmail.com> wrote: >> >>> 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_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 do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/grou p/excel-macros. For more options, visit https://groups.google.com/d/optout. >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna >>> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this >>> forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like >>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and >>> Need >>> Advice will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any >>> security measure. >>> 4) Acknowledge the responses you receive, good or bad.
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
Hi Amar any Progress On Fri, Nov 25, 2016 at 10:13 AM, amar takalewrote: > 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 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 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 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 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 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 < > kushleshsha...@gmail.com> wrote: > >> 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_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 do you wanna >>> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this >>> forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like >>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and >>> Need >>> Advice will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any >>> security measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum >>> owners and members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the >>> Google Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from >>> it, send an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to >>> excel-macros@googlegroups.com. >>> Visit this group at https://groups.google.com/group/excel-macros >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna >> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this >> forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like >> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and >> Need >> Advice will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any >> security measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum >> owners and members are not responsible for
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
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 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 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 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 >>> >>> 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 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 < kushleshsha...@gmail.com> wrote: > 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_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 do you wanna >> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this >> forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like >> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and >> Need >> Advice will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any >> security measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the >> Google Groups "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, >> send an email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to >> excel-macros@googlegroups.com. >> Visit this group at https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna > be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this > forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and > Need > Advice will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any > security measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google > Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, >
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
i'll create one macro for you. On Thu, Nov 24, 2016 at 11:41 PM, Kush Shamawrote: > 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 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 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 >> >> 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 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 < >>> kushleshsha...@gmail.com> wrote: >>> 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_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 do you wanna > be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this > forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and > Need > Advice will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any > security measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google > Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, > send an email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com > . > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros.
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
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 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 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 > > 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 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 < >> kushleshsha...@gmail.com> wrote: >> >>> 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_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 do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like >>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>> Advice will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>> and members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, >>> send an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at https://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
how to it? On Thu, Nov 24, 2016 at 6:12 PM, sourav devraniwrote: > 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 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 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 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 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_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 do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like >>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>> Advice will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>> and members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, >>> send an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at https://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like >> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >> Advice will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners >> and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google >> Groups "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, >> send an email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? > It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > 2) Don't post a
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
Do one thing bro Scrap the data from Web. On Thu, Nov 24, 2016 at 6:09 PM, amar takalewrote: > 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 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 >>> >>> 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 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 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_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 do you wanna be? >> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like >> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >> Advice will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners >> and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google >> Groups "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, >> send an email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? > It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners > and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google > Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed.
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
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 takalewrote: > 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 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 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_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 do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at https://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
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 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 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_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 do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at https://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
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 Shamawrote: > 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_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 do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
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_ > 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 do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
On Mon, Nov 21, 2016 at 10:00 AM, amar takalewrote: > 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_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 do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Required VBA Code update NSE website data in excel
Any experts help me on this issue? On Fri, Nov 18, 2016 at 12:57 PM, amar takalewrote: > 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 do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.