$$Excel-Macros$$ Query.
Hi Experts, PLease solve my query. I need age betbeen in two dated like as 2 year 3 Month) -- Regards, Pramod Kumar Technocare Solution(TCS) Rudrapur +91 9927033573 E-Mail:-kumar.pramod03i...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Query.
Hi, PFA On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar kumar.pramod03i...@gmail.comwrote: Hi Experts, PLease solve my query. I need age betbeen in two dated like as 2 year 3 Month) -- Regards, Pramod Kumar Technocare Solution(TCS) Rudrapur +91 9927033573 E-Mail:-kumar.pramod03i...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Book1(1) -Solved.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Query.
Thanks... On Tue, May 1, 2012 at 12:25 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi, PFA On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar kumar.pramod03i...@gmail.com wrote: Hi Experts, PLease solve my query. I need age betbeen in two dated like as 2 year 3 Month) -- Regards, Pramod Kumar Technocare Solution(TCS) Rudrapur +91 9927033573 E-Mail:-kumar.pramod03i...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Pramod Kumar Technocare Solution(TCS) Rudrapur +91 9927033573 E-Mail:-kumar.pramod03i...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Custom functions not being performed on L39, but they are performed on L40-L42
Asa - thanks again. I am busy this morning revisiting, rewriting and retesting all of the code in my project after your suggestions. I strongly believe in good practice and I'm grateful to you for helping me to improve in this area. Best regards, Anil On Tuesday, April 24, 2012 11:12:56 AM UTC+1, Anil Pandit wrote: Hi all, I hope someone can help me, because I cannot see any reason why this isn't working. No action is taken for cell L39, however cells L40-L42 behave as expected. *Step 1: A value is changed in cell L39* Private Sub *Worksheet_Change*(ByVal Target As Range) Application.EnableEvents = False Application.ScreenUpdating = False ' Check if the specified cells have been changed and ' call the corresponding routine Select Case Target.Address Case $C$3 Call DisplayCabinetLayout Call ValidationType Case $C$4 Call ACDCLocked Call ValidationType Case $C$5 Call ApplicationType Case $C$8 To $C$9, _ $C$16 To $C$23, _ $C$27, _ $C$30 Call PositiveNumber(Target) Case $C$10 To $C$13, _ $C$26, _ $C$28 To $C$29, _ $C$31, _ $C$34 To $C$38, _ $C$41 To $C$45, _ $C$48 To $C$52, _ $F$3, _ $F$5 To $F$6, _ $F$11 To $F$12, _ $I$3, _ $I$5 To $I$6, _ $I$11 To $I$12, _ $L$3 To $L$4, _ $L$43 To $L$44 Call ValidationType Case $F$8 To $F$9, _ $I$8 To $I$9, _ *$L$39* To $L$42 Call ValidationType *Call EnclosureAdd(Target.Address)* Case Else Application.EnableEvents = True Exit Sub End Select Application.EnableEvents = True Application.ScreenUpdating = True End Sub *Step 2: The EnclosureAdd routine is called for cell L39* Sub EnclosureAdd(Rng As String) Dim PDU As String ' Extract the column and row Indices Col = Mid(Rng, 2, 1) Row = Mid(Rng, 4) PDU = Mid(Range(Col Row), 1, 5) CellValue = Range(Col Row) ' Use the column and row to add enclosures depending on whether ' Extra PDPs/PDUs are selected on sheet 1. Select Case Col Case Is = F Select Case Row Case Is = 8 Range(Col Row).Offset(1, 0) = CellValue Range(Col 16) = EN2Select(CellValue) Case Is = 9 Range(Col Row).Offset(-1, 0) = CellValue Range(Col 16) = EN2Select(CellValue) End Select Case Is = I Select Case Row Case Is = 8 Range(Col Row).Offset(1, 0) = CellValue Range(Col 24) = EN2Select(CellValue) Case Is = 9 Range(Col Row).Offset(-1, 0) = CellValue Range(Col 24) = EN2Select(CellValue) End Select *Case Is = L* Select Case Row *Case Is = 39* * Range(Col Row).Offset(1, 0) = PDUSelect(CellValue) Range(Col 9) = ENXSelect(CellValue)* Case Is = 40 Range(Col Row).Offset(-1, 0) = PDUSelect(CellValue) Range(Col 9) = ENXSelect(CellValue) Case Is = 41 Range(Col Row).Offset(1, 0) = PDUSelect(CellValue) Range(Col 19) = ENXSelect(CellValue) Case Is = 42 Range(Col Row).Offset(-1, 0) = PDUSelect(CellValue) Range(Col 19) = ENXSelect(CellValue) End Select End Select End Sub *Step 3: The **PDUSelect and ENXSelect Functions are called* *for cell L39* Function PDUSelect(CellValue) Dim PDU As String Dim n As String If CellValue Empty Slot Then ' Extract the string: PDU xn and toggle n.' PDU = Mid(CellValue, 1, 5) n = Mid(CellValue, 6, 1) If n = 1 Then n = 2 ElseIf n = 2 Then n = 1 End If PDUSelect = PDU n Else PDUSelect = Empty Slot End If End Function Function ENXSelect(CellValue) Const C1EN2AC As String = C7000 Enclosure (805-0540-G02) If Mid(CellValue, 1, 3) = PDU Then ENXSelect = C1EN2AC Else ENXSelect = Empty Slot End If End Function On Tuesday, April 24, 2012 11:12:56 AM UTC+1, Anil Pandit wrote: Hi all, I hope someone can help me, because I cannot see any reason why this isn't working. No action is taken for cell L39, however cells L40-L42 behave as expected. *Step 1: A value is changed in cell L39* Private Sub *Worksheet_Change*(ByVal Target As Range) Application.EnableEvents = False Application.ScreenUpdating = False ' Check if the specified cells have been
Re: $$Excel-Macros$$ Help required on how to create iterative formula
Dear David, Thanks for your response. Row 7 - d oth all is always a balancing number arrived on calculation. This is one of the place where it goes in circular reference The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is b+c+d x 4.75%. Which should it be? - I have changed this label. It was my mistake. Sorry for that. If row 19 is not meant to be zero, please explain how row 7 is meant to be calculated? Perhaps the value of row 19 should be provided? this is check build in. It should always be zero. If not , then there is some error in calculation Perhaps you could put in column H the results that you expect to get in column F - i have added output expected under both scenarios in revised file (attached) I have also mentioned how did i arrive at those results. Kindly help me with this.. Regards, Milin On Tue, May 1, 2012 at 10:59 AM, David Grugeon da...@grugeon.com.au wrote: In your spreadsheet d will always be a - all the other deductions therefore row 19 will always be zero. Is that what you wanted? If so you could replace all the row 19 formulas with 0 The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is b+c+d x 4.75%. Which should it be? If row 19 is not meant to be zero, please explain how row 7 is meant to be calculated? Perhaps the value of row 19 should be provided? It is not impossible but you need to rewrite the formulas so that iteration is not needed, otherwise you will get meaningless results. Perhaps you could put in column H the results that you expect to get in column F. On 1 May 2012 14:47, Milin Sulakhi milinsula...@gmail.com wrote: Dear All, Please at least let me know if it is not possible... Regards, Milin -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com iterative formual help.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Fixing the problem
Dear Friends, I want to put a formula in the attached sheet to calculate automatically as and when I change the periods., please help.. Rgds Dhanesh -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Book1.xlsx Description: Book1.xlsx
Re: $$Excel-Macros$$ Fixing the problem
Can you explain a bit more, like how it is and how it shud be with example On Tue, May 1, 2012 at 1:53 PM, Dhanesh Verma dhanesh.ve...@denonline.inwrote: Dear Friends, ** ** I want to put a formula in the attached sheet to calculate automatically as and when I change the periods., please help.. ** ** Rgds ** ** Dhanesh DISCLAIMER AND PRIVILEGE NOTICE : This e-mail and any files transmitted with it contain confidential, copyright, proprietary and legally privileged information. It should not be used by anyone who is not the original intended recipient. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you receive this transmission in error, please notify the sender by reply email and then destroy the message. Opinions, conclusions and other information in this message that do not relate to official business of DEN Networks Ltd., its subsidiaries, holding companies i.e. DEN shall be understood to be neither given nor endorsed by DEN. Internet communications cannot be guaranteed to be timely, Secure, error or virus-free. The sender does not accept liability for any errors or omissions. -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Fixing the problem
Hi Dhanesh, =SUMIFS(F3:R3,F2:R2,=B3,F2:R2,=C3) will total the periods whose date (as specified in row 2 -- appears to be month-ending date) falls between the specified dates in B3 and C3. =COUNTIFS(F2:R2,=B3,F2:R2,=C3) will count the number of periods that actually appear in the table and whose designated date falls within the date range. Hope this is useful to you. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dhanesh Verma Sent: Tuesday, May 01, 2012 1:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fixing the problem Dear Friends, I want to put a formula in the attached sheet to calculate automatically as and when I change the periods., please help.. Rgds Dhanesh DISCLAIMER AND PRIVILEGE NOTICE : This e-mail and any files transmitted with it contain confidential, copyright, proprietary and legally privileged information. It should not be used by anyone who is not the original intended recipient. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you receive this transmission in error, please notify the sender by reply email and then destroy the message. Opinions, conclusions and other information in this message that do not relate to official business of DEN Networks Ltd., its subsidiaries, holding companies i.e. DEN shall be understood to be neither given nor endorsed by DEN. Internet communications cannot be guaranteed to be timely, Secure, error or virus-free. The sender does not accept liability for any errors or omissions. -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file
DVD http://en.wikipedia.org/wiki/Optical_disc_drive A optical drive is essentially what you put CD's DVD's and install discs into Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Asa Rossoff Sent: Monday, April 30, 2012 8:44 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file Hi Pascal! Not sure what you mean by optical hard drive (HDs use electromagnetic heads). I have not had the chance to try your scripts, and I haven't relally played with Scripting.FileSystemObject, but some quick thoughts for you-- File locking and permissions are controlled by the OS and the limitations of the file system (NTFS/FAT32/ExFAT etc.). Unless the hardware is read-only or sequential-only (i.e. tape) I don't think it has any bearing. USB flash drives are usually formatted with FAT32, hard drives and solid-state drives aimed at Windows PCs are usually formatted with NTFS. NTFS supports many more nuances of file locking than FAT. FAT doesn't support file permissions at all. The real issue is most likely file locking issues you are running into on a FAT32 volume. Like I said, I am not versed in use of Scripting.FileSystemObject, but your working procedure appears to open the file once (when creating it) and your non-working procedure appears to open the file 3 or 4 times. Perhaps not the best way to write the code, but the following single change, just wildly guessing, may solve the issue: fs.CreateTextFile (Y:\test2.txt).Close 'Create a file ** and then close it ** OH, one other potential issue with your code is the constants (TriStateUseDefault, ForReading, ForWriting). Unless you set a reference to the scripting library (I think Microsoft Scripting Runtime), or define the constants in your code yourself, these will be undefined. Further, if you do have a reference to the library, for best performance, you should use early binding and declare your variables not as Variant (as you did by inference in your second procedure) or Object (as you did in your first procedure), but as the specific object type and then use the New keyword instead of CreateObject to create objects. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bpascal123 Sent: Monday, April 30, 2012 11:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file Hi cyberspace, I have 2 vba scripts with the same purpose, create and write to a text file. The 1st script works fine when creating and writing the file to my optical hard drive and doesn't work on my flash drive. The 2nd script works fine on both optical and flash drive. I wonder if the issue is not related to vba coding and Nand flash memory which requires a different read-write access to data in comparaison to classic optical hard drives. Can you confirm? 1st script works 1/2: Sub testy() Dim fs As Object, f As Object, ts As Object Dim s As String, sTxt As String, lastr As Long Set fs = CreateObject(Scripting.FileSystemObject) fs.CreateTextFile (Y:\test2.txt) 'Create a file Set f = fs.GetFile(test2.txt) Set ts = f.OpenAsTextStream(ForWriting, TristateUseDefault) ts.Write Hello World ts.Close Set ts = f.OpenAsTextStream(ForReading, TristateUseDefault) s = ts.ReadLine msgbox s ts.Close End Sub 2nd script, works OK : Sub testz() Dim fso, txtfile Set fso = CreateObject(Scripting.FileSystemObject) Set txtfile = fso.CreateTextFile(Y:\test1.txt, True) txtfile.Write (This is a test. ) ' Write a line. ' Write a line with a newline character. txtfile.WriteLine (Testing 1, 2, 3.) ' Write three newline characters to the file. txtfile.WriteBlankLines (3) txtfile.Close End Sub Thanks, Pascal -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula
Re: $$Excel-Macros$$ Re: Find column # of first value greater than specified value?
IF(SUMPRODUCT((B8:AE81)*B8:AE8)1,down,up) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Filip Houdek Sent: Monday, April 30, 2012 10:26 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Find column # of first value greater than specified value? Here is an example. I want to check row 8 (Price move) to see whether a value greater than 1 or less than -1 comes first, and return up or down in a specified cell based on which comes first (up if 1 comes first and down if -1 comes first). Eventually I want to check the next 30 values in row 8, starting from a cell to be determined, like an array re-defined to 30 columns to the right each time (I haven't gotten that far yet). Thanks! -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Multi Combo Box
Hello, I would like to have multi combo box on every row (1000 rows). Could you please help me out on this. Thanks in advance. Regards, Chandra Shekar B -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Combobox.xlsm Description: Binary data
RE: $$Excel-Macros$$ Multi Combo Box
HI Chandru, File size will be very larege with 1000 controlls on worksheet.. I suggest to use List Validation on each cell in your range Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: 01 May 2012 18:53 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Multi Combo Box Hello, I would like to have multi combo box on every row (1000 rows). Could you please help me out on this. Thanks in advance. Regards, Chandra Shekar B -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Multi Combo Box
No you would not like this Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Chandra Shekar Sent: Tuesday, May 01, 2012 8:22 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Multi Combo Box Hello, I would like to have multi combo box on every row (1000 rows). Could you please help me out on this. Thanks in advance. Regards, Chandra Shekar B -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file
Hi, I meant magnetic hard drive...based on the fact both are rotational and that myself I was looking for my glasses while writing this post :) , I mixed them up... Btw, from latest experiments (i wasn't part of it, i'm not a scientist nor do i know about it in detail), nothing travels faster than light, then how magnetic drives can be faster than optical drives...and applied to flash memory I think sooner or later RD will come back to optical storage maybe without rotation... Asa said it should be related to the file system (FAT32) and not the support itself... then I conclude the first code (code 1/2), doesn't support FAT32. exFat is the latest filesystem from Microsoft aims at flash storage devices. Pascal -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Multi Combo Box
Or, a double click macro if not intersect((.. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Rajan_Verma Sent: Tuesday, May 01, 2012 8:39 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Multi Combo Box HI Chandru, File size will be very larege with 1000 controlls on worksheet.. I suggest to use List Validation on each cell in your range Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: 01 May 2012 18:53 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Multi Combo Box Hello, I would like to have multi combo box on every row (1000 rows). Could you please help me out on this. Thanks in advance. Regards, Chandra Shekar B -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file
Hi Pascal, Actually, my feeling is that your code is leaving a file handle open unneccesarily and you are having a file sharing/locking violation on FAT32 volumes -- since you only need to have one file handle open at a time, your code should be correctable (unless VBSCRIPT has some strange bug). Interesting thought about optics. One issue with any reusable media is that it has to be physically changed to store information. Current optical media receive more destructive changes and require more energy for those changes than magnetic media. I imagine the death of removable optical media like CD/Blu Ray, and being replaced by centralized internet storage and next gen flash media. Transmission of data might be more and more wireless, or when wired, more and more fiber-optic. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bpascal123 Sent: Tuesday, May 01, 2012 6:42 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file Hi, I meant magnetic hard drive...based on the fact both are rotational and that myself I was looking for my glasses while writing this post :) , I mixed them up... Btw, from latest experiments (i wasn't part of it, i'm not a scientist nor do i know about it in detail), nothing travels faster than light, then how magnetic drives can be faster than optical drives...and applied to flash memory I think sooner or later RD will come back to optical storage maybe without rotation... Asa said it should be related to the file system (FAT32) and not the support itself... then I conclude the first code (code 1/2), doesn't support FAT32. exFat is the latest filesystem from Microsoft aims at flash storage devices. Pascal -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file
P.S. My comment about the constants may be important and relevant. The behavior of your code with undefined constants is quite possibly quite different than what your code appears to do. If you don't set a reference to the Scripting library, your constants will all be undefined. If you use OPTION EXPLICIT at the top of your module, you will ge a compile error if you try to use undefined constants/variables. Always a good idea. You can define the constants yourself, as the Excel help file examples do. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Tuesday, May 01, 2012 7:42 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file Hi Pascal, Actually, my feeling is that your code is leaving a file handle open unneccesarily and you are having a file sharing/locking violation on FAT32 volumes -- since you only need to have one file handle open at a time, your code should be correctable (unless VBSCRIPT has some strange bug). Interesting thought about optics. One issue with any reusable media is that it has to be physically changed to store information. Current optical media receive more destructive changes and require more energy for those changes than magnetic media. I imagine the death of removable optical media like CD/Blu Ray, and being replaced by centralized internet storage and next gen flash media. Transmission of data might be more and more wireless, or when wired, more and more fiber-optic. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of bpascal123 Sent: Tuesday, May 01, 2012 6:42 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file Hi, I meant magnetic hard drive...based on the fact both are rotational and that myself I was looking for my glasses while writing this post :) , I mixed them up... Btw, from latest experiments (i wasn't part of it, i'm not a scientist nor do i know about it in detail), nothing travels faster than light, then how magnetic drives can be faster than optical drives...and applied to flash memory I think sooner or later RD will come back to optical storage maybe without rotation... Asa said it should be related to the file system (FAT32) and not the support itself... then I conclude the first code (code 1/2), doesn't support FAT32. exFat is the latest filesystem from Microsoft aims at flash storage devices. Pascal -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any
Re: $$Excel-Macros$$ Need rank formula
plz resend file corrupted From: MURALI NAGARAJAN muralin...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, May 2, 2012 11:00 AM Subject: $$Excel-Macros$$ Need rank formula Dear experts. I need rank formula for attached file. Thanks in advance ThanksRegards Murali.N Chennai-- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com