$$Excel-Macros$$ Stock prices data fetching through VBA

2013-09-16 Thread Murali prasad
im trying to get the prices data from chartsapi.finance.yahoo.com to excel... by giving the inputs like -- scrip name, date from, date to, time frame, by which the url is developed based on inputs and get data to excel... output as below: date--time--open price--high price--low price--close

Re: $$Excel-Macros$$ Need Formula

2013-09-16 Thread अनिल नारायण गवली
Dear Prabhu, Pl see the attached sheet. Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Tue, Sep 17, 2013 at 10:22 AM, Prabhu Pinky wrote: > Hi Experts, > > Please find the attached file, please revert with appropriate form

$$Excel-Macros$$ Need Formula

2013-09-16 Thread Prabhu Pinky
Hi Experts, Please find the attached file, please revert with appropriate formula for my requirement Thanks & Regards, Prabhu R -- 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.c

$$Excel-Macros$$ Macro File Saving Restriction

2013-09-16 Thread pankajinfo
Dear All, As you all know if a .xlsm or .xlsb file is saved under .xlsx or non-macro enabled file extension in those files macros do not work or visible. So i want to make a restriction in macro enabled files .xlsm or .xlsb that they cannot be saved under non-macro enabled file extension. Is it p

Re: $$Excel-Macros$$ RecordSet ADO get the 20th record

2013-09-16 Thread Anoop K Sharma
Make a query as "Select Top 20 From " in case you need a 20th record without changing your records order. but if you want the 20th record after sorting your data in ascending order then make following query "Select Top 20 From order by " In case you need the 20th record after sorting data in des

Re: $$Excel-Macros$$ macro for required data please find the attachment once

2013-09-16 Thread De Premor
Here i'am using Multidimension array to get faster result This will little longer in code, but will much faster then Direct Manipulation Data using For Each ... in Range... Next (Loop) And then... Here we go... Sub Convert() Dim Data, Hasil, LCount As Long, LRow As Long, iCol As Integer

$$Excel-Macros$$ How to do polynomial curve fitting with macro in excel?

2013-09-16 Thread Lingjun Meng
Hi guys, This is my first post in this group. It is great that there is such a group! What I want to do right now is like this: Say, I have four columns of data, Column A, B, C and D, the latter three depend on Column A, there are 4 rows in each column I want to do

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-16 Thread shraddha malvankar
Yes On 16 Sep 2013 20:12, "ashish koul" wrote: > do u want to replace the exiting info on Tracker from Daily Report tab > > > On Mon, Sep 16, 2013 at 5:44 PM, shraddha malvankar < > shraddhamalvan...@gmail.com> wrote: > >> Hi, >> >> I am really new in macro, can you please help me in attached exc

$$Excel-Macros$$ macro for required data please find the attachment once

2013-09-16 Thread Renukachari Kasee
Dear experts. please solve my query its very very urgent macro for required data please find the attachment once thanks *(¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!! `•.¸.•´ Thanks & Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-16 Thread ashish koul
do u want to replace the exiting info on Tracker from Daily Report tab On Mon, Sep 16, 2013 at 5:44 PM, shraddha malvankar < shraddhamalvan...@gmail.com> wrote: > Hi, > > I am really new in macro, can you please help me in attached excel as well > L I tired the same principle which you sent me l

Re: $$Excel-Macros$$ how to connect with accdb database from excel

2013-09-16 Thread Anshul Arora
Hi , can you please mail me the excel file .I am also trying to connect excel with password protected accdb database but unable to do it. It will show error message "Invalid Password".It will be a great help On Mon, Aug 29, 2011 at 9:40 AM, NOORAIN ANSARI wrote: > Dear Dario, > > See below link

Re: $$Excel-Macros$$ Copy Past Macro help

2013-09-16 Thread shraddha malvankar
Hi, I am really new in macro, can you please help me in attached excel as well LI tired the same principle which you sent me last time. I have my entire report in tracker file which I send to team and they sent me update daily in Daily report sheet. But they only work on few line items Now I wan

Re: $$Excel-Macros$$ Query on vlookup

2013-09-16 Thread johnson john
Dear Shrinivas, Index - Match function will be the solution for your problem. Pls. see the attachment. thanks JOhnson On Mon, Sep 16, 2013 at 10:21 AM, अनिल नारायण गवली wrote: > Dear Shrinivas, > > u can also use =VLOOKUP(F3,A3:E13,COLUMNS(A3:E3),0) > > Warm Regards, > Gawli Anil > Thanks & R