$$Excel-Macros$$ Excel - Array Help
Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- 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$$ Excel - Array Help
Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) * see attached sheet.. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.comwrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- 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 Amar(Solution).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Excel - Array Help
Hi Noorain, Thank you for these formulaes. but I'm actually using VBA macro's to do a task it'll be really great if you could let me know in VBA. Here is my current code, I don't know I'm not able to highlight the duplicates. Sub Test1() For J1 = 10 To 500 If Cells(J1, 1).Value = XYZ And Cells(J1 + 1, 2) = ABC Then J1 = J1 + 1 For k = 1 To 7 If Cells(J1 + k, 2).Value = Key Then For Each i In Range(C:C) If i.Value = Cells(J1, 3).Value Then Count = Count + 1 If Count = 1 Then Cells(J1 + k, 3).Interior.color = 65535 'MsgBox Amar 'Cells(J1 + l + 1, 3).Interior.color = 65535 + 2000 End If Next i End If Next k If Count = 1 Then MsgBox Duplicates are there, please check End If End Sub On 19/01/2012, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) * see attached sheet.. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.comwrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- 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 Duplicates_Identification.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Excel - Array Help
Dear Amar, Please try it.. Sub Find_Duplicate_Entry() Dim cel As Variant Dim myrng As Range Set myrng = Range(C2:C Range(C65536).End(xlUp).Row) myrng.Interior.ColorIndex = xlNone For Each cel In myrng clr = 10 If Application.WorksheetFunction.CountIf(myrng, cel) 1 Then cel.Interior.ColorIndex = 10 + clr clr = clr + 10 End If Next End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:59 PM, Kasireddy Amarender kassi.re...@gmail.comwrote: Hi Noorain, Thank you for these formulaes. but I'm actually using VBA macro's to do a task it'll be really great if you could let me know in VBA. Here is my current code, I don't know I'm not able to highlight the duplicates. Sub Test1() For J1 = 10 To 500 If Cells(J1, 1).Value = XYZ And Cells(J1 + 1, 2) = ABC Then J1 = J1 + 1 For k = 1 To 7 If Cells(J1 + k, 2).Value = Key Then For Each i In Range(C:C) If i.Value = Cells(J1, 3).Value Then Count = Count + 1 If Count = 1 Then Cells(J1 + k, 3).Interior.color = 65535 'MsgBox Amar 'Cells(J1 + l + 1, 3).Interior.color = 65535 + 2000 End If Next i End If Next k If Count = 1 Then MsgBox Duplicates are there, please check End If End Sub On 19/01/2012, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) * see attached sheet.. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.comwrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- 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
Re: $$Excel-Macros$$ Excel - Array Help
Hi Noorain, Thank you for the code, I think I'm getting some clue for my code, I'll try and let you know, thanks again. Best regards, Amar On 19/01/2012, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amar, Please try it.. Sub Find_Duplicate_Entry() Dim cel As Variant Dim myrng As Range Set myrng = Range(C2:C Range(C65536).End(xlUp).Row) myrng.Interior.ColorIndex = xlNone For Each cel In myrng clr = 10 If Application.WorksheetFunction.CountIf(myrng, cel) 1 Then cel.Interior.ColorIndex = 10 + clr clr = clr + 10 End If Next End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:59 PM, Kasireddy Amarender kassi.re...@gmail.comwrote: Hi Noorain, Thank you for these formulaes. but I'm actually using VBA macro's to do a task it'll be really great if you could let me know in VBA. Here is my current code, I don't know I'm not able to highlight the duplicates. Sub Test1() For J1 = 10 To 500 If Cells(J1, 1).Value = XYZ And Cells(J1 + 1, 2) = ABC Then J1 = J1 + 1 For k = 1 To 7 If Cells(J1 + k, 2).Value = Key Then For Each i In Range(C:C) If i.Value = Cells(J1, 3).Value Then Count = Count + 1 If Count = 1 Then Cells(J1 + k, 3).Interior.color = 65535 'MsgBox Amar 'Cells(J1 + l + 1, 3).Interior.color = 65535 + 2000 End If Next i End If Next k If Count = 1 Then MsgBox Duplicates are there, please check End If End Sub On 19/01/2012, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) * see attached sheet.. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.comwrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- 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
Re: $$Excel-Macros$$ Copy data from excelsheet to html file
Hi Noorain seth, Thank you for the reply. I do not have any specific sheet. for example if one sheet with 1000 rows and every row has five cells with data 1. Name, 2. Address, 3. pin code and 4. Mob #. and i need to fill one web based form (like creating email ID) with this data. so can we create any macro which pick data from the excel sheet and add this into that web site? Pleaes advise. Thanks, Sushil On Thu, Jan 19, 2012 at 12:24 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sushil, Please check below link for your query.. http://www.teachexcel.com/excel-help/excel-how-to.php?i=294897#22 or pls share your worksheet with group, What you want exactly On Thu, Jan 19, 2012 at 2:00 AM, Sushil Kumar sushil@gmail.comwrote: Hi, Please help me on the subjected query. is there any macro which can copy data from excelsheet and paste on the html/web file? please advcie... -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.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$$ Re: Help On Print
Dear Rohan very very thanks please let me know where I did mistake Regards Shrinivas On Mon, Jan 16, 2012 at 9:55 PM, Sam Mathai Chacko samde...@gmail.comwrote: Here's how you do it. Regards, Sam Mathai Chacko On Mon, Jan 16, 2012 at 12:26 PM, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear Rohan I was trying to do it for me but I could not I am attaching the work sheet Please do it and please let me know what is the problem Why I could not do it? If I am doing it I can see only heading Please help Thanks in advanced Regards Shrinivas On Tue, Dec 20, 2011 at 7:11 PM, Shrinivas Shevde shrinivas...@gmail.com wrote: Very very thanks for help On Mon, Dec 19, 2011 at 1:10 PM, Rohan bittu.ro...@gmail.com wrote: If you can replicate this for your own sheetwell and good. Else send the worksheet over the group as an attachemnt and I will work that out. !! Thank you ! Sub Test() Dim SDate As DateDim EDate As DateLR = Range(A1).End(xlDown).RowSDate = InputBox(Put the date from when you want to take print out?)EDate = InputBox(Put the last date till what you want to take print out?) Sheets(Sheet1).SelectFor i = SDate To EDate Rows(1:1).SelectSelection.AutoFilter ActiveSheet.Range(A1:B LR).AutoFilter Field:=1, Criteria1:=i ActiveWindow.SelectedSheets.PrintOut Copies:=1 Rows(1:1).SelectSelection.AutoFilterNext i End Sub Regards, Rohan -- FORUM RULES (934+ 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 -- Shrini -- Shrini -- 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 -- Sam Mathai Chacko -- 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 -- Shrini -- 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$$ Need looping in VB script
Dear Sam, Please refer mail below where successful VB script done by you Now new challenge is in desktop as 2 excel Example : C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls C:\Users\Sam\Desktop\DelAllRowsExcelA2.xls how to do loop in vb script ? Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit Regards Yogananda Muthaiah On Sat, Jan 14, 2012 at 11:07 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: $uperb sam... Really ur great. Thank you and regards Yogananda Muthaiah On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 9:48 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Hi sam As you provided in excel vba .. I would need the same to run through vb script. keep 1 xl in desktop with records which we need *.vbs to run delete rows from range A2 to till end in xl On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Try in vb script? I have no idea what you are trying to convey. On Sat, Jan 14, 2012 at 6:30 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Thank you sam Can you please try in vb script on same On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Sub DelRows() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets With wks .Range(A2, .UsedRange.SpecialCells(xlCellTypeLastCell)(2)).EntireRow.Delete End With Next wks End Sub Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 8:07 AM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Dear All, Congrats for all excel macros group users , I have a excel where data is in Sheet1 to Sheet4. I would expect from any one of you to provide macro for getting rows delete from row 2 to till end Only Header should remain when macros runs. (i.e Range A1 should remain) Please try to help out through excel VBA or VBS Regards Yogananda Muthaiah Ph : 973 123 7267 -- 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 -- Sam Mathai Chacko -- 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 -- Sent from my mobile device Regards
Re: $$Excel-Macros$$ Need looping in VB script
Put inside a loop? for I = 1 to 10 ‘howmany_? Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA” I ”.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA” I “.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit next i Don Guillett SalesAid Software dguille...@gmail.com From: yogananda muthaiah Sent: Thursday, January 19, 2012 9:51 AM To: excel-macros@googlegroups.com ; samde...@gmail.com Subject: Re: $$Excel-Macros$$ Need looping in VB script Dear Sam, Please refer mail below where successful VB script done by you Now new challenge is in desktop as 2 excel Example : C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls C:\Users\Sam\Desktop\DelAllRowsExcelA2.xls how to do loop in vb script ? Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit Regards Yogananda Muthaiah On Sat, Jan 14, 2012 at 11:07 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: $uperb sam... Really ur great. Thank you and regards Yogananda Muthaiah On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 9:48 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Hi sam As you provided in excel vba .. I would need the same to run through vb script. keep 1 xl in desktop with records which we need *.vbs to run delete rows from range A2 to till end in xl On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Try in vb script? I have no idea what you are trying to convey. On Sat, Jan 14, 2012 at 6:30 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Thank you sam Can you please try in vb script on same On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Sub DelRows() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets With wks .Range(A2, .UsedRange.SpecialCells(xlCellTypeLastCell)(2)).EntireRow.Delete End With Next wks End Sub Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 8:07 AM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Dear All, Congrats for all excel macros group users , I have a excel where data is in Sheet1 to Sheet4. I would expect from any one of you to provide macro for getting rows delete from row 2 to till end Only Header should remain when macros runs. (i.e Range A1 should remain) Please try to help out through excel VBA or VBS Regards Yogananda Muthaiah Ph : 973 123 7267 -- 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 -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,
Re: $$Excel-Macros$$ EXCEL - TIPS
Dear Friends, i got reply from your end thank your very much. Please explain how do .because i dont know knowledge in Excel. Kindly explain from basic onwards. Regards, kishore On Thu, Jan 19, 2012 at 11:00 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Kishor, Please find attachment as per your requirement.. and follow Excel-Macro group on regular basis. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Wed, Jan 18, 2012 at 7:09 PM, kishore kishore...@gmail.com wrote: Dear Sir/Madam, Kindly i am very much interest to learn excel. Kindly provide the basic and also some important functionslike HLOOKUP,VLOOKUP, MACROS. Thanking you, Regards, kishore -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.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$$ Re: Help On Print
Please excuse my delayed reply. I just tried running the code that you provided in the attachment above. The code seems to be absolutely fine. The only thing, that may have caused trouble, if you did not enter the dates in the correct format. Please ensure that you enter the date in the same format, in which its there in the sheet. If the issues persists, you can get back to me with the error...!! Thank you !! Regards, Rohan. -- 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$$ Excel - Array Help
* * dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) * see attached sheet.. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.com wrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- 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 -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- 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 saurabh.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Excel - Array Help
Dear Sourabh, Please see attached sheet. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: * * dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) * see attached sheet.. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.com wrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- 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 -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- 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
Re: $$Excel-Macros$$ Excel - Array Help
Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sourabh, Please see attached sheet. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: * * dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) * see attached sheet.. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.com wrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- 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 -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- 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
$$Excel-Macros$$ Excellent Job Opportunity with Pubmatic India Pvt Ltd
Hi All, I would like to discuss an excellent career opportunity at Pubmatic, Pune. Please go through the job and company profile. *Title: Publisher Operations Specialist / Senior Publisher Operations Specialist * You will work as a key member of the Client Services team to provide support in the day-to-day management of publisher clients and ad network partners. Responsibilities will include managing ad network account setup, reporting, data updates, file management, data analysis, ad network applications, traffic (run) campaigns and creative’s, generate and interpret reporting that will yield competitive insights for our clients and partners as part of a team that handles a group of clients. You will work closely with internal customers to deliver on online ad inventory performance. *Qualifications:* - Any Graduation; preferably technical qualification / Masters is a plus - Certifications in web programming, data management tools is a plus - Pro-active, Logical reasoning ability, Problem solving and analytical mindset, Excellent written and spoken English, Quick learning, Detail oriented, Customer service-oriented attitude - Organized and structured approach to tasks, Client interaction exposure (especially US), - Macros in Excel. *Salary*: Best in the industry. CTC can go upto* 8 lacs *depending on you current salary and experience. Joining bonus and relocation expenses (for outstation candidates) will also be provided. *About PubMatic:* PubMatic’s ad monetization and management solution combines impression-level ad auction technology, the most comprehensive brand protection tools, and enterprise ad operations support to give the Web’s premium publishers the most control over their revenue and brand. PubMatic has seven offices around the world in the US, Europe, and Asia. Some of the world’s most respected online publishers have chosen to work with PubMatic, including The Huffington Post, eBay, United Online, TV Guide, and the majority of the comScore Top 10. PubMatic is venture backed by Draper Fisher Jurvetson, Nexus Venture Partners, and Helion Ventures. *If interested please send your resumes to abhishek.a...@gmail.com. *If you have any more queries please contact me via the same email id.* Warm Regard Abhishek Singh * -- 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$$ Save As today date
Dear Darwin, Your code is working fine, but need small correction... Please use below code... Sub savemethod() Dim todaydate As String Dim fileSaveName As String todaydate = VBA.Format(DateSerial(Year(Date), Month(Date), Day(Date)), dd-mmm-) fileSaveName = Application.GetSaveAsFilename(InitialFileName:=todaydate, fileFilter:=Excel Files (*.xls), *.xls, Title:=Please save the file) ActiveWorkbook.SaveAs Filename:=C:\Documents and Settings\noorain.ansari\Desktop\ todaydate .xls End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Jan 20, 2012 at 9:13 AM, Darwin Chan darwin.chankaw...@gmail.comwrote: Dear group, I have written a macro for auto saving as today date excel file, however, when i save this, it refuses to save. I think that it turns DateSerial(Year(Date), Month(Date), Day(Date)) to be 20/01/2012, however, it treats me to create directory. What functions should I use to auto saving as today date beside this one? **Code** ** Sub savemethod() Dim todaydate As String Dim fileSaveName As String todaydate = DateSerial(Year(Date), Month(Date), Day(Date)) fileSaveName = Application.GetSaveAsFilename(initialfilename:=todaydate, fileFilter:=Excel Files (*.xls), *.xls, Title:=Please save the file) ActiveWorkbook.SaveAs Filename:=todaydate End Sub ** -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- 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$$ Need looping in VB script
Hi, i have 2 excels in desktop which needs to be looped. As explained below , not working properly. Regards Yogananda Muthaiah On Thu, Jan 19, 2012 at 9:32 PM, dguillett1 dguille...@gmail.com wrote: Put inside a loop? for I = 1 to 10 ‘howmany_? Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA” I ”.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA” I “.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit next i Don Guillett SalesAid Software dguille...@gmail.com *From:* yogananda muthaiah yogananda.mutha...@gmail.com *Sent:* Thursday, January 19, 2012 9:51 AM *To:* excel-macros@googlegroups.com ; samde...@gmail.com *Subject:* Re: $$Excel-Macros$$ Need looping in VB script Dear Sam, Please refer mail below where successful VB script done by you Now new challenge is in desktop as 2 excel Example : C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls C:\Users\Sam\Desktop\DelAllRowsExcelA2.xls how to do loop in vb script ? Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit Regards Yogananda Muthaiah On Sat, Jan 14, 2012 at 11:07 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: $uperb sam... Really ur great. Thank you and regards Yogananda Muthaiah On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 9:48 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Hi sam As you provided in excel vba .. I would need the same to run through vb script. keep 1 xl in desktop with records which we need *.vbs to run delete rows from range A2 to till end in xl On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Try in vb script? I have no idea what you are trying to convey. On Sat, Jan 14, 2012 at 6:30 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Thank you sam Can you please try in vb script on same On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Sub DelRows() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets With wks .Range(A2, .UsedRange.SpecialCells(xlCellTypeLastCell)(2)).EntireRow.Delete End With Next wks End Sub Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 8:07 AM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Dear All, Congrats for all excel macros group users , I have a excel where data is in Sheet1 to Sheet4. I would expect from any one of you to provide macro for getting rows delete from row 2 to till end Only Header should remain when macros runs. (i.e Range A1 should remain) Please try to help out through excel VBA or VBS Regards Yogananda Muthaiah Ph : 973 123 7267 -- 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 -- Sam Mathai Chacko --
Re: $$Excel-Macros$$ Excel - Array Help
and plz explain the sum formula of counting unique records On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote: Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sourabh, Please see attached sheet. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: * * dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) * see attached sheet.. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.com wrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- 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 -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- 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
$$Excel-Macros$$ Need help on Resigned staffs statistic
Dear all, Can you please help me on resigned staffs statistic? I need the information as below: the number of resigned staffs in 2006 and ratio of resigned staffs male:female Like wise till 2012 Your help will be highly effective for my work. Regards, Sunita -- 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$$ Save As today date
Dear Noorain, I try to use the code pasted here, however, run time error 1004. It may be due to the code highlight in red. What should the code be if I would like to have directory highlighted in red to be chosen by user? 2012/1/20 NOORAIN ANSARI noorain.ans...@gmail.com Dear Darwin, Your code is working fine, but need small correction... Please use below code... Sub savemethod() Dim todaydate As String Dim fileSaveName As String todaydate = VBA.Format(DateSerial(Year(Date), Month(Date), Day(Date)), dd-mmm-) fileSaveName = Application.GetSaveAsFilename(InitialFileName:=todaydate, fileFilter:=Excel Files (*.xls), *.xls, Title:=Please save the file) ActiveWorkbook.SaveAs Filename:=C:\Documents and Settings\noorain.ansari\Desktop\ todaydate .xls End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Jan 20, 2012 at 9:13 AM, Darwin Chan darwin.chankaw...@gmail.comwrote: Dear group, I have written a macro for auto saving as today date excel file, however, when i save this, it refuses to save. I think that it turns DateSerial(Year(Date), Month(Date), Day(Date)) to be 20/01/2012, however, it treats me to create directory. What functions should I use to auto saving as today date beside this one? **Code** ** Sub savemethod() Dim todaydate As String Dim fileSaveName As String todaydate = DateSerial(Year(Date), Month(Date), Day(Date)) fileSaveName = Application.GetSaveAsFilename(initialfilename:=todaydate, fileFilter:=Excel Files (*.xls), *.xls, Title:=Please save the file) ActiveWorkbook.SaveAs Filename:=todaydate End Sub ** -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- 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 -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- 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$$ Need looping in VB script
Sam, help me out On 1/20/12, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Hi, i have 2 excels in desktop which needs to be looped. As explained below , not working properly. Regards Yogananda Muthaiah On Thu, Jan 19, 2012 at 9:32 PM, dguillett1 dguille...@gmail.com wrote: Put inside a loop? for I = 1 to 10 ‘howmany_? Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA” I ”.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA” I “.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit next i Don Guillett SalesAid Software dguille...@gmail.com *From:* yogananda muthaiah yogananda.mutha...@gmail.com *Sent:* Thursday, January 19, 2012 9:51 AM *To:* excel-macros@googlegroups.com ; samde...@gmail.com *Subject:* Re: $$Excel-Macros$$ Need looping in VB script Dear Sam, Please refer mail below where successful VB script done by you Now new challenge is in desktop as 2 excel Example : C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls C:\Users\Sam\Desktop\DelAllRowsExcelA2.xls how to do loop in vb script ? Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit Regards Yogananda Muthaiah On Sat, Jan 14, 2012 at 11:07 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: $uperb sam... Really ur great. Thank you and regards Yogananda Muthaiah On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 9:48 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Hi sam As you provided in excel vba .. I would need the same to run through vb script. keep 1 xl in desktop with records which we need *.vbs to run delete rows from range A2 to till end in xl On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Try in vb script? I have no idea what you are trying to convey. On Sat, Jan 14, 2012 at 6:30 PM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Thank you sam Can you please try in vb script on same On 1/14/12, Sam Mathai Chacko samde...@gmail.com wrote: Sub DelRows() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets With wks .Range(A2, .UsedRange.SpecialCells(xlCellTypeLastCell)(2)).EntireRow.Delete End With Next wks End Sub Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 8:07 AM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Dear All, Congrats for all excel macros group users , I have a excel where data is in Sheet1 to Sheet4. I would expect from any one of you to provide macro for getting rows delete from row 2 to till end Only Header should remain when macros runs. (i.e Range A1 should remain) Please try to help out through excel VBA or VBS Regards Yogananda Muthaiah Ph : 973 123 7267 -- 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
Re: $$Excel-Macros$$ Save As today date
Dear Noorain, I have found some method. See if there needs improvement. **Code** Sub savemethod2() Dim todaydate As String, fileSaveName As String, driveloc As String, mth As String mth = Format(Date, mm) todaydate = VBA.Format(DateSerial(Year(Date), month(Date), Day(Date)), dd-mm-) driveloc = P:\CMR Folder (For CMR staff only)\CMR Report\CHS EDI \ Year(Date) \ Year(Date) , mth fileSaveName = Application.GetSaveAsFilename(InitialFileName:=todaydate, fileFilter:=Excel Files (*.xls), *.xls, Title:=Please save the file) ActiveWorkbook.SaveAs Filename:=driveloc \ todaydate .xls End Sub 2012/1/20 Darwin Chan darwin.chankaw...@gmail.com Dear Noorain, I try to use the code pasted here, however, run time error 1004. It may be due to the code highlight in red. What should the code be if I would like to have directory highlighted in red to be chosen by user? 2012/1/20 NOORAIN ANSARI noorain.ans...@gmail.com Dear Darwin, Your code is working fine, but need small correction... Please use below code... Sub savemethod() Dim todaydate As String Dim fileSaveName As String todaydate = VBA.Format(DateSerial(Year(Date), Month(Date), Day(Date)), dd-mmm-) fileSaveName = Application.GetSaveAsFilename(InitialFileName:=todaydate, fileFilter:=Excel Files (*.xls), *.xls, Title:=Please save the file) ActiveWorkbook.SaveAs Filename:=C:\Documents and Settings\noorain.ansari\Desktop\ todaydate .xls End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Jan 20, 2012 at 9:13 AM, Darwin Chan darwin.chankaw...@gmail.com wrote: Dear group, I have written a macro for auto saving as today date excel file, however, when i save this, it refuses to save. I think that it turns DateSerial(Year(Date), Month(Date), Day(Date)) to be 20/01/2012, however, it treats me to create directory. What functions should I use to auto saving as today date beside this one? **Code** ** Sub savemethod() Dim todaydate As String Dim fileSaveName As String todaydate = DateSerial(Year(Date), Month(Date), Day(Date)) fileSaveName = Application.GetSaveAsFilename(initialfilename:=todaydate, fileFilter:=Excel Files (*.xls), *.xls, Title:=Please save the file) ActiveWorkbook.SaveAs Filename:=todaydate End Sub ** -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- 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 -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- 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
$$Excel-Macros$$ Mr. Neeraj for this window u have to first go to the windows explorer and from that say Tools from menu there exactly u will find this....
Regards, Muneer, CC... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Neeraj Chauhan Sent: Friday, January 20, 2012 9:59 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hidden file Dear sir, Kindly see the attached screen shot. The file is hidden. I want to unhide the file. -- 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 image001.jpg
Re: $$Excel-Macros$$ FW: Hidden file
Dear Neeraj, We are unable to open your attached file. Please resend. On Fri, Jan 20, 2012 at 12:51 PM, Neeraj Chauhan neerajchauhan...@gmail.com wrote: Dear all File is also attached kindly see. ** ** ** ** [image: Sign] ** ** *From:* Neeraj Chauhan [mailto:neerajchauhan...@gmail.com] *Sent:* Friday, January 20, 2012 12:29 PM *To:* 'excel-macros@googlegroups.com' *Subject:* Hidden file ** ** Dear sir, ** ** Kindly see the attached screen shot. The file is hidden. I want to unhide the file. ** ** ** ** [image: Sign] ** ** -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.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 image001.jpg
Re: $$Excel-Macros$$ Need help on Resigned staffs statistic
Dear Sunita Kindly give one example of what u want in your sheet as to study the data and analyse the same and preparing format as per your requirement takes a lot time So kindly provide one output example in output format 2012/1/20 सुनिता पौडेल tosune...@gmail.com Dear all, Can you please help me on resigned staffs statistic? I need the information as below: the number of resigned staffs in 2006 and ratio of resigned staffs male:female Like wise till 2012 Your help will be highly effective for my work. Regards, Sunita -- 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$$ EXCEL - TIPS
Thanks Noorain for such excel file On Fri, Jan 20, 2012 at 11:20 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Kishore, You can study attached Ebook step by step.. It will help you to learn excel. - Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 8:24 PM, Sweet Kishore kishore...@gmail.comwrote: Dear Friends, i got reply from your end thank your very much. Please explain how do .because i dont know knowledge in Excel. Kindly explain from basic onwards. Regards, kishore On Thu, Jan 19, 2012 at 11:00 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Kishor, Please find attachment as per your requirement..**http://noorain-ansari.blogspot.com/ and follow Excel-Macro group on regular basis. - On Wed, Jan 18, 2012 at 7:09 PM, kishore kishore...@gmail.com wrote: Dear Sir/Madam, Kindly i am very much interest to learn excel. Kindly provide the basic and also some important functionslike HLOOKUP,VLOOKUP, MACROS. Thanking you, Regards, kishore -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.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
Re: $$Excel-Macros$$ Hidden file
Dear Neeraj Kindly visit below link http://www.sevenforums.com/tutorials/56005-file-folder-hide-unhide.html On Fri, Jan 20, 2012 at 12:29 PM, Neeraj Chauhan neerajchauhan...@gmail.com wrote: Dear sir, ** ** Kindly see the attached screen shot. The file is hidden. I want to unhide the file. ** ** ** ** [image: Sign] ** ** -- 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 image001.jpg
Re: $$Excel-Macros$$ Save As today date
Try this: Below Code will popup an input box for you to enter the path of the file and name and then it will automatically append the todays name and save it as your given location. - ThisWorkbook.SaveAs InputBox(Enter the Path) Day(Now) - Month(Now) - Year(Now) .xls On Jan 20, 11:44 am, Darwin Chan darwin.chankaw...@gmail.com wrote: Dear Noorain, I try to use the code pasted here, however, run time error 1004. It may be due to the code highlight in red. What should the code be if I would like to have directory highlighted in red to be chosen by user? 2012/1/20 NOORAIN ANSARI noorain.ans...@gmail.com Dear Darwin, Your code is working fine, but need small correction... Please use below code... Sub savemethod() Dim todaydate As String Dim fileSaveName As String todaydate = VBA.Format(DateSerial(Year(Date), Month(Date), Day(Date)), dd-mmm-) fileSaveName = Application.GetSaveAsFilename(InitialFileName:=todaydate, fileFilter:=Excel Files (*.xls), *.xls, Title:=Please save the file) ActiveWorkbook.SaveAs Filename:=C:\Documents and Settings\noorain.ansari\Desktop\ todaydate .xls End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Jan 20, 2012 at 9:13 AM, Darwin Chan darwin.chankaw...@gmail.comwrote: Dear group, I have written a macro for auto saving as today date excel file, however, when i save this, it refuses to save. I think that it turns DateSerial(Year(Date), Month(Date), Day(Date)) to be 20/01/2012, however, it treats me to create directory. What functions should I use to auto saving as today date beside this one? **Code** ** Sub savemethod() Dim todaydate As String Dim fileSaveName As String todaydate = DateSerial(Year(Date), Month(Date), Day(Date)) fileSaveName = Application.GetSaveAsFilename(initialfilename:=todaydate, fileFilter:=Excel Files (*.xls), *.xls, Title:=Please save the file) ActiveWorkbook.SaveAs Filename:=todaydate End Sub ** -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- 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 -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk- Hide quoted text - - Show quoted text - -- 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.
Re: $$Excel-Macros$$ Need help on Resigned staffs statistic
Dear Priyanka, Thank you for the interest shown. Please find attached the example of what I required. On Fri, Jan 20, 2012 at 1:12 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Sunita Kindly give one example of what u want in your sheet as to study the data and analyse the same and preparing format as per your requirement takes a lot time So kindly provide one output example in output format 2012/1/20 सुनिता पौडेल tosune...@gmail.com Dear all, Can you please help me on resigned staffs statistic? I need the information as below: the number of resigned staffs in 2006 and ratio of resigned staffs male:female Like wise till 2012 Your help will be highly effective for my work. Regards, Sunita -- 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 Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet