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 import wizard. Select web query

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_ > watch/equities_stock_

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 click refresh button >> >> https://www.nse-india.

Re: $$Excel-Macros$$ macro to be edit

2016-11-22 Thread Paul Schreiner
It looks like it's a problem with your FieldInfo:= value. You have:FieldInfo:=Array(1, 1) when I recorded a macro, it used: FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1)), when I modified it to fit in your macro, it worked. although, I suspect you should change your logic.Sta

$$Excel-Macros$$ We are looking for a .Net developer at Norcross, GA

2016-11-22 Thread Sandeep Sam
Hi, Greetings from InsaSys..!! Following is the opening with one of our client based in the *Norcross, GA *. If you are available and interested please revert back with your updated resume so that we can discuss further. *Title: .Net Developer* *Location : Nor

Re: $$Excel-Macros$$ Accessing a function of another Workbook.

2016-11-22 Thread Eugene Bernard
Thank you Mr Paul. Regards Eugene On Mon, Nov 21, 2016 at 6:36 PM, Paul Schreiner wrote: > Yes: > > First, make sure the functions are defined as "public". > As in: > In Book1.xlsb: > Public Function Test_Calc(iVal) > Test_Calc = iVal + 10 > End Function > > In Book2, use: > =Book1.xlsb!Tes