$$Excel-Macros$$ Automatic Email from Excel
Friends, I have an excel spreadsheet with dates updated on it, all I need is that the system should automatically send an Email to the specified email address automatically by picking up that particular date. Ex: Date:Subject To 29/06/2012 Renew your Insurancehema5s...@gmail.com so, on 28th or 29th the system should automatically send an email and to that particular person with that subject from spreadsheet. is that Possible? if yes means please help me. -- Thanks Hemanath.D -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Enable Disable Ctrl+D with passward
Hi group, Because of CTRl+D just fill down the data iam facing this problem, when i want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not observing it later it was effecting to the data. So i what i need is i want to *disable Ctrl+D with a passward* and same time i want to *enable with a passward*. I think it will usefull for others also. Thanks in Advance. On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Do you have any add-in or macro in personal.xlsb which have any macro assigned Ctrl+D?? Because excel default Ctrl+D just fill down the data. * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E *Sent:* 27 June 2012 3:18 *To:* excel-macros@googlegroups.com *Cc:* ahmedhon...@gmail.com *Subject:* Re: $$Excel-Macros$$ Enable Disable Ctrl+D with passward ** ** Hi, But it will not come to the notice at the same time, it was accidently going on, iam not observing it later it was effecting to the data. On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest ahmedhon...@gmail.com wrote: Dear, I think using Ctrl + Z will allow you to take back the action you performed i.e Undo the last action ;-). This should help. If not, check other experts advice. Thanks, On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E emuralidha...@gmail.com wrote: Dear all, Iam using Office 2007, when iam need to use Crl+F accidently iam hitting Ctrl+D, iam loosing some data and iam unable to find the changes happening to the data file. Iam want to disable Ctrl+D option with a passward and the same enable with passward, it should for that worksheet only. Thanks in advance. -- *Thanks Regards,* *Muralidhar E.* ** ** -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Ahmed Bawazir *احمد باوزير* ** ** -- *Thanks Regards,* *Muralidhar E.* ** ** -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to
Re: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet
Hi Mangesh, Try using from Insert Menu -- Object -- choose Create from file and locate your sheet path that is available in your respective file then an Icon is displayed so being in a sheet when you click on that Icon you will get another sheet. Revert if you failed to understand the above. I think this option should meet your requirement 100%. Thanks, Ahmed Bawazir On Thu, Jun 28, 2012 at 7:46 AM, Lalit_Mohan mohan.pande...@gmail.comwrote: Hi, This kind of functionality is available in excel i don't know but we can achieve this not exactle but will look like this by using paste data as picture link. I don't know how much it will helful to you. Regards, Lalit Mohan On Wednesday, 27 June 2012 20:33:43 UTC+5:30, Mangesh wrote: Hi Friends, I need sheet under another sheet. I have provided explanation in attached sheet. Please help. -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Ahmed Bawazir *احمد باوزير* -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-23,56,67,X30 in cell c34 to be written as X6-1 in cell c34 X6-4 in cell c35 and so o
Dear members, Please help me solve the above problem using macro or array formulae. Problem - data seperated by hypen - and comma , to be written in rows existing below (should not insert rows but place data in already existing rows ) eg 1 X6-1,4,5,6,9,X7-23,56,67,X30 in cell C34 ANSWER should be - X6-1 in cell c34 X6-4 in cell c35 X6-5 in cell C36 X6-6 in cell C37 X6-9 in cell C38 X7-23 in cell C39 X7-56 in cell C40 X7-67 in cell C41 X30 in cell C42 eg 2 X6-33,36 in cell C55 Answer should be X6-33 in cell C55 X6-36 in cell C56 A) similar data is saved in the rows one below other seperated by suitable rows The macro should consider 3000 rows containg any data seperated by - and , B) data in the cell may contain 1 to 3 hypen and at most 15 commas C) letter 'X' will be always present in data -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Automatic Email from Excel
Dear Hemanath, Please try it.. Sub maildata() Dim olApp As Outlook.Application Dim olMail As MailItem Dim i As Integer, j As Integer Dim sh As Worksheet On Error Resume Next Application.ScreenUpdating = False Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) Set sh = ThisWorkbook.Sheets(1) With sh j = sh.Range(B Rows.Count).End(xlUp).Row For i = 2 To j If CDate(.Cells(i, B)) = Date Then With olMail .To = .Cells(i, D) .CC = noorain.ans...@gmail.com .Subject = .Cells(i, C) .Body = Hi vbCrLf vbCrLf Please find the attached Report Thanks vbCrLf vbCrLf vbCrLf Regards vbCrLf Noorain Ansari .Display End With End If Next i End With Set olMail = Nothing Application.ScreenUpdating = True On Error GoTo 0 End Sub -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 28, 2012 at 2:29 PM, hemanath dhanasekar hema5s...@gmail.comwrote: Friends, I have an excel spreadsheet with dates updated on it, all I need is that the system should automatically send an Email to the specified email address automatically by picking up that particular date. Ex: Date:Subject To 29/06/2012 Renew your Insurancehema5s...@gmail.com so, on 28th or 29th the system should automatically send an email and to that particular person with that subject from spreadsheet. is that Possible? if yes means please help me. -- Thanks Hemanath.D -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Automatic Email from Excel
Dear Hemnath, before run the macro pls check on Ms outlook liberary On Thu, Jun 28, 2012 at 4:05 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Hemanath, Please try it.. Sub maildata() Dim olApp As Outlook.Application Dim olMail As MailItem Dim i As Integer, j As Integer Dim sh As Worksheet On Error Resume Next Application.ScreenUpdating = False Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) Set sh = ThisWorkbook.Sheets(1) With sh j = sh.Range(B Rows.Count).End(xlUp).Row For i = 2 To j If CDate(.Cells(i, B)) = Date Then With olMail .To = .Cells(i, D) .CC = noorain.ans...@gmail.com .Subject = .Cells(i, C) .Body = Hi vbCrLf vbCrLf Please find the attached Report Thanks vbCrLf vbCrLf vbCrLf Regards vbCrLf Noorain Ansari .Display End With End If Next i End With Set olMail = Nothing Application.ScreenUpdating = True On Error GoTo 0 End Sub -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 28, 2012 at 2:29 PM, hemanath dhanasekar hema5s...@gmail.comwrote: Friends, I have an excel spreadsheet with dates updated on it, all I need is that the system should automatically send an Email to the specified email address automatically by picking up that particular date. Ex: Date:Subject To 29/06/2012 Renew your Insurancehema5s...@gmail.com so, on 28th or 29th the system should automatically send an email and to that particular person with that subject from spreadsheet. is that Possible? if yes means please help me. -- Thanks Hemanath.D -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-23,56,67,X30 in cell c34 to be written as X6-1 in cell c34 X6-4 in cell c35 and
The macro below does exactly what is need but it doesn't prefix the letters before the hypen. eg 1 X6-1,4,5,6,9,X7-23,56,67,X30 in cell C34 ANSWER by using below macro - X6-1 in cell c34 4 in cell c35 5 in cell C36 6 in cell C37 9 in cell C38 I want X6- also as a prefix 23 in cell C39 56 in cell C40 67 in cell C41 X30 in cell C42 The following macro can be eidted to do same.Please help Sub Splt() Dim LR As Long, i As Long Dim X As Variant Application.ScreenUpdating = False LR = Range(A Rows.Count).End(xlUp).Row Columns(A).Insert For i = LR To 1 Step -1 With Range(B i) If InStr(.Value, ,) = 0 Then .Offset(, -1).Value = .Value Else X = Split(.Value, ,) .Offset(1).Resize(UBound(X)).EntireRow.Insert .Offset(, -1).Resize(UBound(X) - LBound(X) + 1).Value = Application.Transpose(X) End If End With Next i Columns(B).Delete LR = Range(A Rows.Count).End(xlUp).Row With Range(B1:C LR) On Error Resume Next .SpecialCells(xlCellTypeBlanks).FormulaR1C1 = =R[-1]C On Error GoTo 0 .Value = .Value End With Application.ScreenUpdating = True End Sub On Thursday, 28 June 2012 15:39:56 UTC+5:30, vijay yadav wrote: Dear members, Please help me solve the above problem using macro or array formulae. Problem - data seperated by hypen - and comma , to be written in rows existing below (should not insert rows but place data in already existing rows ) eg 1 X6-1,4,5,6,9,X7-23,56,67,X30 in cell C34 ANSWER should be - X6-1 in cell c34 X6-4 in cell c35 X6-5 in cell C36 X6-6 in cell C37 X6-9 in cell C38 X7-23 in cell C39 X7-56 in cell C40 X7-67 in cell C41 X30 in cell C42 eg 2 X6-33,36 in cell C55 Answer should be X6-33 in cell C55 X6-36 in cell C56 A) similar data is saved in the rows one below other seperated by suitable rows The macro should consider 3000 rows containg any data seperated by - and , B) data in the cell may contain 1 to 3 hypen and at most 15 commas C) letter 'X' will be always present in data -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-23,56,67,X30 in cell c34 to be written as X6-1 in cell c34 X6-4 in cell c35 and
Hi Vijay, Hope it helps you Sub SeperateData() Dim varVal As Variant Dim lngLoop As Long Dim rngRangeAs Range Dim strIni As String Dim strFinalAs String Set rngRange = ActiveSheet.Range(A1) varVal = Split(rngRange.Value, ,) For lngLoop = LBound(varVal) To UBound(varVal) If LCase(varVal(lngLoop)) Like x* Then strIni = varVal(lngLoop) strFinal = strIni Else strFinal = Split(strIni, -)(0) - varVal(lngLoop) End If rngRange.Offset(lngLoop) = strFinal Next lngLoop End Sub change accordingly Regards, Lalit Mohan -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Re: Your feedback is important !
I have posted a request today itself,Should i fill the SURVEY FORM or should i wait for a few days and fill the form when i get a response ? Regards Vijay On Saturday, 9 June 2012 00:23:15 UTC+5:30, Ayush Jain wrote: Dear members, I have received very few responses on feedback request. Please take out some time and provide your feedback/comments. Survey Form http://www.surveymonkey.com/s/3WM3FYH Thanks in advance for your participation. Regards Ayush Jain On Thursday, 7 June 2012 00:16:48 UTC+5:30, Ayush Jain wrote: Dear member, Thanks for your active particiption in the group. I have created an anonymous survey to get your feedback on this group. It will not take more than 5-7 minutes but will definitely give me an opportunity to make this group better. Please feel free to fill the online survey and provide your valuable feedback. Here is the link. Survey Form http://www.surveymonkey.com/s/3WM3FYH Many thanks. Regards Ayush Jain -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Automatic Email from Excel
Thanks Noorain, Let me check this out. On Thu, Jun 28, 2012 at 4:08 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Hemnath, before run the macro pls check on Ms outlook liberary On Thu, Jun 28, 2012 at 4:05 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Hemanath, Please try it.. Sub maildata() Dim olApp As Outlook.Application Dim olMail As MailItem Dim i As Integer, j As Integer Dim sh As Worksheet On Error Resume Next Application.ScreenUpdating = False Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) Set sh = ThisWorkbook.Sheets(1) With sh j = sh.Range(B Rows.Count).End(xlUp).Row For i = 2 To j If CDate(.Cells(i, B)) = Date Then With olMail .To = .Cells(i, D) .CC = noorain.ans...@gmail.com .Subject = .Cells(i, C) .Body = Hi vbCrLf vbCrLf Please find the attached Report Thanks vbCrLf vbCrLf vbCrLf Regards vbCrLf Noorain Ansari .Display End With End If Next i End With Set olMail = Nothing Application.ScreenUpdating = True On Error GoTo 0 End Sub -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 28, 2012 at 2:29 PM, hemanath dhanasekar hema5s...@gmail.com wrote: Friends, I have an excel spreadsheet with dates updated on it, all I need is that the system should automatically send an Email to the specified email address automatically by picking up that particular date. Ex: Date:Subject To 29/06/2012 Renew your Insurancehema5s...@gmail.com so, on 28th or 29th the system should automatically send an email and to that particular person with that subject from spreadsheet. is that Possible? if yes means please help me. -- Thanks Hemanath.D -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks HemanatH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: Automatic Email from Excel
Thanks Lalit On Thu, Jun 28, 2012 at 3:51 PM, Lalit_Mohan mohan.pande...@gmail.comwrote: Hi Hemanath Hope it helps you 'First add Tool - Refrence - Microsoft Outlook 12.0 object library Sub ExportEmail() Dim olApp As Object Dim olMail As Object Dim olNsAs Object Dim strSub As String Dim strEmailTo As String Dim strEmailCC As String Dim strEmailBCC As String Dim strDistroList As String Dim rngRangeAs Range Dim rngCell As Range Application.ScreenUpdating = False Application.DisplayAlerts = False Application.StatusBar = Creating Email and sending... Set rngRange = ActiveSheet.UsedRange For Each rngCell In rngRange.Resize(, 1).Offset(1) strEmailTo = Trim(rngCell.Offset(, 2).Value) strEmailCC = strEmailBCC = strSub = Trim(rngCell.Offset(, 1).Value) Set olApp = CreateObject(Outlook.Application) Set olNs = olApp.GetNamespace(MAPI) olNs.Logon Set olMail = olApp.CreateItem(olMailItem) olMail.to = strEmailTo olMail.CC = strEmailCC olMail.BCC = strEmailBCC olMail.Subject = strSub olMail.Body = olMail.Display olMail.Send Next rngCell Application.StatusBar = False Application.ScreenUpdating = True Application.DisplayAlerts = True End Sub Regards, Lalit Mohan -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks HemanatH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
RE: $$Excel-Macros$$ Re: Label record sheet
I still waiting for answers, Please advice I tried to made it with myself, It look like better but still have problem see my sheet, Please help From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Attapan Sent: Wednesday, June 27, 2012 9:46 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Label record sheet Missed text (revised) On Wednesday, June 27, 2012 9:39:17 PM UTC+7, Attapan wrote: I'll explain all of my request 1.This sheet made for keep history of label printing 2.the format of label are A 1207 x line no.Month 5 digits running number 3.I've variety of product code and product code use for 3 Line// I call the name of production line = A,B and T 4. Quantity concern with running no. ex. if start new month with product a , production line a , qty = 500 ,YYMM = 1207 label which i recorded are start=A12071 and end =A120700500 So, if I start next row with same condition (product no, production line,YYMM and qty = 30) I must be record for start=A120700501 and end=A120700530 and if I start next row with same product no, product line, YYMM = 1208 and qty 20 I must be record start=A12071 end=A120700020 5. There are three conditions for record as I need = Product no,Production line, and YYMM Do you understand my requirement ? , Please feedback finally, Can someone advice this sheet for me ? On Wednesday, June 27, 2012 3:03:21 PM UTC+7, Attapan wrote: Dear all experts I've some questions about functions on the sheet, I made the sheet, So it use for record the label for production I tried and tried to do with many fomular, but the results are not OK :( I posted that sheet for all, Please discipline for me Very thanks Rdgs Attapan Chainarongboon Production control Dept (Compressor) Calsonic Kansei (Thailand) E-mail : attapan_chainarongb...@ck-mail.commailto:attapan_chainarongb...@ck-mail.com Phone : (+66) 038-210-129 #101 Mobile phone: (+66) 086-824-5045 -- -- 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.commailto:excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Label.xlsx Description: Label.xlsx
Re: $$Excel-Macros$$ Problem with excel
Hi Experts still waiting for solution Divaker On Tue, Jun 26, 2012 at 8:25 PM, Divaker Pandey divake...@gmail.com wrote: but it will lock modification in list through vba. Divker On Tue, Jun 26, 2012 at 8:23 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Divaker, I have created a name range List_Matters, We called it through below coding.. Sheet1.lstLookup.ListFillRange = List_Matters and in Property Boxt i have marked columnHeads as true. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jun 26, 2012 at 8:03 PM, Divaker Pandey divake...@gmail.com wrote: Thanks Noorain, i want to list out all company details which match on entered value in textbox. By the way how you added header in listbox. Please tell me steps. Thanks. Divaker On Tue, Jun 26, 2012 at 7:28 PM, ╰» ℓαℓιт мσαнη mohan.pande...@gmail.com wrote: Hi Divaker, You query is not cleary mentioned can u please share a file with the full description so that we can help u as soon as possible Regards, Lalit Mohan On Tue, Jun 26, 2012 at 6:35 PM, Divaker Pandey divake...@gmail.com wrote: Hi Experts, Still waiting for your response. Divaker On Tue, Jun 26, 2012 at 5:10 PM, Divaker Pandey divake...@gmail.com wrote: Hi Noorain Experts, Thanks for respond. please find attached file. on tab sheet1 there is two activeX control 1. Textbox -txtLookup 2. ListBox - lstLookup if user change value of textbox it search the input string in each column. and add in listbox all rows which string matched. I want to add headers. Please suggest asap. Divaker On Tue, Jun 26, 2012 at 4:08 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Divaker, Please share your Activelistbox with group. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jun 26, 2012 at 4:07 PM, Divaker Pandey divake...@gmail.com wrote: Hi Ayush, I want to add header column text in Activelistbox through vba. Can you help me how i can add. Thanks. Divaker -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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
RE: $$Excel-Macros$$ need of free e-book
Download from here http://www.2shared.com/complete/CMFN-eEp/Building_Accounting_Systems_Us.html Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kashan Abbas Sent: 28 June 2012 1:32 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ need of free e-book HI to All, Could you please provide me mentioned pdf free ebook . BUILDING ACCOUNTING SYSTEM USING ACCESS 2007 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Fwd: MIS executive opening with Aricent Technologies (Contact to Hire)
Dear Jitu, As per Forum rule, Job related mail has been banned. Brother take care in future. On Thu, Jun 28, 2012 at 4:17 PM, Jitendra singh jeete2...@gmail.com wrote: -- Forwarded message -- From: RJT Compuquest so...@rjtcindia.com Date: Thu, Jun 28, 2012 at 1:26 PM Subject: MIS executive opening with Aricent Technologies (Contact to Hire) To: jeete2...@gmail.com The sender of this email is registered with Naukri.com as RJT Compuquest *Experience required for the Job:* 2 - 3 years *Job Location:* Gurgaon Apply Nowhttp://apply.naukri.com/Apply/mn_Apply.php?applytype=singleApplyMode=1src=rmjmessageId=bb0fc18dbdd6dbcbdf2e98fe9faaf5c7445f0d5954061a0252021f1a0e781c0b4440484f091812415b010c131b10125b5(Send your Naukri profile to express interest to the recruiter) *Dear Candidate,* Hello, Greetings of the Day!!! We have MIS Executive Opening with Client :Aricent Technologies,Gurgaon (Working on a payroll of RJT) About Aricent(CLient): Our Client is a global innovation, technology and services company focused exclusively on communications. Its unique engagement model blends strategy, design, technology and engineering services, delivering exceptional value across each phase of the product and service lifecycle. Together with its global innovation arm frog design, offers 40 years experience in delivering innovation and technology breakthroughs that have transformed entire industries. With more than 800 clients, 9500 employees in 19 countries,more than 100 industry awards. It is uniquely positioned to help organizations conceive and commercialize innovative solutions. Please fill this below details: Currrent CTC: Expected CTC: Notice Period: DOB: Roles Responsbilities: Expertise in MS-Excel, MS-Power Point, MS-Word MS- Access Good analytical management skills Ability to relate various data sources for comparing/contrasting Ability to interpret requirements be self driven Preparing presenting appropriate reports as when required Maintain data pertaining to all departments - OM, Finance Accounts, HR Admin, Sales Service, Education Handling different projects assignment as when required Qualification: Any Graduate Location: Gurgaon Please forward your updated resume and also refer your friend or colleague who are interested to change. Awaiting your prompt reply. Thanks Regards Sonia Gupta Is this job relevant to you? Yeshttp://jobsearch.naukri.com/mynaukri/jobs_feedback.php?response=yesmid=7057569 Nohttp://jobsearch.naukri.com/mynaukri/jobs_feedback.php?response=nomid=7057569 Your feedback would help us in sending you the most relevant job opportunities Disclaimer: The sender of this email is registered with naukri.com as *RJT Compuquest * (gau...@rjtcindia.com, 736 Udyog Vihar Ph - V Gurgaon, HR, GURGAON, Haryana - 122001) using Naukri.com services. The responsibility of checking the authenticity of offers/correspondence lies with you. If you consider the content of this email inappropriate or spam, you may: 1. Report abuse by forwarding this email to: complia...@naukri.com 2. You can also Block this Companyhttp://my.naukri.com/BlockCompany/edit/cid/32550from searching your resume in the database. Advisory: Please do not pay any money to anyone who promises to find you a job. This could be in the form of a registration fee, or document processing fee or visa charges or any other pretext. The money could be asked for upfront or it could be asked after trust has been built after some correspondence has been exchanged. Also please note that in case you get a job offer or a letter of intent without having been through an interview process it is probably a scam and you should contact complia...@naukri.com for advise. *To be on the top of Employer's Resume Search Update Your Resume Nowhttp://www.naukri.com/tieups/tieups.php?othersrcp=4794 * *Your Resume has only 30 seconds to impress a Recruiter. Get your resume written by Experts.http://resume.naukri.com/resume-writing-services?fftid=73 Call 1800-102-5557 now! (Toll-Free)* -- 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
RE: $$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-23,56,67,X30 in cell c34 to be written as X6-1 in cell c34 X6-4 in cell c35
HI, Hope this will meet your expectation Sub SeperateData() Dim varVal As Variant Dim lngLoop As Long Dim rngRangeAs Range Dim strIni As String Dim strFinalAs String Dim strTemp As String Dim lngVal As Long Dim lngCell As Long Set rngRange = ActiveSheet.Range(E6:E34) For lngCell = 0 To rngRange.Rows.Count If LCase(rngRange.Resize(1, 1).Offset(lngCell).Value) Like ?x* Or LCase(rngRange.Resize(1, 1).Offset(lngCell).Value) Like x* Then varVal = Split(rngRange.Resize(1, 1).Offset(lngCell), ,) For lngLoop = LBound(varVal) To UBound(varVal) If LCase(varVal(lngLoop)) Like x* Or LCase(varVal(lngLoop)) Like ?x* Then strIni = varVal(lngLoop) strFinal = strIni Else strTemp = For lngVal = 0 To UBound(Split(strIni, -)) If lngVal UBound(Split(strIni, -)) Then strTemp = strTemp IIf(Split(strIni, -)(lngVal) , Split(strIni, -)(lngVal), -) End If Next lngVal If Evaluate(=mid( varVal(lngLoop) ,1,1)) = - Then varVal(lngLoop) = Evaluate(=mid( varVal(lngLoop) ,2,LEN( varVal(lngLoop) )-1)) End If strFinal = strTemp - varVal(lngLoop) End If rngRange.Resize(1, 1).Offset(lngCell + lngLoop).Value = strFinal Next lngLoop End If Next lngCell End Sub Regards, Lalit Mohan www.excelfox.com/forum From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijay yadav Sent: Thursday, June 28, 2012 4:49 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-23,56,67,X30 in cell c34 to be written as X6-1 in cell c34 X6-4 in cell c35 and so on.. Thanks Lalit_Mohan for the prompt reply But still iam not getting the expected output. I am attaching excel sheet ,please have a look and help me with the macro. Regards Vijay On Thursday, 28 June 2012 16:21:07 UTC+5:30, Lalit_Mohan wrote: Hi Vijay, Hope it helps you Sub SeperateData() Dim varVal As Variant Dim lngLoop As Long Dim rngRangeAs Range Dim strIni As String Dim strFinalAs String Set rngRange = ActiveSheet.Range(A1) varVal = Split(rngRange.Value, ,) For lngLoop = LBound(varVal) To UBound(varVal) If LCase(varVal(lngLoop)) Like x* Then strIni = varVal(lngLoop) strFinal = strIni Else strFinal = Split(strIni, -)(0) - varVal(lngLoop) End If rngRange.Offset(lngLoop) = strFinal Next lngLoop End Sub change accordingly Regards, Lalit Mohan -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to
Re: $$Excel-Macros$$ Need Help !!! How to add sheet under another sheet
Hi Friends, Thanks All for your valuable solution. But, I need excel sheet when we click on its header so that I could able to modify data. Please Help !!! On 6/28/12, Rajan_Verma rajanverma1...@gmail.com wrote: Use this One .. Problem is not identified but when I click on Twice on Design button it works , may be it is a bug.. L , will get back to you on this. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lalit Mohan Sent: 28 June 2012 8:04 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help !!! How to add sheet under another sheet Hi Rajan, It Looks great but scroll bar is not working in the list box. Regards, Lalit Mohan www.excelfox.com/forum From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Thursday, June 28, 2012 8:01 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help !!! How to add sheet under another sheet Hi You Can Refer attached sheet., Event will fire on Double Click , When you will double click you will get the desired result Description: cid:image003.png@01CD5568.CA9AE140 Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ahmed Honest Sent: 27 June 2012 11:46 To: excel-macros@googlegroups.com; mangesh.da...@gmail.com Subject: Re: $$Excel-Macros$$ Need Help !!! How to add sheet under another sheet Hi Mangesh, Try using from Insert Menu -- Object -- choose Create from file and locate your sheet path that is available in your respective file then an Icon is displayed so being in a sheet when you click on that Icon you will get another sheet. Revert if you failed to understand the above. I think this option should meet your requirement 100%. Hi Rajan, Try to read of what I have mentioned above and review accordingly and comment of what you think about this ?? :-) Thanks, Ahmed Bawazir On Wed, Jun 27, 2012 at 6:03 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need sheet under another sheet. I have provided explanation in attached sheet. Please help. -- With regards, MaNgEsH -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@googlegroups.com -- Ahmed Bawazir احمد باوزير -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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
Re: $$Excel-Macros$$ Fwd: MIS executive opening with Aricent Technologies (Contact to Hire)
Hi Noorain, I think job related to excel vba mail should not be banned. 1. it will help to user to know what is in current demand in excel related job. 2. it will encourage to learn and solve more excels quiz. 3. in last each enhanced skill is used to get better job options. Regards. Divaker On Thu, Jun 28, 2012 at 7:29 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Jitu, As per Forum rule, Job related mail has been banned. Brother take care in future. On Thu, Jun 28, 2012 at 4:17 PM, Jitendra singh jeete2...@gmail.comwrote: -- Forwarded message -- From: RJT Compuquest so...@rjtcindia.com Date: Thu, Jun 28, 2012 at 1:26 PM Subject: MIS executive opening with Aricent Technologies (Contact to Hire) To: jeete2...@gmail.com The sender of this email is registered with Naukri.com as RJT Compuquest *Experience required for the Job:* 2 - 3 years *Job Location:* Gurgaon Apply Nowhttp://apply.naukri.com/Apply/mn_Apply.php?applytype=singleApplyMode=1src=rmjmessageId=bb0fc18dbdd6dbcbdf2e98fe9faaf5c7445f0d5954061a0252021f1a0e781c0b4440484f091812415b010c131b10125b5(Send your Naukri profile to express interest to the recruiter) *Dear Candidate,* Hello, Greetings of the Day!!! We have MIS Executive Opening with Client :Aricent Technologies,Gurgaon (Working on a payroll of RJT) About Aricent(CLient): Our Client is a global innovation, technology and services company focused exclusively on communications. Its unique engagement model blends strategy, design, technology and engineering services, delivering exceptional value across each phase of the product and service lifecycle. Together with its global innovation arm frog design, offers 40 years experience in delivering innovation and technology breakthroughs that have transformed entire industries. With more than 800 clients, 9500 employees in 19 countries,more than 100 industry awards. It is uniquely positioned to help organizations conceive and commercialize innovative solutions. Please fill this below details: Currrent CTC: Expected CTC: Notice Period: DOB: Roles Responsbilities: Expertise in MS-Excel, MS-Power Point, MS-Word MS- Access Good analytical management skills Ability to relate various data sources for comparing/contrasting Ability to interpret requirements be self driven Preparing presenting appropriate reports as when required Maintain data pertaining to all departments - OM, Finance Accounts, HR Admin, Sales Service, Education Handling different projects assignment as when required Qualification: Any Graduate Location: Gurgaon Please forward your updated resume and also refer your friend or colleague who are interested to change. Awaiting your prompt reply. Thanks Regards Sonia Gupta Is this job relevant to you? Yeshttp://jobsearch.naukri.com/mynaukri/jobs_feedback.php?response=yesmid=7057569 Nohttp://jobsearch.naukri.com/mynaukri/jobs_feedback.php?response=nomid=7057569 Your feedback would help us in sending you the most relevant job opportunities Disclaimer: The sender of this email is registered with naukri.com as *RJT Compuquest* (gau...@rjtcindia.com, 736 Udyog Vihar Ph - V Gurgaon, HR, GURGAON, Haryana - 122001) using Naukri.com services. The responsibility of checking the authenticity of offers/correspondence lies with you. If you consider the content of this email inappropriate or spam, you may: 1. Report abuse by forwarding this email to: complia...@naukri.com 2. You can also Block this Companyhttp://my.naukri.com/BlockCompany/edit/cid/32550from searching your resume in the database. Advisory: Please do not pay any money to anyone who promises to find you a job. This could be in the form of a registration fee, or document processing fee or visa charges or any other pretext. The money could be asked for upfront or it could be asked after trust has been built after some correspondence has been exchanged. Also please note that in case you get a job offer or a letter of intent without having been through an interview process it is probably a scam and you should contact complia...@naukri.com for advise. *To be on the top of Employer's Resume Search Update Your Resume Nowhttp://www.naukri.com/tieups/tieups.php?othersrcp=4794 * *Your Resume has only 30 seconds to impress a Recruiter. Get your resume written by Experts.http://resume.naukri.com/resume-writing-services?fftid=73 Call 1800-102-5557 now! (Toll-Free)* -- 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)
Re: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet
Hi Ahmed, Thanks but it is not solution to my problem. On 6/28/12, Ahmed Honest ahmedhon...@gmail.com wrote: Hi Mangesh, Try using from Insert Menu -- Object -- choose Create from file and locate your sheet path that is available in your respective file then an Icon is displayed so being in a sheet when you click on that Icon you will get another sheet. Revert if you failed to understand the above. I think this option should meet your requirement 100%. Thanks, Ahmed Bawazir On Thu, Jun 28, 2012 at 7:46 AM, Lalit_Mohan mohan.pande...@gmail.comwrote: Hi, This kind of functionality is available in excel i don't know but we can achieve this not exactle but will look like this by using paste data as picture link. I don't know how much it will helful to you. Regards, Lalit Mohan On Wednesday, 27 June 2012 20:33:43 UTC+5:30, Mangesh wrote: Hi Friends, I need sheet under another sheet. I have provided explanation in attached sheet. Please help. -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Ahmed Bawazir *احمد باوزير* -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
RE: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet
That’s not possible Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mangesh Vimay Sent: 28 June 2012 8:49 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet Hi Ahmed, Thanks but it is not solution to my problem. On 6/28/12, Ahmed Honest ahmedhon...@gmail.com wrote: Hi Mangesh, Try using from Insert Menu -- Object -- choose Create from file and locate your sheet path that is available in your respective file then an Icon is displayed so being in a sheet when you click on that Icon you will get another sheet. Revert if you failed to understand the above. I think this option should meet your requirement 100%. Thanks, Ahmed Bawazir On Thu, Jun 28, 2012 at 7:46 AM, Lalit_Mohan mohan.pande...@gmail.comwrote: Hi, This kind of functionality is available in excel i don't know but we can achieve this not exactle but will look like this by using paste data as picture link. I don't know how much it will helful to you. Regards, Lalit Mohan On Wednesday, 27 June 2012 20:33:43 UTC+5:30, Mangesh wrote: Hi Friends, I need sheet under another sheet. I have provided explanation in attached sheet. Please help. -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Ahmed Bawazir *احمد باوزير* -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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.
RE: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet
Hi, I have modified Rajan's code A closer way to see the data as sheet on cell's double click Please find the attached. Regards, Lalit Mohan www.excelfox.com/forum -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mangesh Vimay Sent: Thursday, June 28, 2012 8:49 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet Hi Ahmed, Thanks but it is not solution to my problem. On 6/28/12, Ahmed Honest ahmedhon...@gmail.com wrote: Hi Mangesh, Try using from Insert Menu -- Object -- choose Create from file and locate your sheet path that is available in your respective file then an Icon is displayed so being in a sheet when you click on that Icon you will get another sheet. Revert if you failed to understand the above. I think this option should meet your requirement 100%. Thanks, Ahmed Bawazir On Thu, Jun 28, 2012 at 7:46 AM, Lalit_Mohan mohan.pande...@gmail.comwrote: Hi, This kind of functionality is available in excel i don't know but we can achieve this not exactle but will look like this by using paste data as picture link. I don't know how much it will helful to you. Regards, Lalit Mohan On Wednesday, 27 June 2012 20:33:43 UTC+5:30, Mangesh wrote: Hi Friends, I need sheet under another sheet. I have provided explanation in attached sheet. Please help. -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Ahmed Bawazir *احمد باوزير* -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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
Re: $$Excel-Macros$$ Fwd: MIS executive opening with Aricent Technologies (Contact to Hire)
Totally agreed. Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: Divaker Pandey divake...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, 28 June 2012 8:44 PM Subject: Re: $$Excel-Macros$$ Fwd: MIS executive opening with Aricent Technologies (Contact to Hire) Hi Noorain, I think job related to excel vba mail should not be banned. 1. it will help to user to know what is in current demand in excel related job. 2. it will encourage to learn and solve more excels quiz. 3. in last each enhanced skill is used to get better job options. Regards. Divaker On Thu, Jun 28, 2012 at 7:29 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Jitu, As per Forum rule, Job related mail has been banned. Brother take care in future. On Thu, Jun 28, 2012 at 4:17 PM, Jitendra singh jeete2...@gmail.com wrote: -- Forwarded message -- From: RJT Compuquest so...@rjtcindia.com Date: Thu, Jun 28, 2012 at 1:26 PM Subject: MIS executive opening with Aricent Technologies (Contact to Hire) To: jeete2...@gmail.com The sender of this email is registered with Naukri.com as RJT Compuquest Experience required for the Job: 2 - 3 years Job Location: Gurgaon Apply Now(Send your Naukri profile to express interest to the recruiter) Dear Candidate, Hello, Greetings of the Day!!! We have MIS Executive Opening with Client :Aricent Technologies,Gurgaon (Working on a payroll of RJT) About Aricent(CLient): Our Client is a global innovation, technology and services company focused exclusively on communications. Its unique engagement model blends strategy, design, technology and engineering services, delivering exceptional value across each phase of the product and service lifecycle. Together with its global innovation arm frog design, offers 40 years experience in delivering innovation and technology breakthroughs that have transformed entire industries. With more than 800 clients, 9500 employees in 19 countries,more than 100 industry awards. It is uniquely positioned to help organizations conceive and commercialize innovative solutions. Please fill this below details: Currrent CTC: Expected CTC: Notice Period: DOB: Roles Responsbilities: Expertise in MS-Excel, MS-Power Point, MS-Word MS- Access Good analytical management skills Ability to relate various data sources for comparing/contrasting Ability to interpret requirements be self driven Preparing presenting appropriate reports as when required Maintain data pertaining to all departments - OM, Finance Accounts, HR Admin, Sales Service, Education Handling different projects assignment as when required Qualification: Any Graduate Location: Gurgaon Please forward your updated resume and also refer your friend or colleague who are interested to change. Awaiting your prompt reply. Thanks Regards Sonia Gupta Is this job relevant to you? Yes No Your feedback would help us in sending you the most relevant job opportunities Disclaimer: The sender of this email is registered with naukri.com as RJT Compuquest (gau...@rjtcindia.com, 736 Udyog Vihar Ph - V Gurgaon, HR, GURGAON, Haryana - 122001) using Naukri.com services. The responsibility of checking the authenticity of offers/correspondence lies with you. If you consider the content of this email inappropriate or spam, you may: 1. Report abuse by forwarding this email to: complia...@naukri.com 2. You can also Block this Company from searching your resume in the database. Advisory: Please do not pay any money to anyone who promises to find you a job. This could be in the form of a registration fee, or document processing fee or visa charges or any other pretext. The money could be asked for upfront or it could be asked after trust has been built after some correspondence has been exchanged. Also please note that in case you get a job offer or a letter of intent without having been through an interview process it is probably a scam and you should contact complia...@naukri.com for advise. To be on the top of Employer's Resume Search Update Your Resume Now Your Resume has only 30 seconds to impress a Recruiter. Get your resume written by Experts. Call 1800-102-5557 now! (Toll-Free) -- 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
Re: $$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-23,56,67,X30 in cell c34 to be written as X6-1 in cell c34 X6-4 in cell c35
Nice Pandey ;) On Fri, Jun 29, 2012 at 12:22 AM, vijay yadav vijay.ganesh.ya...@gmail.comwrote: Thanks Lalit_Mohan ,You are a genius,great work done. This gives me 95 % correct results but due to 2 bug or errors I have to check everything and correct it. The bug or errors are 1)THE X AT RIGHT SHOULD TAKE PRECEDENCE 2)THE MACRO DOESN'T WORK ON SOME CELLS I have attached the sheet with macro inserted,the output and expected output with bug or error marked in color. Please have a look and provide me the solution Regards Vijay yadav On Thursday, 28 June 2012 19:49:47 UTC+5:30, Lalit_Mohan wrote: HI, Hope this will meet your expectation Sub SeperateData() Dim varVal As Variant Dim lngLoop As Long Dim rngRangeAs Range Dim strIni As String Dim strFinalAs String Dim strTemp As String Dim lngVal As Long Dim lngCell As Long Set rngRange = ActiveSheet.Range(E6:E34) For lngCell = 0 To rngRange.Rows.Count If LCase(rngRange.Resize(1, 1).Offset(lngCell).Value) Like ?x* Or LCase(rngRange.Resize(1, 1).Offset(lngCell).Value) Like x* Then varVal = Split(rngRange.Resize(1, 1).Offset(lngCell), ,) For lngLoop = LBound(varVal) To UBound(varVal) If LCase(varVal(lngLoop)) Like x* Or LCase(varVal(lngLoop)) Like ?x* Then strIni = varVal(lngLoop) strFinal = strIni Else strTemp = For lngVal = 0 To UBound(Split(strIni, -)) If lngVal UBound(Split(strIni, -)) Then strTemp = strTemp IIf(Split(strIni, -)(lngVal) , Split(strIni, -)(lngVal), -) End If Next lngVal If Evaluate(=mid( varVal(lngLoop) ,1,1)) = - Then varVal(lngLoop) = Evaluate(=mid( varVal(lngLoop) ,2,LEN( varVal(lngLoop) )-1)) End If strFinal = strTemp - varVal(lngLoop) End If rngRange.Resize(1, 1).Offset(lngCell + lngLoop).Value = strFinal Next lngLoop End If Next lngCell End Sub *Regards,* *Lalit Mohan* *www.excelfox.com/forum* *From:* excel-macros@googlegroups.com [mailto:excel-macros@** googlegroups.com excel-macros@googlegroups.com] *On Behalf Of *vijay yadav *Sent:* Thursday, June 28, 2012 4:49 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: want data seperated by hypen - and comma , to be written in rows existing below eg X6-1,4,5,6,9,X7-23,56,67,X30 in cell c34 to be written as X6-1 in cell c34 X6-4 in cell c35 and so on.. Thanks Lalit_Mohan for the prompt reply But still iam not getting the expected output. I am attaching excel sheet ,please have a look and help me with the macro. Regards Vijay On Thursday, 28 June 2012 16:21:07 UTC+5:30, Lalit_Mohan wrote: Hi Vijay, Hope it helps you Sub SeperateData() Dim varVal As Variant Dim lngLoop As Long Dim rngRangeAs Range Dim strIni As String Dim strFinalAs String Set rngRange = ActiveSheet.Range(A1) varVal = Split(rngRange.Value, ,) For lngLoop = LBound(varVal) To UBound(varVal) If LCase(varVal(lngLoop)) Like x* Then strIni = varVal(lngLoop) strFinal = strIni Else strFinal = Split(strIni, -)(0) - varVal(lngLoop) End If rngRange.Offset(lngLoop) = strFinal Next lngLoop End Sub change accordingly Regards, Lalit Mohan -- 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 To unsubscribe, send a blank email to excel-macros+unsubscribe@** googlegroups.com excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula
Re: $$Excel-Macros$$ Fwd: MIS executive opening with Aricent Technologies (Contact to Hire)
Dear Divakar, Please see earlier discussion on this topic. Date: Sat, 16 Jun 2012 08:14:00 -0700 From: jainayus...@gmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: MIS executive Hi Yogananda, Please note that Job posting is allowed in this forum. Please do not post any jobs going forward. Thanks. On Saturday, 16 June 2012 16:41:50 UTC+5:30, (%Allmydreams%) wrote: Hi, We have a opening for MIS - Executive in Bangalore location. Do call my below number on next coming monday. Its Urgent requirement 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Mangesh Vimay mangesh.da...@gmail.com Jun 18 (11 days ago) to excel-macros Hi Friends, I am agree with Yogananda because many people are spending their time here to learn excel concepts with the intention to get the job and hence if someone is providing such nice opportunities then I think it is good. Moreover, only related job posting should be there (with excel, access only). Thanks. pankaj gmail account pankaji...@gmail.com Jun 18 (11 days ago) to excel-macros Hi To All, I also agree that we should also think about Job Posting in this forum. If a Needy gets Job with our help that's the best result of the forum. OK I also agree that this is not a Job Forum but instead of joining other Job forums we should think some alternative like we can use some Mandatory Subject Line etc JOB:- Posting :-- Job Details- Dear Moderator Please think Excel do not pay much and now a days we are facing lots of competition with other BI tools and i think excel should be promoted more by sharing knowledge/jobs. Thanks and Regards, Pankaj yogananda muthaiah yogananda.mutha...@gmail.com Jun 18 (11 days ago) to excel-macros Hi, Thank you everyone who has given a feedback to Ayush and he may come take this as +ve feedback. Please do call me if someone who is really looking for MIS profile and ready for face to face interview. -- Ayush Jain jainayus...@gmail.com Jun 18 (11 days ago) to excel-macros Hello All, Thank you for sharing your views. When I allowed the job posting earlier, people started posting all kind of jobs. For me it is very difficult to moderate each job posts, and ban people just because of job posting. I will definitely think of channelising the job posts or add a link where you can post the jobs. For now, Job posting is NOT allowed in forum. Let me know if you still have any queries. Thanks and best regards Ayush Jain Group Manager Microsoft MVP in.vaib...@gmail.com Jun 18 (11 days ago) to excel-macros Hi Ayush, Why can't we have separate team of moderator like other sites. -- *From: * Ayush Jain jainayus...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Mon, 18 Jun 2012 23:02:07 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Re: MIS executive Sam Mathai Chacko samde...@gmail.com Jun 18 (11 days ago) to excel-macros I would appreciate if you could take the discussion about job postings off of the forum. Ayush has stated his decision regarding job postings as of now. As he mentioned, once this is allowed, people start abusing the option. That is why it has been banned. For job seekers, there are numerous job sites out there for Excel or related jobs. The volunteers here don't come here to see job ads, but to help others with solutions from their expertise and experience. As a member, I would only request everybody to keep the faith until Ayush figures out how this can be addressed. So PLEASE STOP PESTERING. Sam Mathai Chacko Ayush Jain jainayus...@gmail.com Jun 18 (11 days ago) to excel-macros Vaibhav, Allowing job posts is not only moderation but an invitation to spammers, recruiters and employers for job posting. I really do not want that to happen in this forum. Banning job posts is not my sole decision but decided after the feedback of many members in this forum. Let's keep the scope of this forum limited to excel related queries only, Regards in.vaib...@gmail.com
Re: $$Excel-Macros$$ Enable Disable Ctrl+D with passward
Hi gm experts, is anybody solve my problem reg. disable ctrl+d option. Iam waiting for solution for the problem. On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E emuralidha...@gmail.comwrote: Hi group, Because of CTRl+D just fill down the data iam facing this problem, when i want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not observing it later it was effecting to the data. So i what i need is i want to *disable Ctrl+D with a passward* and same time i want to *enable with a passward*. I think it will usefull for others also. Thanks in Advance. On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Do you have any add-in or macro in personal.xlsb which have any macro assigned Ctrl+D?? Because excel default Ctrl+D just fill down the data. * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E *Sent:* 27 June 2012 3:18 *To:* excel-macros@googlegroups.com *Cc:* ahmedhon...@gmail.com *Subject:* Re: $$Excel-Macros$$ Enable Disable Ctrl+D with passward ** ** Hi, But it will not come to the notice at the same time, it was accidently going on, iam not observing it later it was effecting to the data. On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest ahmedhon...@gmail.com wrote: Dear, I think using Ctrl + Z will allow you to take back the action you performed i.e Undo the last action ;-). This should help. If not, check other experts advice. Thanks, On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E emuralidha...@gmail.com wrote: Dear all, Iam using Office 2007, when iam need to use Crl+F accidently iam hitting Ctrl+D, iam loosing some data and iam unable to find the changes happening to the data file. Iam want to disable Ctrl+D option with a passward and the same enable with passward, it should for that worksheet only. Thanks in advance. -- *Thanks Regards,* *Muralidhar E.* ** ** -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Ahmed Bawazir *احمد باوزير* ** ** -- *Thanks Regards,* *Muralidhar E.* ** ** -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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.
Re: $$Excel-Macros$$ Re: Can I get the day of the week (e.g. Friday) from the date already encoded in a string?
Thanks Asa and belatedly Noorain. The format function worked and as it happens the other method was returning the wrong day for all those who might use it. The .value2 does not seem to be necessary but I left it anyway. On Wednesday, June 27, 2012 10:09:16 PM UTC-7, tangledweb wrote: Asa! Good to hear from you. I am fine. Hope the same for you. The example I posted seemed to work but I admit I did not check to see if the correct day was returned. Tomorrow I will do that and try out your format function version (which I think someone else posted earlier but I had not tried it yet). On Wed, Jun 27, 2012 at 9:35 PM, Asa Rossoff a...@lovetour.info wrote: Hi! Hope you are well. The VBA way is to use VBA's Format function (Replace CELL with the range object for the cell desired): Format(CELL.Value2, ) If you wanted to use the TEXT function, the example given -- I believe -- will return incorrect results. These versions would return the correct result (replace WORKSHEET/CELL): Worksheetfunction.Text(CELL, ) WORKSHEET.evaluate(text( CELL.address ,)) WORKSHEET.evaluate(text( CELL.value2 ,)) WORKSHEET.evaluate(text( CELL.value ,)) The Format function would be my preference, but of the TEXT function versions, the first is most efficient, then second, then third. The first uses a cell reference to supply the date value, the second a dateserial (Value2 returns a number for dates), the third a text representation of the date (the Value property converts date/time values on the worksheet to VBA's Date datatype, but when you concatenate it with a string, VBA's datatype coercion behavior is to convert it to a text representation using the system locale's short date and/or short time settings). The previous example acquired the cell value via it's Text property, which is dangerous and rarely desired. Text returns the value of the cell as formatted, but if the column is hidden, it returns an empty string. Also, the Day function will cause trouble. It's a common misunderstanding to think it should be used with the Text function, but this is almost never desired. Day returns a number between 1 and 7 to indicate the day of the week. Text formats dates or dateserial numbers, not day numbers. Text will interpret numbers between 1 and 7 as the first 7 days on it's dateserial calendar, which are 1/1/1900 through 1/7/1900. Asa From: excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] On Behalf Of tangledweb Sent: Wednesday, June 27, 2012 8:23 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Can I get the day of the week (e.g. Friday) from the date already encoded in a string? The custom format will not work as I need the data to have the date except for one special test. This worked so thanks Lalit. Evaluate(=Text(Day( Sheets(RawData).Cells(count, BarDate).Text ), )) Oddly when I used Sheet1 instead of RawData which is the same sheet I got a subscript out of range but worked fine with the alias. On Tuesday, June 26, 2012 8:47:02 PM UTC-7, tangledweb wrote: If I already have Sheets(RawData).Cells(count, BarDate).Text having a value like 6/26/2012 is there a way to get the day of the week as a number or string for that date that does not require splitting it into its parts and feeding them to some function? If the latter the .net examples I found for that did not make sense to me so how is it done? -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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