$$Excel-Macros$$ Error in 2010
Dear All, I am face the attached Error in 2010 while saving active workbook on recording macro. [cid:image001.png@01CD8799.C70A4EE0] Regards, Shrinivas -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. inline: image001.png
RE: $$Excel-Macros$$ Introduce Myself !!
Hi Friends, My name is Shrinivas Chidurala, Currently living in Bangalore. Working in Citi Bank as a Sr. Associate from post 5 years - Security Analyst. Regards, Shrinivas From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: Wednesday, June 13, 2012 11:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Introduce Myself !! Hi all members, My name is Ashish Bhalara from Rajkot (Gujarat) I'm 26 year old studied B.Com MBA (Finance) I also learn Foxpro, VisualBasic, CC++ in my college in 2005 2006. I working in company of automobiles since 6 year in account field and currently working on position of Account Manager. I mostly use of excel in my working, due to knowledge of programming languages I can easily use of all the functions and also data analysis tools of excel but i was not aware of VBA macro. I have the basic knowledge of Programming language like different type of variable, looping, If, etc due to Visual Basic. I join this group from last 3 month and lots of thing I learn by FAQ. I'm very enjoy to read different type of queries in this group. I suggest you to create a website of excel-macro in which all the experts, forums, educations, different topic, field, news etc are come together and spread as worldwide. Happy working... Thanks regards. Ashish Bhalara 9624111822 -- Forwarded message -- From: alvin567 defalca...@gmail.commailto:defalca...@gmail.com Date: Tue, Jun 12, 2012 at 12:55 PM Subject: $$Excel-Macros$$ Re: Introduce Yourself !! To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com On Friday, June 8, 2012 10:21:59 PM UTC+3, Ayush Jain wrote: Hey all new and current posters, Welcome to excel group,one of the largest online community of excel Fans! I hope you enjoy your time here find this forum to be a friendly and knowledgeable community. Please feel free to post a small introduction, a friendly hello or tell us a bit about yourself. Why not tell us where are you from, what you do, what your interests are, how old you are, which is your favourite excel site or blog is or anything else that comes to mind! Thanks for your time Ayush Jain Group Manager Microsoft MVP On Friday, June 8, 2012 10:21:59 PM UTC+3, Ayush Jain wrote: Hey all new and current posters, Welcome to excel group,one of the largest online community of excel Fans! I hope you enjoy your time here find this forum to be a friendly and knowledgeable community. Please feel free to post a small introduction, a friendly hello or tell us a bit about yourself. Why not tell us where are you from, what you do, what your interests are, how old you are, which is your favourite excel site or blog is or anything else that comes to mind! Thanks for your time Ayush Jain Group Manager Microsoft MVP -- 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%2bunsubscr...@googlegroups.com -- Thanks regards. Ashish Bhalara 9624111822 -- 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
RE: $$Excel-Macros$$ Re: Error while running macro
Divaker, I am facing the below error while running macro. Please can you advise on the same. [cid:685132014@19032012-07C1] Regards, Shrinivas From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Divaker Pandey Sent: Monday, March 19, 2012 3:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Error while running macro can u write what error you got. or you can also send screen-shot of error Divaker On Mon, Mar 19, 2012 at 3:30 PM, SHREE chidurala.sh...@gmail.commailto:chidurala.sh...@gmail.com wrote: On Mar 15, 3:48 pm, Chidurala, Shrinivas shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com wrote: Hi I am facing the below error while running below macro. Please can you advise on the same. Thank you for your help ! Sub Convert_HTML_to_Excel() Application.ScreenUpdating = False Dim fldpth As String Dim fld, fil As Object Dim j, a As Long Dim ask, ask2 As Workbook 'fldpth = SelectFolder(Select Folder, ) fldpth = C:\Documents and Settings\sc52912\Desktop\New Folder\New Folder (2) Set Fso = CreateObject(scripting.filesystemobject) Set fld = Fso.GetFolder(fldpth) For Each fil In fld.Files Set ask2 = Workbooks.Open(fil.path) ask2.Activate Rows(3:5).Select Selection.Insert Shift:=xlDown Range(C1).Value = Page : 1 Range(A1).Select Dim path As String path = (C:\Documents and Settings\sc52912\Desktop\New Folder\New Folder (2)\ + ActiveSheet.Name) ActiveWorkbook.SaveAs FileName:=path, FileFormat:=51 ask2.Close Next fil Application.ScreenUpdating = True MsgBox Macro Successfully Run, , OK End Sub Regards, Shrinivas Picture (Device Independent Bitmap) 1.jpg 30KViewDownload -- 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 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com inline: Outlook.jpg
RE: $$Excel-Macros$$ Re: Error while running macro
Hi Noorain Sir, If I write xlExcel7 instead of 51, the macro is running but the some part of disclaimer in the report are missing in output and if I ok in below screen shot then it is running properly. ActiveWorkbook.SaveAs FileName:=path, FileFormat:=51 Please can you advise on the same. Regards, Shrinivas From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Monday, March 19, 2012 9:51 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Error while running macro Dear Shrinivas, Check below link http://office.microsoft.com/en-us/excel-help/use-office-excel-2010-with-earlier-versions-of-excel-HA010342994.aspx On Mon, Mar 19, 2012 at 7:51 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com wrote: Divaker, I am facing the below error while running macro. Please can you advise on the same. [cid:541262416@19032012-07C8] Regards, Shrinivas From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of Divaker Pandey Sent: Monday, March 19, 2012 3:43 PM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Error while running macro can u write what error you got. or you can also send screen-shot of error Divaker On Mon, Mar 19, 2012 at 3:30 PM, SHREE chidurala.sh...@gmail.commailto:chidurala.sh...@gmail.com wrote: On Mar 15, 3:48 pm, Chidurala, Shrinivas shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com wrote: Hi I am facing the below error while running below macro. Please can you advise on the same. Thank you for your help ! Sub Convert_HTML_to_Excel() Application.ScreenUpdating = False Dim fldpth As String Dim fld, fil As Object Dim j, a As Long Dim ask, ask2 As Workbook 'fldpth = SelectFolder(Select Folder, ) fldpth = C:\Documents and Settings\sc52912\Desktop\New Folder\New Folder (2) Set Fso = CreateObject(scripting.filesystemobject) Set fld = Fso.GetFolder(fldpth) For Each fil In fld.Files Set ask2 = Workbooks.Open(fil.path) ask2.Activate Rows(3:5).Select Selection.Insert Shift:=xlDown Range(C1).Value = Page : 1 Range(A1).Select Dim path As String path = (C:\Documents and Settings\sc52912\Desktop\New Folder\New Folder (2)\ + ActiveSheet.Name) ActiveWorkbook.SaveAs FileName:=path, FileFormat:=51 ask2.Close Next fil Application.ScreenUpdating = True MsgBox Macro Successfully Run, , OK End Sub Regards, Shrinivas Picture (Device Independent Bitmap) 1.jpg 30KViewDownload -- 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 -- 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 -- 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
$$Excel-Macros$$ Error while running macro
Hi I am facing the below error while running below macro. Please can you advise on the same. Thank you for your help ! Sub Convert_HTML_to_Excel() Application.ScreenUpdating = False Dim fldpth As String Dim fld, fil As Object Dim j, a As Long Dim ask, ask2 As Workbook 'fldpth = SelectFolder(Select Folder, ) fldpth = C:\Documents and Settings\sc52912\Desktop\New Folder\New Folder (2) Set Fso = CreateObject(scripting.filesystemobject) Set fld = Fso.GetFolder(fldpth) For Each fil In fld.Files Set ask2 = Workbooks.Open(fil.path) ask2.Activate Rows(3:5).Select Selection.Insert Shift:=xlDown Range(C1).Value = Page : 1 Range(A1).Select Dim path As String path = (C:\Documents and Settings\sc52912\Desktop\New Folder\New Folder (2)\ + ActiveSheet.Name) ActiveWorkbook.SaveAs FileName:=path, FileFormat:=51 ask2.Close Next fil Application.ScreenUpdating = True MsgBox Macro Successfully Run, , OK End Sub Regards, Shrinivas -- 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 inline: Picture (Device Independent Bitmap) 1.jpg
$$Excel-Macros$$ Next Working date
Dear Group, Please suggest any formula to pick next working date, but Saturday and Sunday should not include. Working day Next Working day 9-Feb-12 10-Feb-12 10-Feb-1213-Feb-12 Regards, Shrinivas -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Vlookup Help
Dear Team, I am creating macro for Recon of prices where facing problem in multiple vlookup. Find attached Recon file. Please any one help me the multiple vlookup function/coding multiple vlookup. Thanking in Advance. Regards, Shrinivas -- 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 Recon.xls Description: Recon.xls
RE: $$Excel-Macros$$ Splitting of files
: On Error GoTo ErrH End If Next lngCounter End Select Next lngSheetsInNewBook wbk.Close 0 Set wbk = Nothing lngSheetsInNewBook = Application.SheetsInNewWorkbook Application.SheetsInNewWorkbook = 3 For lngLoop = 1 To objCol.Count Set wbk = Workbooks.Add wbk.SaveAs strSavePath \ objCol.Item(lngLoop), ThisWorkbook.FileFormat wbk.Sheets(1).Name = Div wbk.Sheets(2).Name = bon wbk.Sheets(3).Name = right For lngSheetsInNewBook = 1 To UBound(Array(Div, bon, right)) + 1 Set wks = wbk.Worksheets(Array(Div, bon, right)(lngSheetsInNewBook - 1)) wks.Cells(6, 1).Resize(1, 4).Value = _ Array(Client Name, Client Account, Product, No.) Select Case lngSheetsInNewBook Case 1 Application.Goto wks.Cells(1) For lngCounter = 2 To UBound(varDiv) If varDiv(lngCounter, 1) = objCol.Item(lngLoop) Then wks.Cells(wks.Rows.Count, 1).End(xlUp)(2).Resize(1, 4).Value = Array(varDiv(lngCounter, 1), varDiv(lngCounter, 2), varDiv(lngCounter, 3), varDiv(lngCounter, 4)) End If Next lngCounter With wks.UsedRange.Borders .LineStyle = xlContinuous .Weight = xlThin .Parent.Rows(1).Font.Bold = True .Parent.EntireColumn.AutoFit End With Case 2 Application.Goto wks.Cells(1) For lngCounter = 2 To UBound(varBon) If varBon(lngCounter, 1) = objCol.Item(lngLoop) Then wks.Cells(wks.Rows.Count, 1).End(xlUp)(2).Resize(1, 4).Value = Array(varBon(lngCounter, 1), varBon(lngCounter, 2), varBon(lngCounter, 3), varBon(lngCounter, 4)) End If Next lngCounter With wks.UsedRange.Borders .LineStyle = xlContinuous .Weight = xlThin .Parent.Rows(1).Font.Bold = True .Parent.EntireColumn.AutoFit End With Case 3 Application.Goto wks.Cells(1) For lngCounter = 2 To UBound(varRight) If varRight(lngCounter, 1) = objCol.Item(lngLoop) Then wks.Cells(wks.Rows.Count, 1).End(xlUp)(2).Resize(1, 4).Value = Array(varRight(lngCounter, 1), varRight(lngCounter, 2), varRight(lngCounter, 3), varRight(lngCounter, 4)) End If Next lngCounter With wks.UsedRange.Borders .LineStyle = xlContinuous .Weight = xlThin .Parent.Rows(1).Font.Bold = True .Parent.EntireColumn.AutoFit End With End Select Next lngSheetsInNewBook Application.Goto wbk.Sheets(1).Cells(1) wbk.Close 1 Next lngLoop ErrH: Erase varDiv Erase varBon Erase varRight If Err.Number 0 Then MsgBox Err.Description, vbOKOnly + vbInformation, Unknown Error Err.Clear: On Error GoTo -1: On Error GoTo 0 Else MsgBox objCol.Count workbooks compiled in Timer - sngTimer seconds!, vbOKOnly + vbInformation, Consolidator End If Application.SheetsInNewWorkbook = lngSheetsInNewBook Application.ScreenUpdating = True Set wbk = Nothing Set wks = Nothing lngSheetsInNewBook = Empty strNewSourceFile = vbNullString Set objCol = Nothing lngCounter = Empty lngLoop = Empty End Sub On Mon, Oct 3, 2011 at 1:59 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com wrote: Thanks Mahesh, But it is capturing only div sheet, i want to capture all 3 sheets. Regards, Shrinivas From: Mahesh parab [mailto:mahes...@gmail.commailto:mahes...@gmail.com] Sent: Saturday, October 01, 2011 10:38 PM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com; Chidurala, Shrinivas [ICG-GTS] Subject: Re: $$Excel-Macros$$ Splitting of files Hi Shrinivas Try : Sub Mtest() Dim Rng As Range Dim ws As Worksheet Dim shname As String Dim i As Integer Dim shn As Long Dim mx As Variant Dim x As Integer Dim LR As Long Dim sPath As String, sFileName As String On Error Resume Next Application.DisplayAlerts = False Sheets(Temp).Delete Application.DisplayAlerts = True Set Rng = Sheets(Div).Range(A6:A Cells(Rows.Count, 1).End(xlUp).Row) Set ws2
RE: $$Excel-Macros$$ Splitting of files
Thanks Mahesh, But it is capturing only div sheet, i want to capture all 3 sheets. Regards, Shrinivas From: Mahesh parab [mailto:mahes...@gmail.com] Sent: Saturday, October 01, 2011 10:38 PM To: excel-macros@googlegroups.com; Chidurala, Shrinivas [ICG-GTS] Subject: Re: $$Excel-Macros$$ Splitting of files Hi Shrinivas Try : Sub Mtest() Dim Rng As Range Dim ws As Worksheet Dim shname As String Dim i As Integer Dim shn As Long Dim mx As Variant Dim x As Integer Dim LR As Long Dim sPath As String, sFileName As String On Error Resume Next Application.DisplayAlerts = False Sheets(Temp).Delete Application.DisplayAlerts = True Set Rng = Sheets(Div).Range(A6:A Cells(Rows.Count, 1).End(xlUp).Row) Set ws2 = Worksheets.Add(After:=Sheets(Sheets.Count)) With ws2 Rng.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=.Range(A1), unique:=True .Name = Temp End With Sheets(Temp).Columns(A).SpecialCells(xlCellTypeBlanks).Delete shift:=xlShiftUp LR = Sheets(Temp).Cells(Rows.Count, A).End(xlUp).Row For i = 2 To LR Cname = Sheets(Temp).Cells(i, 1) Set ws2 = Workbooks.Add mx = Array(Div, bon, right) shn = 1 - LBound(mx) For x = LBound(mx) To UBound(mx) Sheets(x + shn).Name = mx(x) Next x m = ws2.Name ThisWorkbook.Activate For Each ws In ThisWorkbook.Worksheets If ws.Name Temp Then ws.UsedRange.AutoFilter Field:=1, Criteria1:=Cname ws.UsedRange.SpecialCells(xlCellTypeVisible).Copy shname = ws.Name Application.Goto _ Workbooks(m).Sheets(shname).Cells(1, 1) ActiveSheet.Paste ThisWorkbook.Activate End If Next ws ws2.Activate 'Save the new workbook sPath = ThisWorkbook.Path \ 'sPath = C:\Users\MAHESH\Downloads\Delete\ sFileName = Cname .xls Application.DisplayAlerts = False ws2.SaveAs (sPath sFileName) ws2.Close True ThisWorkbook.Activate Next i End Sub HTH Mahesh On Sat, Oct 1, 2011 at 4:34 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com wrote: Dear All, I have dump file of 3 sheets which contain the data of some clients in each sheet, I want to split the files into client wise and also note the client name is all sheet is in column A. Please advise me to create macro. Find attached sample of dump file and client file for your reference. Regards, Shrinivas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ ***Macro Code Required to delete Zero value cell and its row***
Hi Mahesh, Find below coding to delete the contains 0 value from 13th row of column P. Sub Zero_data() Dim Firstrow As Long Dim Lastrow As Long Dim Lrow As Long Dim CalcMode As Long Dim ViewMode As Long Dim rng As Range With Application CalcMode = .Calculation .Calculation = xlCalculationManual .ScreenUpdating = False End With With ActiveSheet .Select ViewMode = ActiveWindow.View ActiveWindow.View = xlNormalView .DisplayPageBreaks = False Firstrow = .UsedRange.Cells(13).Row Lastrow = .UsedRange.Rows(.UsedRange.Rows.Count).Row For Lrow = Lastrow To Firstrow Step -1 With .Cells(Lrow, P) If Not IsError(.Value) Then If .Value = 0 Then If rng Is Nothing Then Set rng = .Cells Else Set rng = Application.Union(rng, .Cells) End If End If End If End With Next Lrow End With If Not rng Is Nothing Then rng.EntireRow.Delete ActiveWindow.View = ViewMode With Application .ScreenUpdating = True .Calculation = CalcMode End With End Sub Regards, Shrinivas From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Sent: Thursday, August 11, 2011 9:45 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ ***Macro Code Required to delete Zero value cell and its row*** Hi Mahesh, It is deleting entire row wherever zero appearing. But i required in a partiuclar column if Zero value found we need to delete entire row. Ex. If we use base as P column, In 13th row of P column contains 0 value it has to delete entire 13th Row. It should not search other columns. Regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Multiple excel files
Thank a lot Anish, It is working fine. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anish Shrivastava Sent: Friday, July 15, 2011 5:28 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Multiple excel files Hi Shrinivas, Attached please find the Dump file with macro. You will have to copy and paste your unique account numbers in Cell M1 before running the macro. Data will be splitted based on the account numbers and new files will be saved with account names. Also note that I have done it with Excel 2007, if you dont have this version, please let me know so that I can make it for 2003. Let me know if you face any issues with this macro. Below is the code for your ref. - Sub split_data() Dim lst_row, lst_col, i, j As Integer Dim ws_name As String Dim nwkb As Workbook Dim ac_num As String Dim uname As String Sheets(1).Rows(1).Select Selection.Insert shift:=xlDown lst_row = Sheets(1).Range(A2).End(xlDown).Row lst_col = Sheets(1).Range(A3).End(xlToRight).Column Range(A1, Cells(1, lst_col)).Select Selection.AutoFilter For j = 2 To Sheets(1).Range(M2).End(xlDown).Row ac_num = Sheets(1).Cells(j, M).Value uname = Environ(Username) ActiveSheet.Range(A1, Cells(lst_row, lst_col)).AutoFilter Field:=1, Criteria1:=ac_num For i = 2 To 1000 ' change to your ranges If Not Rows(i).Hidden Then theFirstUnhiddenRowinArea = i Range(B i).Select Exit For End If Next Range(Selection, Cells(lst_row, lst_col)).Select Selection.Copy Set nwkb = Workbooks.Add nwkb.Activate ActiveSheet.Paste nwkb.SaveAs C:\Users\ uname \Desktop\ ac_num .xlsx, FileFormat:=xlOpenXMLWorkbook nwkb.Close Next j Sheets(1).Rows(1).Delete shift:=xlUp End Sub -- Thanks, Anish On Fri, Jul 15, 2011 at 4:12 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com wrote: Dear Friends, Please help me create macro for splitting the dump file into multiple excel files as per account number in column A and file name should be account no. I have using the attached code for splitting the different dump file but it is not working in this dump file. Please advise on the same. Find attached sample of dump file , required format and code. Dump file Required file Thanking in advance. Regards, Shrinivas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Convert HTML file to Excel
Rajan, I am using Excel 2003 and the macro is not from coding Dim Fso As New Scripting.FileSystemObject . Regards, Shrinivas On Thu, Jul 7, 2011 at 10:45 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com wrote: Thanks a lot Rajan. But the below macro is not running in Excel 2003 or any reference need to select from Tools. Please confirm. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Thursday, July 07, 2011 1:23 AM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Convert HTML file to Excel See if it Help. Sub Compile() On Error GoTo Err_Clear: Application.ScreenUpdating = False Application.DisplayAlerts = False Dim Fso As New Scripting.FileSystemObject Dim Path As String Application.FileDialog(msoFileDialogFolderPicker).Title = Select Folder to Pick Downloaded Bills Application.FileDialog(msoFileDialogFolderPicker).Show Path = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) \ If Path = Then Exit Sub Application.FileDialog(msoFileDialogFolderPicker).Title = Select Folder to Save Compiled File CompilePath = Application.FileDialog(msoFileDialogFolderPicker).Show compiledPath = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) \ If compiledPath = Then Exit Sub Dim Counter Dim File As File Dim FOlder As FOlder Dim wb As Workbook Dim ws As Worksheet Dim AcWb As Workbook Set AcWb = ActiveWorkbook ActiveWorkbook.Sheets.Add ActiveSheet.Name = Index Set FOlder = Fso.GetFolder(Path) For Each File In FOlder.Files Counter = Counter + 1 Set wb = Workbooks.Open(Path File.Name) If Application.Ready = True Then wb.Sheets(Index).Activate ActiveSheet.UsedRange.Copy AcWb.Sheets(Index).Activate Range(A100).End(xlUp).Select ActiveSheet.Paste Application.CutCopyMode = False wb.Close End If Next If Counter 0 Then AcWb.SaveAs compiledPath Compiled, xlExcel12 AcWb.Close End If Err_Clear: Err.Clear Resume Next Application.DisplayAlerts = True Application.ScreenUpdating = True If Counter 1 Then MsgBox No File Found For Compile, vbInformation Else MsgBox Counter File Has been Compiled, Please Find your File at vbCrLf compiledPath, vbInformation End If End Sub -Original Message- From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of Chidurala, Shrinivas Sent: Wednesday, July 06, 2011 5:00 PM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Convert HTML file to Excel Dear Excel Gurus, I have some HTML files which are saved in same folder and I want to convert them into Excel and merger the all files into 1 workbook. Please help me to create the macro for the same. Find attached 2 HTML files and required report. Regards, Shrinivas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp
RE: $$Excel-Macros$$ Convert HTML file to Excel
Thanks a lot Rajan. But the below macro is not running in Excel 2003 or any reference need to select from Tools. Please confirm. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Thursday, July 07, 2011 1:23 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Convert HTML file to Excel See if it Help. Sub Compile() On Error GoTo Err_Clear: Application.ScreenUpdating = False Application.DisplayAlerts = False Dim Fso As New Scripting.FileSystemObject Dim Path As String Application.FileDialog(msoFileDialogFolderPicker).Title = Select Folder to Pick Downloaded Bills Application.FileDialog(msoFileDialogFolderPicker).Show Path = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) \ If Path = Then Exit Sub Application.FileDialog(msoFileDialogFolderPicker).Title = Select Folder to Save Compiled File CompilePath = Application.FileDialog(msoFileDialogFolderPicker).Show compiledPath = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) \ If compiledPath = Then Exit Sub Dim Counter Dim File As File Dim FOlder As FOlder Dim wb As Workbook Dim ws As Worksheet Dim AcWb As Workbook Set AcWb = ActiveWorkbook ActiveWorkbook.Sheets.Add ActiveSheet.Name = Index Set FOlder = Fso.GetFolder(Path) For Each File In FOlder.Files Counter = Counter + 1 Set wb = Workbooks.Open(Path File.Name) If Application.Ready = True Then wb.Sheets(Index).Activate Call bulkUpload.GenerateReport ActiveSheet.UsedRange.Copy AcWb.Sheets(Index).Activate Range(A100).End(xlUp).Select ActiveSheet.Paste Application.CutCopyMode = False wb.Close End If Next If Counter 0 Then AcWb.SaveAs compiledPath Compiled, xlExcel12 AcWb.Close End If Err_Clear: Err.Clear Resume Next Application.DisplayAlerts = True Application.ScreenUpdating = True If Counter 1 Then MsgBox No File Found For Compile, vbInformation Else MsgBox Counter File Has been Compiled, Please Find your File at vbCrLf compiledPath, vbInformation End If End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chidurala, Shrinivas Sent: Wednesday, July 06, 2011 5:00 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Convert HTML file to Excel Dear Excel Gurus, I have some HTML files which are saved in same folder and I want to convert them into Excel and merger the all files into 1 workbook. Please help me to create the macro for the same. Find attached 2 HTML files and required report. Regards, Shrinivas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros
RE: $$Excel-Macros$$ Macro to copy and paste selected raws.xls
Atul, Please use below coding it will help you to delete the blank cell of column A. Sub Macro6() Columns(A:A).Select Selection.SpecialCells(xlCellTypeBlanks).Select Selection.Delete Shift:=xlUp End Sub Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dilip Pandey Sent: Wednesday, June 29, 2011 12:16 PM To: excel-macros@googlegroups.com Cc: atul_pate...@yahoo.com Subject: Re: $$Excel-Macros$$ Macro to copy and paste selected raws.xls Hi Atul, You were clear in the first email itself. It is my mistake that I had overlooked the point. Now I have revised the macro and it should work fine. Feel free to get back in case of any queries. Thanks. Regards, DILIPandey On 6/29/11, Atul atul_pate...@yahoo.com wrote: Hi Dilipji, Thank you for your response. It seems that macro is hidiing weekends and holidays upon copying raws to the new file. Actually, I need macro to copy over only the first business day of each month for atleast next months. For that reason I highlighted selected raws in yellow. The ultimate result should contain only one raw for each month being the first business day of respective month. Please modify macro appropriately. I hope I could make it clear this time. Apology if it was not clear on earler email. Atul On Jun 27, 2:51 am, Dilip Pandey dilipan...@gmail.com wrote: Hi Atul, Please find a quick solution attached herewith :) Feel free to get back in case of any queries. Regards, DILIPandey On 6/27/11, Atul Patel atul_pate...@yahoo.com wrote: Attachment to my request. Attached is a sample file. I need a macro code to copy selected raws (yellow highlighted) from the liquidity tab of a given spreadsheet and paste to other file say 'Book1'. The selection criteria would be based on Column A. I want to copy first working day of each month. the day should not be either saturday, sunday or holidays. (you can have list of holidays on other tab approx 10 days in a given calendar year) Per my understanidng this task can be done other way also, copy entire spread sheet to Book1 and delete unwanted raws ( means raws not matching above criteria) Much wiill be appreciated if some one help me this. Thanks, Atul Atul Patel 905 785 8324(H) 647 898 4074(C) atul_pate...@yahoo.com atul_danga...@rediffmail.com Good to know you ! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India Macro to copy and paste selected raws.xls 55KViewDownload- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel --
RE: $$Excel-Macros$$ RE: Multiple file Formatting
Thanks a lot Ashish sir. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, April 27, 2011 12:47 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ RE: Multiple file Formatting save all work in a directory and run the macro and choose taht directory Function SelectFolder(Optional Title As String, Optional TopFolder _ As String) As String Dim objShell As New Shell32.Shell Dim objFolder As Shell32.Folder Set objFolder = objShell.BrowseForFolder _ (0, Title, 1, TopFolder) If Not objFolder Is Nothing Then SelectFolder = objFolder.Items.Item.Path End If End Function Sub FORMATMULTIPLE() application.screenupdating = false ' tool - reference - Microsoft shell control and automation Dim fldpth As String Dim fld, fil As Object Dim j, a As Long Dim ask, ask2 As Workbook fldpth = SelectFolder(Select Folder, ) Set fso = CreateObject(scripting.filesystemobject) Set fld = fso.getfolder(fldpth) For Each fil In fld.Files Set ask2 = Workbooks.Open(fil.Path) ask2.Activate -- paste your code for activeworkbook here ask2.Close Next fil application.screenupdating = true End Sub On Wed, Apr 27, 2011 at 2:15 AM, Muni muni.r...@gmail.commailto:muni.r...@gmail.com wrote: Hi Srinivas, if all the files are under same folder than u can write an macro which opens each file automatically and then which runs your macro for formatting. You can use fso file object and then you can open each file in the folder using the for next where u can call ur macros Hope this might help. Please let me know if you need any further help on this On Tue, Apr 26, 2011 at 11:46 AM, Chidurala, Shrinivas shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com wrote: Please help. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com -Original Message- From: Chidurala, Shrinivas [ICG-GTS] Sent: Monday, April 25, 2011 9:10 PM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: Multiple file Formatting Dear Gurus, I have created the attached macro for formatting of 50 to 60 files everyday which are receive from system. But to run this macro i need to open and then run. It taking too much time. Please can you advise to prepare the macro which will give facility do similar formatting of all files at a time, if i save all files in specific folder. Find attached sample file for your reference. Thanks in Advance Regards, Shrinivas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Muni -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.comhttp://akoul.blogspot.com/ akoul.wordpress.comhttp://akoul.wordpress.com/ My Linkedin Profilehttp://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com
$$Excel-Macros$$ Please Help
Dear Gurus, Please advise any formula to calculate the Book Value in given attachment. Thanks in Advance Regards, Shrinivas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Help.xls Description: Help.xls
$$Excel-Macros$$ RE: Multiple file Formatting
Please help. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com -Original Message- From: Chidurala, Shrinivas [ICG-GTS] Sent: Monday, April 25, 2011 9:10 PM To: excel-macros@googlegroups.com Subject: Multiple file Formatting Dear Gurus, I have created the attached macro for formatting of 50 to 60 files everyday which are receive from system. But to run this macro i need to open and then run. It taking too much time. Please can you advise to prepare the macro which will give facility do similar formatting of all files at a time, if i save all files in specific folder. Find attached sample file for your reference. Thanks in Advance Regards, Shrinivas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Multiple file Formatting
Dear Gurus, I have created the attached macro for formatting of 50 to 60 files everyday which are receive from system. But to run this macro i need to open and then run. It taking too much time. Please can you advise to prepare the macro which will give facility do similar formatting of all files at a time, if i save all files in specific folder. Find attached sample file for your reference. Thanks in Advance Regards, Shrinivas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Sub outflow_ft() Cells.Select With Selection .WrapText = True .RowHeight = 25 .ColumnWidth = 25 .MergeCells = False .Interior.ColorIndex = xlNone End With Range(A1).Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select Selection.ClearContents Selection.End(xlDown).Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeTop) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeRight) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideVertical) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideHorizontal) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With ActiveWindow.DisplayGridlines = False Range(B:B, D:D, F:F, J:J, M:N,T:T,W:W, Z:Z ).Select Selection.Delete Shift:=xlToLeft Range(A1).Select ActiveWorkbook.Save ActiveWorkbook.Close End Sub WEEKLYCAANNMIRAI-4209788.XLS Description: WEEKLYCAANNMIRAI-4209788.XLS
$$Excel-Macros$$ Convert HTML file to Excel
Dear All, Please any help in me on below mail. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chidurala, Shrinivas [ICG-GTS] Sent: Thursday, March 17, 2011 3:21 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Convert HTML file to Excel Dear All, We received some HTML files from System and we save as them in Excel file and do some formatting. Can we do this activity of converting HTML file to Excel by Macro. Please adive on the somes. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Convert HTML file to Excel
Ashish, Find attached sample file as requested. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Saturday, March 19, 2011 2:21 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Convert HTML file to Excel can u send the sample file On Thu, Mar 17, 2011 at 3:20 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com wrote: Dear All, We received some HTML files from System and we save as them in Excel file and do some formatting. Can we do this activity of converting HTML file to Excel by Macro. Please adive on the somes. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.comhttp://akoul.blogspot.com/ akoul.wordpress.comhttp://akoul.wordpress.com/ My Linkedin Profilehttp://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Holding Report Page : 1 Report as of 16-MAR-2011 Name Code Face Value Pending Purchase Pending Sale Pending CA Holdings ABAN OFFSHORE LTD(EX ABAN LOYD) 421A01028 2 0 0 0 23 ABG SHIPYARD 067H01016 10 0 0 0 281000 ACC LTD(EX-ASSOCIATED CEMENT). 012A01025 10 0 0 0 66 ACKRUTI CITY LTD.(AKRUTI NIRMAN) 703H01016 10 0 0 0 26 ADANI ENTERPRISES LTD(EX ADANI EXPO 423A01024 1 0 0 0 200273 ADANI POWER LTD 814H01011 10 0 0 0 96000 ADITYA BIRLA NUVO LTD(EX INDIAN RAY 069A01017 10 0 0 0 740753 ADVANTA INDIA LTD 517H01010 10 0 0 0 629210 AGRE DEVELOPERS L(X FUTURE MALL) 360L01017 10 0 0 0 1530 ALLIED DIGITAL SERVICES LTD-INR 5 102I01027 5 0 0 0 4 ALOK INDUSTRIES 270A01011 10 0 0 0 23 AMBUJA CEMENT(EX-GUJ AMB CEM)-INR 2 079A01024 2 0 0 0 173866 ANANTRAJ INDUSTRIES-INR 2 242C01024 2 0 0 0 8471250 ANDHRA BANK 434A01013 10 0 0 0 1 APL APOLLO TUBES LTD(X BIHAR TUBES) 702C01019 10 0 0 0 5 APTECH LTD.(EX-APTECH TRAI) 266F01018 10 0 0 0 978500 AREVA T AND D INDIA-INR 2 200A01026 2 0 0 0 109000 ASHOK LEYLAND (INR1) 208A01029 1 39238 0 0 675615 ASHOKA BUILDCOM LTD 442H01011
$$Excel-Macros$$ Convert HTML file to Excel
Dear All, We received some HTML files from System and we save as them in Excel file and do some formatting. Can we do this activity of converting HTML file to Excel by Macro. Please adive on the somes. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.
Hi Ayush, We have any VBA coding to convert Excel to PDF. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Sent: Saturday, February 19, 2011 1:05 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: how i convert pdf file to Excel using macro. Hi Rashid, You can find the macro at the link below : http://quickvba.blogspot.com/2010/12/import-pdf-in-excel.html Let us know if you have any questions: Regards Ayush Jain Group Manager On Saturday, February 19, 2011 12:47:51 PM UTC+5:30, rashid memon wrote: Dear Experts, i want to convert PDF file to Excel so plz provide me macro file is attached... Looking forward to receive your kind attention. Thanks Best Regards Rashid Hussaini Email:- mr.rash...@gmail.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Please Help
Dear All, I have cash entries in one workbook and I want total of some specific entries in different workbook. Please can you help me on the same. Regards, Shrinivas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel FA.xls Description: FA.xls
$$Excel-Macros$$ Extract date from one cell
Dear All, Please can any one help me to extract date in given securities by way of VBA code and formula. SecurityDate REC 07.60% 22JAN13 22-Jan-2013 08.80% STATE BKOF BKJAIPUR 05SEP11 FD GAIL INDIA LIMITED HDFC 0.00% 24AUG12 LIC HOUSING FINANCE 07.50% 10JUN13 Regards, Shrinivas -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Help
Thanks Ashish Hanumant. Can you also help me how to extract date from given securities. SecurityDate REC 07.60% 22JAN13 22-Jan-2013 08.80% STATE BKOF BKJAIPUR 05SEP11 FD GAIL INDIA LIMITED HDFC 0.00% 24AUG12 LIC HOUSING FINANCE 07.50% 10JUN13 Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, January 19, 2011 8:33 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help try this formula =MID(A2,FIND(%,A2)-5,5) On Wed, Jan 19, 2011 at 8:04 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com wrote: Dear All, Please can any one help me to extract percentage in given securities by way of VBA code and formula. SecurityPercentage REC 07.60% 22JAN13 07.60 08.80% STATE BKOF BKJAIPUR 05SEP11 FD NAT HSG BK 6.90% 30OCT12 (P/C - 30OCT11) HDFC 0.00% 24AUG12 Thanks in advance. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.comhttp://akoul.blogspot.com/ akoul.wordpress.comhttp://akoul.wordpress.com/ My Linkedin Profilehttp://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Help
Ashish, Please note some time the date is in middle and some it is last. The below formula is not working. Please can you have any other formula. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Friday, January 21, 2011 7:18 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help try this it will extract last word. RIGHT(A1,LEN(A1)-FIND(~,SUBSTITUTE(A1, ,~,LEN(A1)-LEN(SUBSTITUTE(A1, ,) On Fri, Jan 21, 2011 at 4:37 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com wrote: Thanks Ashish Hanumant. Can you also help me how to extract date from given securities. SecurityDate REC 07.60% 22JAN13 22-Jan-2013 08.80% STATE BKOF BKJAIPUR 05SEP11 FD GAIL INDIA LIMITED HDFC 0.00% 24AUG12 LIC HOUSING FINANCE 07.50% 10JUN13 Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, January 19, 2011 8:33 PM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help try this formula =MID(A2,FIND(%,A2)-5,5) On Wed, Jan 19, 2011 at 8:04 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com wrote: Dear All, Please can any one help me to extract percentage in given securities by way of VBA code and formula. SecurityPercentage REC 07.60% 22JAN13 07.60 08.80% STATE BKOF BKJAIPUR 05SEP11 FD NAT HSG BK 6.90% 30OCT12 (P/C - 30OCT11) HDFC 0.00% 24AUG12 Thanks in advance. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.commailto:shrinivas.chidur...@citi.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.comhttp://akoul.blogspot.com/ akoul.wordpress.comhttp://akoul.wordpress.com/ My Linkedin Profilehttp://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.comhttp
$$Excel-Macros$$ Help
Dear All, Please can any one help me to extract percentage in given securities by way of VBA code and formula. SecurityPercentage REC 07.60% 22JAN13 07.60 08.80% STATE BKOF BKJAIPUR 05SEP11 FD NAT HSG BK 6.90% 30OCT12 (P/C - 30OCT11) HDFC 0.00% 24AUG12 Thanks in advance. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ I love excel because.......
Dear All, I love Excel more than any Software in the World, I'm not alone, millions and millions of people around the world use it too and, more or less, Love it. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ Rename the files
Thanks a lot Ashish -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of ashish koul Sent: Friday, February 19, 2010 10:03 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rename the files check it now it has two macro first one to get file names and second will rename them u can merge them also if u want On Thu, Feb 18, 2010 at 9:18 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: Sorry Ashish, I am unable to open your file and also find attached list of file names for your reference. Regards, Shrinivas Citi® Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 Email - shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com]on Behalf Of ashish koul Sent: Thursday, February 18, 2010 7:06 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rename the files hi check the attachment are you looking for this also just to avoid writing that 111 222 manually can u tell us how account no are related top file names can u provide few examples of file names and is it fixed that sbi is having 111 or hsbc 222 On Thu, Feb 18, 2010 at 4:11 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: Dear all, Please provide any solution to below mention mail. Regards, Shrinivas Citi® Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 Email - shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com]on Behalf Of Chidurala, Shrinivas Sent: Wednesday, February 17, 2010 2:31 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Rename the files Dear All, Every day we receive nearby 100 files from our system, which contain some client data and the file name is like ICICI, HDFC, SBI etc, I want rename the files as per there account no. like 123, 456, 789 etc. Require your help in creating a macro, which will rename the files as perthere account no. Thanks in advance Regards, Shrinivas Citi® Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 Email - shrinivas.chidur...@citi.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive
$$Excel-Macros$$ Rename the files
Dear All, Every day we receive nearby 100 files from our system, which contain some client date and the file name is like ICICI, HDFC, SBI etc, I want rename the files as per there account no. like 123, 456, 789 etc. Require your help in creating a macro, which will rename the files as perthere account no. Thanks in advance Regards, Shrinivas Citi® Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 Email - shrinivas.chidur...@citi.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***
Vivek, Sorry to bother. Can we create drafts with attachement of New workbook generate by below macro as per client. Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of vivek agrawal Sent: Monday, August 10, 2009 2:37 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Split data to different Sheet *** URGENT*** Hi ShriNiwas The macro which i have given already does the following, 1. splits the table into different sheets as per client 2. Saves the sheets as per client into new workbooks 3. these new workbooks are saved in the same folder where you are running the code from... now what additions do you want on these please specify (what you want and what you dont want..) Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Aug 8, 2009 at 4:49 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: Thanks Vivek, It is very useful for me. I want another macro to split same data as per client, but it should be in new Excel and save in C:\. Regards, Shrinivas -Original Message- From: excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com]on Behalf Of vivek agrawal Sent: Friday, August 07, 2009 5:39 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Split data to different Sheet *** URGENT*** Hi Attached is the Text File Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Aug 7, 2009 at 5:34 PM, Upendra Singh upendrasinghsen...@gmail.com wrote: Hi Vivek, Send me the macro as text file as my outlook had blocked “Potential unsafe attachment .bas” please. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who don’t. - From: excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] On Behalf Of vivek agrawal Sent: Friday, August 07, 2009 11:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Split data to different Sheet *** URGENT*** Hi Shrinivas Please Find Attached the required Module. Import this module in your workbook using the VBE. You just need to open that master sheet and run the Sub Procudure COPY UNIQUE. The module will do the rest of the task. it would create separate sheets based on client and then save these different sheets in the same location where the file containing this module is present. you can modify the code based on your needs. Feel free to mail me if more help required. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Aug 7, 2009 at 10:34 AM, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: Dear Friends, Find attached a dump file of all clients, 1. I want one macro to spit the date as per clients in different sheet of same Excel and the same name should be the client name. 2. I want another macro to split data as per client in new excel and save in C:\. Regards, Shrinivas --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***
Thanks once again Vivek and sorry ignore earier mail.. Regards, Shrinivas -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of vivek agrawal Sent: Friday, August 07, 2009 5:39 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Split data to different Sheet *** URGENT*** Hi Attached is the Text File Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Aug 7, 2009 at 5:34 PM, Upendra Singh upendrasinghsen...@gmail.com wrote: Hi Vivek, Send me the macro as text file as my outlook had blocked “Potential unsafe attachment .bas” please. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who don’t. - From: excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] On Behalf Of vivek agrawal Sent: Friday, August 07, 2009 11:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Split data to different Sheet *** URGENT*** Hi Shrinivas Please Find Attached the required Module. Import this module in your workbook using the VBE. You just need to open that master sheet and run the Sub Procudure COPY UNIQUE. The module will do the rest of the task. it would create separate sheets based on client and then save these different sheets in the same location where the file containing this module is present. you can modify the code based on your needs. Feel free to mail me if more help required. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Aug 7, 2009 at 10:34 AM, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: Dear Friends, Find attached a dump file of all clients, 1. I want one macro to spit the date as per clients in different sheet of same Excel and the same name should be the client name. 2. I want another macro to split data as per client in new excel and save in C:\. Regards, Shrinivas --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Split data to different Sheet *** URGENT***
Thanks Vivek, It is very useful for me. I want another macro to split same data as per client, but it should be in new Excel and save in C:\. Regards, Shrinivas -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of vivek agrawal Sent: Friday, August 07, 2009 5:39 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Split data to different Sheet *** URGENT*** Hi Attached is the Text File Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Aug 7, 2009 at 5:34 PM, Upendra Singh upendrasinghsen...@gmail.com wrote: Hi Vivek, Send me the macro as text file as my outlook had blocked “Potential unsafe attachment .bas” please. Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who don’t. - From: excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] On Behalf Of vivek agrawal Sent: Friday, August 07, 2009 11:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Split data to different Sheet *** URGENT*** Hi Shrinivas Please Find Attached the required Module. Import this module in your workbook using the VBE. You just need to open that master sheet and run the Sub Procudure COPY UNIQUE. The module will do the rest of the task. it would create separate sheets based on client and then save these different sheets in the same location where the file containing this module is present. you can modify the code based on your needs. Feel free to mail me if more help required. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Aug 7, 2009 at 10:34 AM, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: Dear Friends, Find attached a dump file of all clients, 1. I want one macro to spit the date as per clients in different sheet of same Excel and the same name should be the client name. 2. I want another macro to split data as per client in new excel and save in C:\. Regards, Shrinivas --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Master.xls Description: Master.xls
$$Excel-Macros$$ Split data to different Sheet *** URGENT***
Dear Friends, Find attached a dump file of all clients, 1. I want one macro to spit the date as per clients in different sheet of same Excel and the same name should be the client name. 2. I want another macro to split data as per client in new excel and save in C:\. Regards, Shrinivas --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Master.xls Description: Master.xls
$$Excel-Macros$$ Re: Outlook urgent
Thanks for the help Daniel... Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel Sent: Wednesday, July 08, 2009 1:33 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook urgent I am no expert with Outlook. But as I figure it out, it looks like if the attached file is embedded in RTF. If this is exact, you can't have plain text format with attached files. You better address an Outlook forum. You could try the NNTP newsgroup : microsoft.public.outlook.general Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] De la part de Chidurala, Shrinivas Envoyé : mardi 7 juillet 2009 18:54 À : excel-macros@googlegroups.com Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: Outlook urgent Daniel, If we create draft with out attachment then its working, but not working with attached. Please can you check. Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel Sent: Monday, July 06, 2009 6:10 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook urgent Hello. Try : Sub SimpleMail() Dim olApp, m Set olApp = CreateObject(Outlook.application) Set m = olApp.CreateItem(olMailItem) With m .Subject = Subject .Body = Dear All, Chr(10) Chr(10) _ Find attached report as of 04-Jul-2009. _ Chr(10) Chr(10) _ Regards, Chr(10) Shrinivas .Recipients.Add t...@test.com .attachments.Add C:\Temp\ICICI.xls .BodyFormat = olFormatPlain .display ' to be deleted .Save End With Set m = Nothing Set olApp = Nothing End Sub Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] De la part de Chidurala, Shrinivas Envoyé : lundi 6 juillet 2009 07:27 À : excel-macros@googlegroups.com Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: Outlook urgent Daniel, It working but i want draft format should be in plain text or HTML. now it is in Rich text. Please can u help on this. Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel Sent: Saturday, July 04, 2009 8:06 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook urgent Hi, Shrinivas. Try : Sub SimpleMail() Dim olApp, m Set olApp = CreateObject(Outlook.application) Set m = olApp.CreateItem(olMailItem) With m .Subject = Subject .Body = Dear All, Chr(10) Chr(10) _ Find attached report as of 04-Jul-2009. _ Chr(10) Chr(10) _ Regards, Chr(10) Shrinivas .Recipients.Add t...@test.com .attachments.Add C:\Temp\ICICI.xls .display .Save End With Set m = Nothing Set olApp = Nothing End Sub Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] De la part de Chidurala, Shrinivas Envoyé : samedi 4 juillet 2009 14:55 À : excel-macros@googlegroups.com Cc : bal...@gmail.com Objet : [Norton AntiSpam] $$Excel-Macros$$ Outlook urgent Importance : Haute Dear Friends, I requeired i coding to create a draft with attachement and also the draft format should be in plain text. Find attached draft for your reference. Thanks Regards, Shrinivas --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group
$$Excel-Macros$$ Re: Outlook urgent
Daniel, If we create draft with out attachment then its working, but not working with attached. Please can you check. Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel Sent: Monday, July 06, 2009 6:10 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook urgent Hello. Try : Sub SimpleMail() Dim olApp, m Set olApp = CreateObject(Outlook.application) Set m = olApp.CreateItem(olMailItem) With m .Subject = Subject .Body = Dear All, Chr(10) Chr(10) _ Find attached report as of 04-Jul-2009. _ Chr(10) Chr(10) _ Regards, Chr(10) Shrinivas .Recipients.Add t...@test.com .attachments.Add C:\Temp\ICICI.xls .BodyFormat = olFormatPlain .display ' to be deleted .Save End With Set m = Nothing Set olApp = Nothing End Sub Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] De la part de Chidurala, Shrinivas Envoyé : lundi 6 juillet 2009 07:27 À : excel-macros@googlegroups.com Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: Outlook urgent Daniel, It working but i want draft format should be in plain text or HTML. now it is in Rich text. Please can u help on this. Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel Sent: Saturday, July 04, 2009 8:06 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook urgent Hi, Shrinivas. Try : Sub SimpleMail() Dim olApp, m Set olApp = CreateObject(Outlook.application) Set m = olApp.CreateItem(olMailItem) With m .Subject = Subject .Body = Dear All, Chr(10) Chr(10) _ Find attached report as of 04-Jul-2009. _ Chr(10) Chr(10) _ Regards, Chr(10) Shrinivas .Recipients.Add t...@test.com .attachments.Add C:\Temp\ICICI.xls .display .Save End With Set m = Nothing Set olApp = Nothing End Sub Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] De la part de Chidurala, Shrinivas Envoyé : samedi 4 juillet 2009 14:55 À : excel-macros@googlegroups.com Cc : bal...@gmail.com Objet : [Norton AntiSpam] $$Excel-Macros$$ Outlook urgent Importance : Haute Dear Friends, I requeired i coding to create a draft with attachement and also the draft format should be in plain text. Find attached draft for your reference. Thanks Regards, Shrinivas --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Outlook urgent
Daniel, It working but i want draft format should be in plain text or HTML. now it is in Rich text. Please can u help on this. Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel Sent: Saturday, July 04, 2009 8:06 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook urgent Hi, Shrinivas. Try : Sub SimpleMail() Dim olApp, m Set olApp = CreateObject(Outlook.application) Set m = olApp.CreateItem(olMailItem) With m .Subject = Subject .Body = Dear All, Chr(10) Chr(10) _ Find attached report as of 04-Jul-2009. _ Chr(10) Chr(10) _ Regards, Chr(10) Shrinivas .Recipients.Add t...@test.com .attachments.Add C:\Temp\ICICI.xls .display .Save End With Set m = Nothing Set olApp = Nothing End Sub Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel- mac...@googlegroups.com] De la part de Chidurala, Shrinivas Envoyé : samedi 4 juillet 2009 14:55 À : excel-macros@googlegroups.com Cc : bal...@gmail.com Objet : [Norton AntiSpam] $$Excel-Macros$$ Outlook urgent Importance : Haute Dear Friends, I requeired i coding to create a draft with attachement and also the draft format should be in plain text. Find attached draft for your reference. Thanks Regards, Shrinivas --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Outlook urgent
Dear Friends, I requeired i coding to create a draft with attachement and also the draft format should be in plain text. Find attached draft for your reference. Thanks Regards, Shrinivas --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- ---BeginMessage--- Dear All, Find attached report as of 04-Jul-2009. Regards, Shrinivas ICICI.xls Description: ICICI.xls ---End Message---
$$Excel-Macros$$ Re: Urgent help
Thanks bala it working. Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of bala Sent: Monday, June 29, 2009 10:08 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Urgent help Hi, try this code Activeworkbook.saveas(Thiswookbook.path \ ClinentName format(now (),ddmmhhmm).xls) With regards BALA On Jun 27, 5:14 pm, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: Dear Friends I want file should be save like client name with current date time e.g. ICICIBANK270620091500 Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Urgent help
Dear Friends, When ever the user open new excel the macro automatically open. Please can any one tell me where should I save that macro. Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---