$$Excel-Macros$$ Re: Advanced conditional formatting
Dear Suresh, Attachment has been solved and re-attached. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 8/27/09, suresh k wrote: > > Sorry, > Now with attachment > > On Thu, Aug 27, 2009 at 8:23 PM, Dilip Pandey wrote: > >> Dear Suresh, I think you forgot to attach the file. Please re-attach and >> send. Thanks. >> -- >> DILIP KUMAR PANDEY >> MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> On Thu, Aug 27, 2009 at 8:17 PM, suresh k wrote: >> >>> Hi Dilip, >>> >>> Can you check this attachment. Its having three options "TRUE", "FALSE" >>> and "Not available. In this case is it possible to highlight entire rows in >>> different color based on the result. >>> >>> >>> >>> On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey wrote: >>> Hi Suresh. Attached file has the scenario and the explanation for your query. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Aug 27, 2009 at 4:51 PM, suresh k wrote: > Hi Guyz, > > Whenever we use conditional formatting it will be applied for current > cell only. > > Is there anyway that if the condition is true the entire row should be > colored??? > > Regards, > Suresh > > >>> >>> >> >> >> > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Condition Formattting - By DILipandey V1.1.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: help with Vloopup function
Test On Thu, Aug 27, 2009 at 1:17 PM, vivek agrawal wrote: > it prompts because it needs the SAP Records worksheet to be opened when it > executes the statement... > excel checks all the open workbooks and tries to find the workbook > referenced hence you need to keep the workbook open before executing the > sub procedure > > hope this helps > > Thanks and Regards, > Vivek Agrawal > Skype ID - vivek.agrawal83 > > GoogleMoonlight.com - Saving energy-Save Earth > > > > > > On Thu, Aug 27, 2009 at 12:44 PM, Sanjay Singh < > sanjaysingh294...@gmail.com> wrote: > >> Hi Everybody, >> >> Can you please help me with the below formula >> >> Thanks and Regards >> >> Sanjay Singh >> >> On Tue, Aug 25, 2009 at 12:44 PM, Sanjay Singh < >> sanjaysingh294...@gmail.com> wrote: >> >>> Hi Everybody, >>> >>> I need help with below Vlookup function in macro. >>> >>> Following is the code I am presently using >>> >>> ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[2],'[SAP >>> Codes.xls]Sheet1'!C2:C4,3,0)" >>> >>> But above formula prompts me every time to locate the SAP code worksheet. >>> Is there any way I can put the path of the worksheet itself in the above >>> formula so that it doesn't gives a prompt for file location each time >>> formulae is encountered. >>> >>> location of file is "D:\Profiles\sanjays2\My Documents\SAP Records" >>> >>> Thanks a lot for your help. >>> >>> Thanks and Regards >>> >>> Sanjay Singh >>> >> >> >> >> > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
Re: Fwd: $$Excel-Macros$$ Re: Fill In Rows - Efficiency Issue
Vivek, I wanted to thank you for this - it works much better than what I had written :P On Jul 21, 6:58 am, vivek agrawal wrote: > Regards, > Vivek Agrawal > Skype ID - vivek.agrawal83 > > GoogleMoonlight.com - Saving energy-Save Earth > > -- Forwarded message -- > From: vivek agrawal > Date: Tue, Jul 21, 2009 at 3:41 PM > Subject: Re: $$Excel-Macros$$ Re: Fill In Rows - Efficiency > IssueTo:excel-macros@googlegroups.com > > Hi Dustin > > I didnt go through your code but given below is the code which i feel does > the required work as u have depicted by the Before and After results. > > Hope it suffices.. > > All the best > > Regards, > Vivek Agrawal > Skype ID - vivek.agrawal83 > > GoogleMoonlight.com - Saving energy-Save Earth > > On Mon, Jul 20, 2009 at 10:22 PM, Dustin wrote: > > > No thoughts on this at all? > > > On Jul 2, 12:54 pm, Dustin wrote: > > > Hi Everyone! > > > > The following code works (not the best), but is inefficient, in my > > > opinion. It takes a few minutes to run, which is unacceptable. I am > > > looking for a re-think about how this can be done in order to make it > > > run faster. > > > > The code looks at a table that is in order chronologically, but not > > > consecutive. This portion of the code goes through and inserts rows > > > and the appropriate index in that row. > > > > For instance: > > > > Before the code runs, the table looks like this: > > > > Column: S T > > > ClientID Account > > > 2401 a > > > 2402 b > > > 2410 c > > > 2415 d > > > ... > > > > After the code runs: > > > > Column: S T > > > ClientID Account > > > 2401 a > > > 2402 b > > > 2403 > > > 2404 > > > 2405 > > > 2406 > > > 2407 > > > 2408 > > > 2409 > > > 2410 c > > > 2411 > > > 2412 > > > 2413 > > > 2414 > > > 2415 d > > > > > > > THE CODE: > > > > Sub fillInRows() > > > > Application.ScreenUpdating = False > > > > Windows("ConvertColumns2.xlsm").Activate > > > Sheets("Main").Select > > > Range("D2").Select > > > beginning = ActiveCell.Value > > > Range("E2").Select > > > ending = ActiveCell.Value > > > > Sheets("Output").Select > > > Range("S2").Select > > > Dim Count As Integer > > > Count = beginning > > > Dim rowCount As Integer > > > rowCount = 1 > > > Dim offs As Integer > > > offs = 1 > > > upperLimit = ending > > > > Total = Worksheets("Main").Range("E2").Value - Worksheets("Main").Range > > > ("D2").Value > > > current = 0 > > > > 'Check to see if the first cell is the beginning of the range... > > > If Range("S2") <> Worksheets("Main").Range("D2").Value Then > > > Range("S2").Select > > > Selection.EntireRow.Insert > > > ActiveCell.FormulaR1C1 = Worksheets("Main").Range("D2").Value > > > End If > > > > 'Check to see if the data is there... > > > If Range("S2") = "" Then 'If the first cell is empty, kill program > > > MsgBox "The first cell is empty... please enter raw data and re- > > > run macro" > > > End 'if it is the case that the first cell is empty, exit macro > > > End If > > > > 'Since the data is there, insert rows where needed... > > > If Range("S2") <> "" Then 'When the first cell is occupied, we are > > > ready to begin. > > > Do While (offs + 100) <= upperLimit > > > If ActiveCell.Offset(1).Value = (Count + offs) Then 'If > > > the next cell is one more than the previous cell, then.. > > > ActiveCell.Offset(1).Select 'go to the next cell in > > > the column > > > offs = offs + 1 'increase the offset from the top > > > > Else 'if the numbers are not in order... > > > ActiveCell.Offset(1).Select > > > Selection.EntireRow.Insert > > > ActiveCell.FormulaR1C1 = Worksheets("Main").Range > > > ("D2").Value + offs 'put the appropriate number in the new row > > > offs = offs + 1 'increase the offset value by 1 > > > 'MsgBox offs 'print the offset number for verification > > > End If > > > > current = current + 1 > > > numDone = current / Total > > > With UserForm1 > > > .FrameProgress.Caption = Format(numDone, current & "/" & > > > ending) > > > .LabelProgres
$$Excel-Macros$$ Re: Advanced conditional formatting
Hi Liuxin, This is because, when you use absolute reference ($ref$), conditional formatting logics on the entire row is checking if that particular reference is meeting the logics or not. Moreover, when you apply that logic towards right direction to cover entire row, the logic still checks only that particular reference, which is still meeting up with the criteria defined and hence, entire row gets colored. For more details, refer to the attachement which I just forwarded to Suresh and "Group". Let me know in case of any queries. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 8/27/09, liuxin9...@gmail.com wrote: > > > I have a question. > When I use the relative reference in the formula, there is only one > cell colored. > While if I use the absolute reference, the complete row is colored, > why? > > On 8月27日, 下午10时53分, Dilip Pandey wrote: > > Dear Suresh, I think you forgot to attach the file. Please re-attach > and > > send. Thanks. > > -- > > DILIP KUMAR PANDEY > > MBA-HR,B COM(Hons.),BCA > > Mobile: +91 9810929744 > > dilipan...@gmail.com > > dilipan...@yahoo.com > > New Delhi - 110062 > > > > > > > > On Thu, Aug 27, 2009 at 8:17 PM, suresh k > wrote: > > > Hi Dilip, > > > > > Can you check this attachment. Its having three options "TRUE", "FALSE" > and > > > "Not available. In this case is it possible to highlight entire rows in > > > different color based on the result. > > > > > On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey >wrote: > > > > >> Hi Suresh. > > > > >> Attached file has the scenario and the explanation for your > query. Thanks > > > > >> -- > > >> DILIP KUMAR PANDEY > > >> MBA-HR,B COM(Hons.),BCA > > >> Mobile: +91 9810929744 > > >> dilipan...@gmail.com > > >> dilipan...@yahoo.com > > >> New Delhi - 110062 > > > > >> On Thu, Aug 27, 2009 at 4:51 PM, suresh k > wrote: > > > > >>> Hi Guyz, > > > > >>> Whenever we use conditional formatting it will be applied for current > > >>> cell only. > > > > >>> Is there anyway that if the condition is true the entire row should > be > > >>> colored??? > > > > >>> Regards, > > >>> Suresh > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Circulare reference work around
I end up getting a circular reference when I try to code this I have certain reports that recur every 9 days, 16 days, 22 days, 43 days and 76 days respectively. Some of these are workdays and some of them are calendar days. I have a weekly report tracker that lets me track which report is due on a certain week. I want to automate the tracking. I am trying to do the following Today's date = getdate() =8/31/09 Report 1 =Getdate()+9 = 9/9/09 on the 9th Day update new Report1 due date = 9/18/09 • Add a column for Status = DONE/Pending • IF STATUS =DONE THEN { Update the report recurrence to next day based on recurrence frequency AND Append the report name/instance to a named history sheet’s last empty cell } ELSE Keep it Active even if the week changes till STATUS = Done. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need help on formula
Hi As per what you want... my answers are in red with yellow background The best way for what you want is that sort the column and then apply the formula in red with yellow... Hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Aug 27, 2009 at 7:15 PM, vinod rao wrote: > > Hello Vivek, > > Still it didn't work. if the number is repeating it should ranks the same > so it is right but the next largest number sequence is not correct. I have > sorted data to simplyfy my doubt. > For more details i have attached the file. now i believe you can understand > my problem much better. Thanks you in advance for your support. > > Awaiting your reply. > > > On Thu, Aug 27, 2009 at 9:38 AM, vivek agrawal > wrote: > >> Hi Vinod >> >> Attached is the file with the solution you want >> >> Thanks and Regards, >> Vivek Agrawal >> Skype ID - vivek.agrawal83 >> >> GoogleMoonlight.com - Saving energy-Save Earth >> >> >> >> >> On Wed, Aug 26, 2009 at 6:14 PM, vinod rao wrote: >> >>> Hello Expert Team, >>> >>> See the correct ranking that i want. I have attached file. >>> >>> Hope i have clarified my question. >>> Regards, >>> >>> On Wed, Aug 26, 2009 at 5:04 PM, vinod rao wrote: >>> Hello Vivek, See my file, I am unable to still trace right result. Row 599 has 15.2 value and it should result as 1 but it is showing 34. That is one of the example i am looking for. Regards, Vinod On Wed, Aug 26, 2009 at 4:37 PM, vinod rao wrote: > This will help.Thank you > > can you put formula without using Fcolumn, I want to findout the data > from E only because my workshee is restricted to add one more line.? any > suggestion on this plz. > On Wed, Aug 26, 2009 at 4:07 PM, vivek agrawal < > vivek.agrawa...@gmail.com> wrote: > >> Hope This Helps >> >> >> Thanks and Regards, >> Vivek Agrawal >> Skype ID - vivek.agrawal83 >> >> GoogleMoonlight.com - Saving energy-Save Earth >> >> >> >> >> On Wed, Aug 26, 2009 at 3:47 PM, vinod rao >> wrote: >> >>> Hello Vivek, >>> >>> I could not get the right answer. I need like >>> >>> Example >>> >>> Amount Rank >>> 200 3 >>> 100 2 >>> -50NA >>> 10 1 >>> -5 NA >>> 3004 >>> >>> Can you plz get it done in the new excel file?. Thanks Advance my >>> friend. >>> >>> On Wed, Aug 26, 2009 at 1:09 PM, vivek agrawal < >>> vivek.agrawa...@gmail.com> wrote: >>> The third argument of the RANK function specifies the ranking order Blank or "0" means ascending order any other positive number or "1" means the other way round Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 26, 2009 at 11:04 AM, vinod rao < vinod.ma...@gmail.com> wrote: > Thank you Very much. > > Can we have in reverse order, I mean low to high.? > Advance thanks to all members. > > Example > > Amount Rank > 200 4 > 1002 > -50NA > 10 1 > -5 NA > 300 4 > On Wed, Aug 26, 2009 at 9:48 AM, vivek agrawal < > vivek.agrawa...@gmail.com> wrote: > >> Hi >> >> attached is the solution to your query >> >> Hope it helps >> >> >> >> Thanks and Regards, >> Vivek Agrawal >> Skype ID - vivek.agrawal83 >> >> GoogleMoonlight.com - Saving energy-Save Earth >> >> >> >> >> On Tue, Aug 25, 2009 at 9:52 PM, vinod rao > > wrote: >> >>> Hello Team, >>> >>> How do i rank only positive numbers. Plz help me on formula. >>> >>> Example >>> >>> Amount Rank >>> 200 2 >>> 100 3 >>> -50NA >>> 10 4 >>> -5 NA >>> 3001 >>> >>> >>> >>> >> >> > > > >>> >>> >>> >> >> > >>> >>> >>> >> >> > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://ww
$$Excel-Macros$$ follow-up: saving macro-created objects
One of you requested that I post my macro code, so here it is. What this macro is supposed to be doing is populating comboboxes on another worksheet. It does that, but when I save and reopen the workbook they are no longer populated. I think I need to be doing something on a more global level, but I can't for the life of me figure out what. I'm a statistician by nature, not a programmer :) Many thanks to anyone who can help me out. Private Sub CommandButton3_Click() Sheet2.Include1.Value = False Sheet2.Include2.Value = False Sheet2.Include3.Value = False Sheet2.Include4.Value = False Sheet2.Include5.Value = False Sheet2.Include6.Value = False Sheet2.Att1_1.Clear Sheet2.Att1_2.Clear Sheet2.Att1_3.Clear Sheet2.Att1_4.Clear Sheet2.Att1_5.Clear Sheet2.Att1_6.Clear Sheet2.att2_1.Clear Sheet2.att2_2.Clear Sheet2.att2_3.Clear Sheet2.att2_4.Clear Sheet2.att2_5.Clear Sheet2.att2_6.Clear Sheet2.att3_1.Clear Sheet2.att3_2.Clear Sheet2.att3_3.Clear Sheet2.att3_4.Clear Sheet2.att3_5.Clear Sheet2.att3_6.Clear Sheet2.att4_1.Clear Sheet2.att4_2.Clear Sheet2.att4_3.Clear Sheet2.att4_4.Clear Sheet2.att4_5.Clear Sheet2.att4_6.Clear Sheet2.Att1_1.Value = "" Sheet2.Att1_2.Value = "" Sheet2.Att1_3.Value = "" Sheet2.Att1_4.Value = "" Sheet2.Att1_5.Value = "" Sheet2.Att1_6.Value = "" Sheet2.att2_1.Value = "" Sheet2.att2_2.Value = "" Sheet2.att2_3.Value = "" Sheet2.att2_4.Value = "" Sheet2.att2_5.Value = "" Sheet2.att2_6.Value = "" Sheet2.att3_1.Value = "" Sheet2.att3_2.Value = "" Sheet2.att3_3.Value = "" Sheet2.att3_4.Value = "" Sheet2.att3_5.Value = "" Sheet2.att3_6.Value = "" Sheet2.att4_1.Value = "" Sheet2.att4_2.Value = "" Sheet2.att4_3.Value = "" Sheet2.att4_4.Value = "" Sheet2.att4_5.Value = "" Sheet2.att4_6.Value = "" Dim a As Variant Dim b As Variant Dim c As Variant Dim d As Variant Dim e As Variant Dim f As Variant Dim g As Variant Dim h As Variant Dim i As Variant Dim j As Variant Dim k As Variant Dim l As Variant Dim m As Variant Dim n As Variant Dim o As Variant Dim p As Variant Dim q As Variant Dim r As Variant Dim s As Variant Dim t As Variant Dim u As Variant Dim v As Variant Dim w As Variant Dim x As Variant a = Range("b11") b = Range("b12") c = Range("b13") d = Range("b14") e = Range("b15") f = Range("b16") g = Range("b20") h = Range("b21") i = Range("b22") j = Range("b23") k = Range("b24") l = Range("b25") m = Range("b29") n = Range("b30") o = Range("b31") p = Range("b32") q = Range("b33") r = Range("b34") s = Range("b38") t = Range("b39") u = Range("b40") v = Range("b41") w = Range("b42") x = Range("b43") Sheet2.Att1_1.AddItem a Sheet2.Att1_1.AddItem b Sheet2.Att1_1.AddItem c Sheet2.Att1_1.AddItem d Sheet2.Att1_1.AddItem e Sheet2.Att1_1.AddItem f Sheet2.att2_1.AddItem g Sheet2.att2_1.AddItem h Sheet2.att2_1.AddItem i Sheet2.att2_1.AddItem j Sheet2.att2_1.AddItem k Sheet2.att2_1.AddItem l Sheet2.att3_1.AddItem m Sheet2.att3_1.AddItem n Sheet2.att3_1.AddItem o Sheet2.att3_1.AddItem p Sheet2.att3_1.AddItem q Sheet2.att3_1.AddItem r Sheet2.att4_1.AddItem s Sheet2.att4_1.AddItem t Sheet2.att4_1.AddItem u Sheet2.att4_1.AddItem v Sheet2.att4_1.AddItem w Sheet2.att4_1.AddItem x Sheet2.Att1_2.AddItem a Sheet2.Att1_2.AddItem b Sheet2.Att1_2.AddItem c Sheet2.Att1_2.AddItem d Sheet2.Att1_2.AddItem e Sheet2.Att1_2.AddItem f Sheet2.att2_2.AddItem g Sheet2.att2_2.AddItem h Sheet2.att2_2.AddItem i Sheet2.att2_2.AddItem j Sheet2.att2_2.AddItem k Sheet2.att2_2.AddItem l Sheet2.att3_2.AddItem m Sheet2.att3_2.AddItem n Sheet2.att3_2.AddItem o Sheet2.att3_2.AddItem p Sheet2.att3_2.AddItem q Sheet2.att3_2.AddItem r Sheet2.att4_2.AddItem s Sheet2.att4_2.AddItem t Sheet2.att4_2.AddItem u Sheet2.att4_2.AddItem v Sheet2.att4_2.AddItem w Sheet2.att4_2.AddItem x Sheet2.Att1_3.AddItem a Sheet2.Att1_3.AddItem b Sheet2.Att1_3.AddItem c Sheet2.Att1_3.AddItem d Sheet2.Att1_3.AddItem e Sheet2.Att1_3.AddItem f Sheet2.att2_3.AddItem g Sheet2.att2_3.AddItem h Sheet2.att2_3.AddItem i Sheet2.att2_3.AddItem j Sheet2.att2_3.AddItem k Sheet2.att2_3.AddItem l Sheet2.att3_3.AddItem m Sheet2.att3_3.AddItem n Sheet2.att3_3.AddItem o Sheet2.att3_3.AddItem p Sheet2.att3_3.AddItem q Sheet2.att3_3.AddItem r Sheet2.att4_3.AddItem s Sheet2.att4_3.AddItem t Sheet2.att4_3.AddItem u Sheet2.att4_3.AddItem v Sheet2.att4_3.AddItem w Sheet2.att4_3.AddItem x Sheet2.Att1_4.AddItem a Sheet2.Att1_4.AddItem b Sheet2.Att1_4.AddItem c Sheet2.Att1_4.AddItem d Sheet2.Att1_4.AddItem e Sheet2.Att1_4.AddItem f Sheet2.att2_4.AddItem g Sheet2.att2_4.AddItem h Sh
$$Excel-Macros$$ Re: Advanced conditional formatting
Hi Dilip, Can you check this attachment. Its having three options "TRUE", "FALSE" and "Not available. In this case is it possible to highlight entire rows in different color based on the result. On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey wrote: > Hi Suresh. > > Attached file has the scenario and the explanation for your query. Thanks > > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On Thu, Aug 27, 2009 at 4:51 PM, suresh k wrote: > >> Hi Guyz, >> >> Whenever we use conditional formatting it will be applied for current cell >> only. >> >> Is there anyway that if the condition is true the entire row should be >> colored??? >> >> Regards, >> Suresh >> >> > > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Application TimeValue
This might be helpful. http://www.cpearson.com/excel/TimedClose.htm Norman On Thu, Aug 27, 2009 at 7:50 AM, Jack wrote: > > i need some vb to check if the time is greater than eg IF Application > TimeValue > ("08:00:30") Then > activeworkbook.close > > Any ideas > > Many thanks > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ download yahoo stock historical data into excel automatically
i would like to have a list say of 50 stocks defined either within the macro or in a column, and then i would like to pull the data from yahoo. currently the way im doing this is: cell1=http://ichart.finance.yahoo.com/table.csv?s= cell2=ERY <-- stock symbol cell3= &a=00&b=1&c=2009&d=… then cell 4= cell1&cell2&cell3 then i click on cell4 for each stock and then i have a macro copy and paste the data i want to a new sheet. i would like to avoid the clicking and just enter the symbol and download the historical data... note: im not as interested in the latest price as the historical prices. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Advanced conditional formatting
Suresh, This might help you http://www.mrexcel.com/hof001.php Norman On Thu, Aug 27, 2009 at 7:21 AM, suresh k wrote: > Hi Guyz, > > Whenever we use conditional formatting it will be applied for current cell > only. > > Is there anyway that if the condition is true the entire row should be > colored??? > > Regards, > Suresh > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ refresh pivot tables and autofit visible Columns of pivot tables from different sheets
Hi all, I am working on a report with many pivot tables in different worksheets. Request your help in: 1. Refresh all the pivot tables of all the sheets. 2. Autofit all the colums of the pivot table( Column fields, datafields and rowfields) Would really appreciate you help in this matter. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ what is wrong with this application.average equation?
Dim i, j, k As Integer For j = 9 To 500 For i = 1 To 200 ActiveCell(i, 0).Value = Application.WorksheetFunction.Average (Range("r[-i]c[j+5]:r[2000]c[j+5]")) Next i Next j im guessing its pretty straight forward --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Advanced conditional formatting
I have a question. When I use the relative reference in the formula, there is only one cell colored. While if I use the absolute reference, the complete row is colored, why? On 8月27日, 下午10时53分, Dilip Pandey wrote: > Dear Suresh, I think you forgot to attach the file. Please re-attach and > send. Thanks. > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > > On Thu, Aug 27, 2009 at 8:17 PM, suresh k wrote: > > Hi Dilip, > > > Can you check this attachment. Its having three options "TRUE", "FALSE" and > > "Not available. In this case is it possible to highlight entire rows in > > different color based on the result. > > > On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey wrote: > > >> Hi Suresh. > > >> Attached file has the scenario and the explanation for your query. Thanks > > >> -- > >> DILIP KUMAR PANDEY > >> MBA-HR,B COM(Hons.),BCA > >> Mobile: +91 9810929744 > >> dilipan...@gmail.com > >> dilipan...@yahoo.com > >> New Delhi - 110062 > > >> On Thu, Aug 27, 2009 at 4:51 PM, suresh k wrote: > > >>> Hi Guyz, > > >>> Whenever we use conditional formatting it will be applied for current > >>> cell only. > > >>> Is there anyway that if the condition is true the entire row should be > >>> colored??? > > >>> Regards, > >>> Suresh --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Advanced conditional formatting
Dear Suresh, I think you forgot to attach the file. Please re-attach and send. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Aug 27, 2009 at 8:17 PM, suresh k wrote: > Hi Dilip, > > Can you check this attachment. Its having three options "TRUE", "FALSE" and > "Not available. In this case is it possible to highlight entire rows in > different color based on the result. > > > > On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey wrote: > >> Hi Suresh. >> >> Attached file has the scenario and the explanation for your query. Thanks >> >> -- >> DILIP KUMAR PANDEY >> MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> On Thu, Aug 27, 2009 at 4:51 PM, suresh k wrote: >> >>> Hi Guyz, >>> >>> Whenever we use conditional formatting it will be applied for current >>> cell only. >>> >>> Is there anyway that if the condition is true the entire row should be >>> colored??? >>> >>> Regards, >>> Suresh >>> >>> >> >> >> >> >> > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Application TimeValue
What "format" is your time (TimeValue)? Where are you getting it? Keep in mind that in an Excel worksheet, a cell may LOOK like time but it really isn't. It is a numeric value that represents a fraction of a day for instance: What you SEE as 8:00:27 is actually .3336458333 Or it COULD be 40052.3336458333 which is TODAY at 8:00:27 (8/27/2009 8:00:27) Also I wouldn't recommend using "TimeValue" as the name of a variable, since it is also a FUNCTION. The trick is that you ahve to get the two things you're comparing into the same 'units'. You could try: Sub chktime() Dim tval, tval2 tval = Range("A1").Value tval2 = TimeValue("08:00:30") If (tval < tval2) Then Debug.Print Format(tval, "h:mm:ss AMPM") & " < " & tval2 Else Debug.Print Format(tval, "h:mm:ss AMPM") & " > " & tval2 End If End Sub Now, if the field also has the DATE as well as time, then I'd recommend looking at the DateDiff function. hope this helps. paul From: Jack To: MS EXCEL AND VBA MACROS Sent: Thursday, August 27, 2009 7:50:57 AM Subject: $$Excel-Macros$$ Application TimeValue i need some vb to check if the time is greater than eg IF Application TimeValue > ("08:00:30") Then activeworkbook.close Any ideas Many thanks --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Application TimeValue
i need some vb to check if the time is greater than eg IF Application TimeValue > ("08:00:30") Then activeworkbook.close Any ideas Many thanks --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Advanced conditional formatting
Hi Suresh. Attached file has the scenario and the explanation for your query. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Aug 27, 2009 at 4:51 PM, suresh k wrote: > Hi Guyz, > > Whenever we use conditional formatting it will be applied for current cell > only. > > Is there anyway that if the condition is true the entire row should be > colored??? > > Regards, > Suresh > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Condition Formattting - By DILipandey.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Macros problem in office 2007
You could hide all sheets and set password protection. then, in the VBA macros, unprotect the sheets. Set Password protection on your VBA code. then, the ONLY Way for the user to see the sheets is for the macros to be turned on. You could create a cover sheet that tells the user to turn on macros, perhaps gives instructions on how to do so. In the startup macro (Workbook_Open or Auto_Open), you would select the appropriate sheet and the user doesn't have to see the cover. BTW... the macros being set to 'disabled' isn't necessarily a Microsoft issue. It's YOUR COMPANY's DECISION (or system Administrator's decision) to deploy it with these settings. however, now that it's deployed, the decision is done and not easily fixed automatically! hope this helps. paul From: Hemant Kalia To: excel-macros@googlegroups.com Sent: Thursday, August 27, 2009 7:13:21 AM Subject: $$Excel-Macros$$ Macros problem in office 2007 Hi Friends i recently started using Office 2007 and it seems that this version of office is simply not pro Macros I use a excel file that has a macro in it. The file had multiple sheets and each sheet is relevant to a specific person. the macro links the computer user name ( the one with which you log in ) and checks for authorisation set in the macro. So if i have mentioned Mr A in the Macro then when he receives the file in mail and opens it he can only see sheet A ( he cannot copy the data , or modify it or add new sheets to the file etc. if Mr Z open the file he sees only sheet z the rest of the data remains hidden and cannot be opened unless you open the file on a computer logges in with a specific user name. Now the problem is that in office 2007 the default settings are of Macro being disabled. So if the file is sent to a person with office 2007 , then he has access to all the data. I have tried most options, ( added digital certificate to the file etc) . Its not possible for me to call all associates and ask them to turn on their macro in office 2007. I would like to know if anyone has any ideas on this - essentially i want to send multiple sheets but or file but i want to set user authorisations in it. pls refer to screenshots. If anyone has any solution , pls help me. i tried going to properties of the file and tried modifying the security permissions - but the security works only on the creators computer - on sending by mail it fails. i have already checked the Information Rights management available for Microsoft exchange. pls see links below - if anyone has used it pls guide me. http://office.microsoft.com/en-us/help/HA101029181033.aspx?pid=CL100605171033 http://office.microsoft.com/en-us/outlook/HA011801361033.aspx -- Regards Hemant Kalia --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Combine multiple ranges using R1C1
Hi guys, thanks a lot for your help. That's exactly what I wanted! Regards, Epi On 27 Aug., 06:39, Dave Bonallack wrote: > Hi Epi, > > One way is to use the Union thingy > > Union(Range(Cells(1, 1), Cells(2, 2)), Range(Cells(3, 3), Cells(4, 4))).Name > = "RangeName" > > Regards - Dave > > > > > > > Date: Wed, 26 Aug 2009 18:14:05 -0700 > > Subject: $$Excel-Macros$$ Combine multiple ranges using R1C1 > > From: epi_cen...@hotmail.com > > To: excel-macros@googlegroups.com > > > Hello group, > > after spending hours on the web searching for an answer i resort to > > you with my "noob"-question: > > How do I combine separated ranges of a worksheet like > > Range("A1:B2, C3:D4").Name = "RangeName" > > using R1C1 references as in (pseudocode) > > Range(Cells(1,1):Cells(2,2), Cells(3,3):Cells(4,4)).Name = "RangeName" > > Your knowledge and help is appreciated very much! > > Cheers, Epi > > _ > What goes online, stays online Check the daily blob for the latest on what's > happening around the webhttp://windowslive.ninemsn.com.au/blog.aspx- > Zitierten Text ausblenden - > > - Zitierten Text anzeigen - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Advanced conditional formatting
Hi Guyz, Whenever we use conditional formatting it will be applied for current cell only. Is there anyway that if the condition is true the entire row should be colored??? Regards, Suresh --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Linking to Reuters market data in vba
Hi I am using vba and Reuter data everyday. I didn't get your question that clearly. normally I would use =RtGet("IDN",RIC,FieldName) to get live market data. I've never use application.evaluate(RIC) ...what is for? On Thu, Aug 27, 2009 at 10:15 AM, thedoc wrote: > > Hi, > I'm looking for a way to link to Reuters live market data in vba. > > Doing this from a workbook is relatively straightforward, however I > don't want any links in my spreadsheet as this slows things down > considerably. > > Currently, I'm using the following vba code: > > Application.Evaluate ("Reuters Code") > > where "Reuters Code" represents the reuters code (RIC) for the > specific market data I'm interested in. > > However, this doesn't always work, so I'm looking for a more direct > and efficient way to do this. > > Any Thoughts? > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Atlast got it
Thanks Vidyut..!! Your second query is also solved and the spreadsheet containing solution is attached herewith. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Aug 27, 2009 at 12:03 PM, vidyut more wrote: > Hi Dilip > at last i got how to paly sumproduct formula. thanks very much. i have > new query for you. I enter party biil in excel . iwant to restrict > duplicate Bill entry. one way i know is countif formula in data > validation. but it wont distingwish between party. help please > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Duplicates - by DILipandey.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Thanks For ur reply
Thanks Vidyut...!!! SumProduct formula will work in Excel 2003. But SumIFs will work only on Excel 2007. For better understanding of availability of the function in different functions, try Microsoft Site or google. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Aug 27, 2009 at 11:02 AM, vidyut more wrote: > Hi > Thanks for ur reply. I am using excel 2003. Does it need (Sumprodcut) > Excel 2007. > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Linking to Reuters market data in vba
Hi, I'm looking for a way to link to Reuters live market data in vba. Doing this from a workbook is relatively straightforward, however I don't want any links in my spreadsheet as this slows things down considerably. Currently, I'm using the following vba code: Application.Evaluate ("Reuters Code") where "Reuters Code" represents the reuters code (RIC) for the specific market data I'm interested in. However, this doesn't always work, so I'm looking for a more direct and efficient way to do this. Any Thoughts? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: help with Vloopup function
it prompts because it needs the SAP Records worksheet to be opened when it executes the statement... excel checks all the open workbooks and tries to find the workbook referenced hence you need to keep the workbook open before executing the sub procedure hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Aug 27, 2009 at 12:44 PM, Sanjay Singh wrote: > Hi Everybody, > > Can you please help me with the below formula > > Thanks and Regards > > Sanjay Singh > > On Tue, Aug 25, 2009 at 12:44 PM, Sanjay Singh < > sanjaysingh294...@gmail.com> wrote: > >> Hi Everybody, >> >> I need help with below Vlookup function in macro. >> >> Following is the code I am presently using >> >> ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[2],'[SAP >> Codes.xls]Sheet1'!C2:C4,3,0)" >> >> But above formula prompts me every time to locate the SAP code worksheet. >> Is there any way I can put the path of the worksheet itself in the above >> formula so that it doesn't gives a prompt for file location each time >> formulae is encountered. >> >> location of file is "D:\Profiles\sanjays2\My Documents\SAP Records" >> >> Thanks a lot for your help. >> >> Thanks and Regards >> >> Sanjay Singh >> > > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: help with Vloopup function
Hi Everybody, Can you please help me with the below formula Thanks and Regards Sanjay Singh On Tue, Aug 25, 2009 at 12:44 PM, Sanjay Singh wrote: > Hi Everybody, > > I need help with below Vlookup function in macro. > > Following is the code I am presently using > > ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[2],'[SAP > Codes.xls]Sheet1'!C2:C4,3,0)" > > But above formula prompts me every time to locate the SAP code worksheet. > Is there any way I can put the path of the worksheet itself in the above > formula so that it doesn't gives a prompt for file location each time > formulae is encountered. > > location of file is "D:\Profiles\sanjays2\My Documents\SAP Records" > > Thanks a lot for your help. > > Thanks and Regards > > Sanjay Singh > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---