$$Excel-Macros$$ Date filter Help
Hi Experts, can some one please advise me the process or code to delete the records from sheet 2 and specified dates in sheet 1 criteria . i am attaching sample data please advise me how to use vba macros in this regards. Thanks for your help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Sample data.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ 4 quadrants graph help required
Hi Friends, Please need your expert help in building 4 quadrant graph help. Below is data for which 4 quadrant graph is required. Company Spend Risk A 10 5% B 10 30% C 40 60% D 100 5% i am attaching word doc in which i have drawn graph which looks like. Please help in this regards. Thanks, Rekha -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Doc1.doc Description: MS-Word document
$$Excel-Macros$$ Gantt chart
Hi Excel experts, Wish you a very happy and prosperous New year. i am trying to build Gantt chart if any one have such template please share. As per previous group mails from Sam i referred to Chandoo.org template. Like wise please if any one has such templates do share it. Thanks, Rekha -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Access Qurey
Hi Experts, I am trying to split my Access data base using split option which is around 1.99gb. after splitting size is reduced to 1.01Gb. creating backup of tables in New database and Orginal database remained with links to tables and queries. i am using MS Office 2007 version can any one please advise ,where to import New data in to this database to reflect in Master database. Thanks in Advance . Regards, Rekha -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Autofilter criteria
Hi All, Please assist with Auto filter Here the data is limited only few lines as sample i have given. but in reality data will more two lac lines .. can you please place even if data rows count increases. i tried for vlookup like dis Range(F2).Select ActiveCell.FormulaR1C1 = =VLOOKUP(RC[-5],CCLIST,5,0) Selection.AutoFill Destination:=Range(F2:F Cells(Rows.Count, A).End(xlUp).Row) can you please advise how can i replicate same to autofilter Sub Anil() ActiveSheet.Range($A$1:$H$47).AutoFilter Field:=4, Criteria1:==ROY*, _ Operator:=xlOr, Criteria2:==ROD* ActiveSheet.Range($A$1:$H$47).AutoFilter Field:=7, Criteria1:=0, _ Operator:=xlAnd Range(H2).Select Range(H2).Value = Updated Range(H2).Select Selection.Copy Range(H4:H46).Select Selection.SpecialCells(xlCellTypeVisible).Select ActiveSheet.Paste Range(A1).Select Application.CutCopyMode = False End Sub Thanks, Rekha On Fri, Jun 28, 2013 at 11:57 AM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Rekha, Pl see the attached workbook. Warm Regards, Gawli Anil On Fri, Jun 28, 2013 at 10:36 AM, rekha siri rekha.siri2...@gmail.comwrote: Hi Experts, Please help in this concern i am attaching sample data spread from Column A TO H in H Column i want to update Status as per below criteria 1) Filter Reference column -- custom filter -- Begins with ROD OR Begins with ROY Update the Status as Excluded for visible cells in Column H 2) Filter Reference column -- custom filter -- Begins with ROD OR Begins with ROY andapply filter in G column as select values greater than 0 Update the Status as Defined for visible cells in Column H . I am placing sample data for around 100 line items , data may have more than 1lac records. Thanks, Rekha -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Autofilter criteria
Hi Experts, Please help in this concern i am attaching sample data spread from Column A TO H in H Column i want to update Status as per below criteria 1) Filter Reference column -- custom filter -- Begins with ROD OR Begins with ROY Update the Status as Excluded for visible cells in Column H 2) Filter Reference column -- custom filter -- Begins with ROD OR Begins with ROY andapply filter in G column as select values greater than 0Update the Status as Defined for visible cells in Column H . I am placing sample data for around 100 line items , data may have more than 1lac records. Thanks, Rekha -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Autofilter criteria.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ autofilter issue
Hi Friends, i tried piece of code for auto filter criteria , i succeeded in condition for autofilter for which criteria is equal to... but does not equal to condition i am not getting proper result. Basically i want to place a condition that 15th column in Bex file sheet should be filter with custom filter does not equal to Chief Technology Office Desktop Platform and should equal to AF criteria in 25th column . below is the code please rectify me... With ThisWorkbook.Worksheets(Bex File) Set rng = .Range(A1).CurrentRegion rng.AutoFilter 15, *Chief Technology Office*, xlOr, *Desktop Platform* rng.AutoFilter Field:=25, Criteria1:==*AF* Sheets(Bex File).Select Cells.Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.Copy -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Tab specification code
Hi Experts, Just wanted to know the purpose these VBA code , can any one please explain what does this outer loop and inter loop means ... For Outerloop = 8 To i j = macro.Cells(Outerloop, Columns.Count).End(xlToLeft).Column FileName = macro.Cells(Outerloop, 1) Set NewFile = Workbooks.Add For Innerloop = 3 To j Dim CC As String CC = CC = macro.Cells(Outerloop, Innerloop) Set sh = Master.Worksheets(CC) sh.Activate ActiveSheet.Copy before:=NewFile.Sheets(1) k = ActiveSheet.Cells(Rows.Count, A).End(xlUp).Row NewFile.Sheets(CC).Select Cells.Find(What:=Mapping Data, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, _ MatchCase:=False, SearchFormat:=False).Activate If Sheets(CC).FilterMode = True Then 'Selection.AutoFilter Else Selection.AutoFilter End If -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Need exporting help for Records more than 65000 records in Access to Excel
hi Group, Need your expertise help i along with my friends uploaded some excel file into Access . Now the Access is having around 1lac records . Need help in exporting from access to excel all the 1lac records. i tried exporting it to excel from access but it is throughing only 65000 records. can you help me in providing solution and also if you have any macro to import from excel to Access and also export from access database which is having more than 1lac records to excel. Thanks alot for your help in advance. Regards, Rekha -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ selecting text and marking with status against it
Hi Maries, Thanks a lot for your swift response, learnt new thing . Adding to below what is the case if we want filter Reference column (M) using text filter --customfilter-- Begins with ROD or Begins with ROY i recorded it in this manner but for this criteria need to mark as excluded in AT column. ActiveSheet.Range($A$1:$BB$34).AutoFilter Field:=13, Criteria1:==rod*, _ Operator:=xlOr, Criteria2:==roy* can you please help in this regards. On Fri, Sep 21, 2012 at 10:35 PM, Maries talk2mar...@gmail.com wrote: hi ReK, Try this codes, Sub Rek_NAM() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim lastrow As Long, r As Long lastrow = ActiveSheet.UsedRange.Rows.Count For r = lastrow To 2 Step -1 If Cells(r, 5).Value = NAM Then Cells(r, 45).Value = Excluded End If Next r Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub Sub Rek_LATAM() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim lastrow As Long, r As Long lastrow = ActiveSheet.UsedRange.Rows.Count For r = lastrow To 2 Step -1 If Cells(r, 5).Value = LATAM Then Cells(r, 45).Value = Excluded End If Next r Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub On Fri, Sep 21, 2012 at 7:37 PM, rekha siri rekha.siri2...@gmail.comwrote: hi experts, please help me in this concern, i have data spread from A to AB columns from one of the column i want to apply filter select one region in column e against that region i want to place as excluded in another column AS. can any one help me with vba code in this. i am attaching sample excel sheet. Thanks, Rekha -- 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. -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- 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. -- 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
$$Excel-Macros$$ selecting text and marking with status against it
hi experts, please help me in this concern, i have data spread from A to AB columns from one of the column i want to apply filter select one region in column e against that region i want to place as excluded in another column AS. can any one help me with vba code in this. i am attaching sample excel sheet. Thanks, Rekha -- 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. sample file.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Marquee text in Powerpoint
thanks alot ashish now i am able to fix it.. On Tue, Aug 7, 2012 at 9:39 PM, ashish koul koul.ash...@gmail.com wrote: result on google search http://www.youtube.com/watch?v=dBTkl1tnXao http://www.pcreview.co.uk/forums/scrolling-marquee-t917395.html http://officeone.mvps.org/powershow/powershow_ticker_show.html ( check ticker) http://www.dailymotion.com/video/xfeurt_create-the-scrolling-text-animation-effect-in-powerpoint_tech http://www.lockergnome.com/windows/2010/06/11/create-a-scrolling-text-box-to-a-powerpoint-slide/ On Tue, Aug 7, 2012 at 11:07 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Ashish, any idea in this regards as already you have created in excel. Thanks for your help in advance!! On Sat, Aug 4, 2012 at 3:46 AM, David Grugeon da...@grugeon.com.auwrote: You might do better asking PowerPoint questions on a Powerpoint forum. As its name indicates this forum is about Excel Macros. On 4 August 2012 02:24, rekha siri rekha.siri2...@gmail.com wrote: Hi Experts, Please assist in this concern i deal with xlius earlier now we are using only power point dashboard presentation. is there any possibility to place the scrolling marquee kind of text as Headings of power point slides. which needs to be scrolling continously. Thanks, Rekha -- 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 -- Regards David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- Thanks Regards, Rajasekhar.P Subscribe to our group and receive daily updates. Excel groups https://sites.google.com/site/excelencyclopedia/how-to-join/assignments Send your queries and Suggestions @ excel-gro...@googglegroups.com Excelforum Blogspot a href= http://feedburner.google.com/fb/a/mailverify?uri=ExcelForumamp;loc=en_UShttp://feedburner.google.com/fb/a/mailverify?uri=ExcelForumloc=en_USSubscribe to excel forum by Email/a -- 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. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http
Re: $$Excel-Macros$$ Power pivot
thanks to one all.for sharing this material. On Tue, Aug 14, 2012 at 8:20 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Correct Rajan, You are right, By Mistake i have send study material of Power Point instead of Power pivot. see attachment for Power pivot. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com On Mon, Aug 13, 2012 at 10:24 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Noorain bhai,* *She is asking about Power pivot. Not power point.* *If you have some material on Power pivot , would be helpful .* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* 13 August 2012 10:20 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Power pivot Hi Rekha, Please see attached study materials. On Mon, Aug 13, 2012 at 6:55 PM, rekha siri rekha.siri2...@gmail.com wrote: hi Team, Please share if anyone is having PPT tutorial on Power pivot, usuage of sparklines/slicer in Excel 2010. Thanks, Rekha -- 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. -- 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. -- 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.
$$Excel-Macros$$ Power pivot
hi Team, Please share if anyone is having PPT tutorial on Power pivot, usuage of sparklines/slicer in Excel 2010. Thanks, Rekha -- 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.
$$Excel-Macros$$ Marquee text in Powerpoint
Hi Experts, Please assist in this concern i deal with xlius earlier now we are using only power point dashboard presentation. is there any possibility to place the scrolling marquee kind of text as Headings of power point slides. which needs to be scrolling continously. Thanks, Rekha -- 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
Fwd: $$Excel-Macros$$ compatability issues with 2007 VS 2010
can any one please advise the below concern -- Forwarded message -- From: rekha siri rekha.siri2...@gmail.com Date: Sun, May 27, 2012 at 3:16 PM Subject: $$Excel-Macros$$ compatability issues with 2007 VS 2010 To: excel-macros@googlegroups.com Hi Experts, can any one help me in this below concern one of our trainee has this concern. I feel by using Excel 2010 for analysis purpose only as of now will save our folks in FPA and sourcing Finance with lots of time (my stand is of ROI 1000%). For example one of the reports took me 6 hours just to compile the data set (over 600K rows) and analyze part by part, in the same case if I would have used Excel 2010 it would have taken me only 5-10 minutes using power pivot. There are certain questions I put forward to you... 1) What do you feel by ROI by using Excel 2010 Vs Excel 2010? 2) Problem with 2010 is compatibility so if people across TR are using 2007 and not 2010 then it might create trouble, is that there is a way to convert file format for 2007 user from 2010? 3) Does Windows Xp supports Excel 2010, and OS allows to have 2010, 2007 2003 for installation.I mean both 2007 version and 2010 version. Good Day! -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Need help to execute bex query using vba
hi experts, could you please provide vba code which refreshes the SAP bex query or to executes the bex query. Thanks, Rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need assistance in finding formula to substitute the values to dates.
Thanks a lot Marie ... On Wed, Apr 4, 2012 at 11:56 PM, Haseeb A haseeb.avarak...@gmail.comwrote: Good One Maries :) As you know OFFSET is volatile. A non volatile formula, =IFERROR(INDEX($B$4:$E$4,MATCH(B$9,INDEX($B$5:$E$7,MATCH($A10,$A$5:$A$7,0),0),0)),) ___ HTH, Haseeb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need Power point code help
Hi Ashish, Thanks alot i Just referenced the Sheet name and decreased the size. i am able to get the desired result. Thanks for your help. Regards, Rekha On Mon, Apr 2, 2012 at 9:15 PM, ashish koul koul.ash...@gmail.com wrote: check this make change as per your requirement On Mon, Apr 2, 2012 at 10:27 AM, rekha siri rekha.siri2...@gmail.comwrote: hi Ashish, Thanks for your link however i am unable to download macro file it is stating Macro file not found. Can you please forward that macro file. Thanks, Rekha On Sun, Apr 1, 2012 at 6:33 PM, ashish koul koul.ash...@gmail.comwrote: http://www.excelvbamacros.com/2011/06/excel-to-powerpoint-6.html On Sun, Apr 1, 2012 at 3:04 PM, rekha siri rekha.siri2...@gmail.comwrote: hi Experts, i am attaching a macro which copies the two charts from excel and pastes in ppt. but can some one help to modify this code to paste two charts in one slide instead of two slides. Thanks, Rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- 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
$$Excel-Macros$$ Need assistance in finding formula to substitute the values to dates.
Hi I need assistance in finding the right formula to substitute the value to dates in countif [image: Alexei De Guzman][image: Just Joined] *Alexei De Guzman https://thehub.thomsonreuters.com/people/0143599* Apr 3, 2012 9:03 PM Hi, I am trying to come up with the formula to pull up dates from a tracker for each individual. Example: *Name **April 1 **April 2 **April 3**April 4 *Alexei de GuzmanVLJoseph RoxasSLKelly FurioH *Name**VL**H**SL*Alexei de GuzmanApril 1Joseph RoxasApril 3 So I am making a summary tracker that will break it down by dates for each name. I have tried using Countif for a particular value but I have been looking for a formula to come up to pull it up by dates. I hope someone already knows the answer. Thank you very much. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need Power point code help
hi Ashish, Thanks for your link however i am unable to download macro file it is stating Macro file not found. Can you please forward that macro file. Thanks, Rekha On Sun, Apr 1, 2012 at 6:33 PM, ashish koul koul.ash...@gmail.com wrote: http://www.excelvbamacros.com/2011/06/excel-to-powerpoint-6.html On Sun, Apr 1, 2012 at 3:04 PM, rekha siri rekha.siri2...@gmail.comwrote: hi Experts, i am attaching a macro which copies the two charts from excel and pastes in ppt. but can some one help to modify this code to paste two charts in one slide instead of two slides. Thanks, Rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ How to copy text frame from excel and paste in bottom of ppt slide
hi Asa rossoff, Thanks alot for your advise could please forward the tested macro with these changes. thanks in advance. On Mon, Mar 12, 2012 at 7:37 AM, Asa Rossoff a...@lovetour.info wrote: Hi Rekha, You can change the line that sets the vertical position from: newPowerPoint.ActiveWindow.Selection.ShapeRange.Top = 80 to this (one line): newPowerPoint.ActiveWindow.Selection.ShapeRange.Top = newPowerPoint.ActivePresentation.PageSetup.SlideHeight - newPowerPoint.ActiveWindow.Selection.ShapeRange.Height - 80 which places the chart 80 picas (1/72) from the bottom of the slide instead of from the top. You could use similar code with the ShapeRange.Left property to place the chart in relation to the right side of the slide instead of the left if desired. ** ** The macro could be simplified with additional variables and/or With blocks to avoid all the redundant object references you see in the above line, but the code provided should do the trick. ** ** Oh, when I tested your code on my system I had to change one line. The following did not find the Powerpoint window: AppActivate (Microsoft PowerPoint) But this revision worked fine: AppActivate newPowerPoint.Caption ** ** Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Sunday, March 11, 2012 12:20 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ How to copy text frame from excel and paste in bottom of ppt slide ** ** Greetings to one and all, ** ** please provide a vba code for copying text frame from excel and to paste in bottom of power point slide. ** ** i have macro code in attached note pad in which macro pastes the text frame on right hand side of slide but can any one provide code to paste text frame in bottom of slide. ** ** Thanks, Rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ How to copy text frame from excel and paste in bottom of ppt slide
Greetings to one and all, please provide a vba code for copying text frame from excel and to paste in bottom of power point slide. i have macro code in attached note pad in which macro pastes the text frame on right hand side of slide but can any one provide code to paste text frame in bottom of slide. Thanks, Rekha -- 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 Sub CreatePowerPoint() 'Add a reference to the Microsoft PowerPoint Library by: '1. Go to Tools in the VBA menu '2. Click on Reference '3. Scroll down to Microsoft PowerPoint X.0 Object Library, check the box, and press Okay 'First we declare the variables we will be using Dim newPowerPoint As PowerPoint.Application Dim activeSlide As PowerPoint.Slide Dim cht As Excel.ChartObject 'Look for existing instance On Error Resume Next Set newPowerPoint = GetObject(, PowerPoint.Application) On Error GoTo 0 'Let's create a new PowerPoint If newPowerPoint Is Nothing Then Set newPowerPoint = New PowerPoint.Application End If 'Make a presentation in PowerPoint If newPowerPoint.Presentations.Count = 0 Then newPowerPoint.Presentations.Add End If 'Show the PowerPoint newPowerPoint.Visible = True 'Loop through each chart in the Excel worksheet and paste them into the PowerPoint For Each cht In ActiveSheet.ChartObjects 'Add a new slide where we will paste the chart newPowerPoint.ActivePresentation.Slides.Add newPowerPoint.ActivePresentation.Slides.Count + 1, ppLayoutText newPowerPoint.ActiveWindow.View.GotoSlide newPowerPoint.ActivePresentation.Slides.Count Set activeSlide = newPowerPoint.ActivePresentation.Slides(newPowerPoint.ActivePresentation.Slides.Count) 'Copy the chart and paste it into the PowerPoint as a Metafile Picture cht.Select ActiveChart.ChartArea.Copy activeSlide.Shapes.PasteSpecial(DataType:=ppPasteMetafilePicture).Select 'Set the title of the slide the same as the title of the chart activeSlide.Shapes(1).TextFrame.TextRange.Text = cht.Chart.ChartTitle.Text ModifyChartTitle 'Adjust the positioning of the Chart on Powerpoint Slide newPowerPoint.ActiveWindow.Selection.ShapeRange.Left = 15 newPowerPoint.ActiveWindow.Selection.ShapeRange.Top = 80 activeSlide.Shapes(2).Width = 200 activeSlide.Shapes(2).Left = 505 'If the chart is the US consumption chart, then enter the appropriate comments If InStr(activeSlide.Shapes(1).TextFrame.TextRange.Text, Other People) Then activeSlide.Shapes(2).TextFrame.TextRange.Text = Range(p5).Value vbNewLine activeSlide.Shapes(2).TextFrame.TextRange.InsertAfter (Range(p6).Value vbNewLine) 'Else if the chart is the Renewable consumption chart, then enter the appropriate comments ElseIf InStr(activeSlide.Shapes(1).TextFrame.TextRange.Text, Royalty) Then activeSlide.Shapes(2).TextFrame.TextRange.Text = Range(P45).Value vbNewLine ElseIf InStr(activeSlide.Shapes(1).TextFrame.TextRange.Text, Entertainment) Then activeSlide.Shapes(2).TextFrame.TextRange.InsertAfter (Range(P85).Value vbNewLine) ElseIf InStr(activeSlide.Shapes(1).TextFrame.TextRange.Text, Comp) Then activeSlide.Shapes(2).TextFrame.TextRange.InsertAfter (Range(P125).Value vbNewLine) ElseIf InStr(activeSlide.Shapes(1).TextFrame.TextRange.Text, Outside) Then activeSlide.Shapes(2).TextFrame.TextRange.InsertAfter (Range(P155).Value vbNewLine) ElseIf InStr(activeSlide.Shapes(1).TextFrame.TextRange.Text, All Other) Then activeSlide.Shapes(2).TextFrame.TextRange.InsertAfter (Range(P195).Value vbNewLine) ElseIf InStr(activeSlide.Shapes(1).TextFrame.TextRange.Text, Allocation) Then
$$Excel-Macros$$ Need if formula
hi Experts, please provide if condition formula for attached sheet. Thanks, Rekah -- 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 Need if condition formula for three conditions.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need advise
Thanks Xls time, if i want to send mail using outlook will it work over there if so please can you help me out in this concern. On Mon, Mar 5, 2012 at 7:58 AM, xlstime xlst...@gmail.com wrote: use Google Insert Image option in G mail or you can use link a .gif file... [image: Inline image 1] On Mon, Mar 5, 2012 at 12:41 AM, rekha siri rekha.siri2...@gmail.comwrote: hi Experts, I Am excel trainer, just wanted to know how can we place this kind of animation in mail for excel functions or training's Use CTRL + Enter To Enter Same Data in to Multiple Cells(Quick Tip) created by Raja Sekhar Phttps://thehub.thomsonreuters.com/people/0128384 on Mar 4, 2012 1:34 PM, last modified by Raja Sekhar Phttps://thehub.thomsonreuters.com/people/0128384 on Mar 4, 2012 1:39 PM *Use CTRL + Enter To Enter Same Data in to Multiple Cells(Quick Tip)* [image: Use CTRL+Enter to Enter Same Data in to Multiple Cells [Quick Tip]]http://chandoo.org/wp/2012/01/09/how-to-enter-same-data-into-multiple-cells/ Here is a quick Excel tip to kick start your week. Sometimes, we want to enter same data in to several cells. You can use CTRL+Enter to do this in a snap. (1) Select all the cells where you want to enter the same data. (2) Type the data (3) Press CTRL+Enter (4) Done! -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need pivot subtotal code
can any one please assist my query... On Tue, Feb 14, 2012 at 1:02 AM, rekha siri rekha.siri2...@gmail.comwrote: hi Raj, Thanks for your macro but i am sorry this is not performing vlookup function inthis. can you please look into this On Tue, Feb 14, 2012 at 12:37 AM, Raj Mahapatra rajafs...@gmail.comwrote: Hi Rekha, Please find the attached file Go to View Macro and Run Macro 1 data automatically will give you your output for any further queries, please feel free to revert Thanks Regards Rajesh Mahapatra On Mon, Feb 13, 2012 at 5:29 PM, rekha siri rekha.siri2...@gmail.comwrote: hi experts, please help me in provinding code . i am attaching sop and files in download zip. thanks, rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need pivot subtotal code
hi Raj, Thanks for your macro but i am sorry this is not performing vlookup function inthis. can you please look into this On Tue, Feb 14, 2012 at 12:37 AM, Raj Mahapatra rajafs...@gmail.com wrote: Hi Rekha, Please find the attached file Go to View Macro and Run Macro 1 data automatically will give you your output for any further queries, please feel free to revert Thanks Regards Rajesh Mahapatra On Mon, Feb 13, 2012 at 5:29 PM, rekha siri rekha.siri2...@gmail.comwrote: hi experts, please help me in provinding code . i am attaching sop and files in download zip. thanks, rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ rekha siri wants to chat
I've been using Google Talk and thought you might like to try it out. We can use it to call each other for free over the internet. Here's an invitation to download Google Talk. Give it a try! --- rekha siri wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-999e385144-ef6287c0de--n5VAvTjjM_A5bywXUnTgieTfxQ You'll need to click this link to be able to chat with rekha siri. To get Gmail - a free email account from Google with over 2,800 megabytes of storage - and chat with rekha siri, visit: http://mail.google.com/mail/a-999e385144-ef6287c0de--n5VAvTjjM_A5bywXUnTgieTfxQ Gmail offers: - Instant messaging right inside Gmail - Powerful spam protection - Built-in search for finding your messages and a helpful way of organizing emails into conversations - No pop-up ads or untargeted banners - just text ads and related information that are relevant to the content of your messages All this, and its yours for free. But wait, there's more! By opening a Gmail account, you also get access to Google Talk, Google's instant messaging service: http://www.google.com/talk/ Google Talk offers: - Web-based chat that you can use anywhere, without a download - A contact list that's synchronized with your Gmail account - Free, high quality PC-to-PC voice calls when you download the Google Talk client We're working hard to add new features and make improvements, so we might also ask for your comments and suggestions periodically. We appreciate your help in making our products even better! Thanks, The Google Team To learn more about Gmail and Google Talk, visit: http://mail.google.com/mail/help/about.html http://www.google.com/talk/about.html (If clicking the URLs in this message does not work, copy and paste them into the address bar of your browser). -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: Need help in building pivot using vba
hi Ansari, I am bit new to vba coding as this pivot source data is within sheet as per attached sheet . *my query is * if i have data in different sheet please advise. can you please help to provide this below listed steps code 1) to copy particular sheet from one existing workbook to new workbook 2) in that new work book i want to build the pivot . On Fri, Jan 27, 2012 at 3:07 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Rekha, Please find the code to build pivot using vba On Fri, Jan 27, 2012 at 10:53 AM, rekha siri rekha.siri2...@gmail.comwrote: Need pivot macro assistance.. On Wed, Jan 18, 2012 at 9:59 PM, rekha siri rekha.siri2...@gmail.comwrote: hi experts, Please provide the code to build pivot using vba this macro is provided to me in past by rajan really thank full for the concern. adding to that i need to prepare pivot for west bu from attached macro raw data sheet. pivot format is also attached it should be as per West december2011 file's pivot manner. attached are macro and west december workbooks which contain pivot .. kindly help in this concern thanks. Rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Pop up box required if cell is empty
Thanks alot Ansari ... its working superb.. thanks for your quick revert .. Regards, Raj On Fri, Jan 27, 2012 at 5:06 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Rekha, Please try it..Hope it will help to you Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If ActiveCell.Column 1 And ActiveCell.Column = 10 Or ActiveCell.Row 1 And ActiveCell.Row = 27 Then If Not IsEmpty(ActiveCell.Value) Then Exit Sub Else MsgBox Can't Leave it Blank, vbInformation End If End If End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Jan 27, 2012 at 4:12 PM, rekha siri rekha.siri2...@gmail.comwrote: hi Experts, i require a popup box if cell is empty while moving to another cell. i tried placing code but not successful can anyone please provide me code. Thanks, Rekha -- 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 ** http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Need help in building pivot using vba
Need pivot macro assistance.. On Wed, Jan 18, 2012 at 9:59 PM, rekha siri rekha.siri2...@gmail.comwrote: hi experts, Please provide the code to build pivot using vba this macro is provided to me in past by rajan really thank full for the concern. adding to that i need to prepare pivot for west bu from attached macro raw data sheet. pivot format is also attached it should be as per West december2011 file's pivot manner. attached are macro and west december workbooks which contain pivot .. kindly help in this concern thanks. Rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba
Rajan, i Tried removing the sheets and tried executing this macro bt it is not executing. Please fix this... Thanks alot for your help in this concern. On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi Rekha See the attached sheet.. Don’t delete SUmmarySheet ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Jan/Sat/2012 08:51 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Fwd: Need help in building pivot using vba ** ** can any one kindly help on this please. -- Forwarded message -- From: *rekha siri* rekha.siri2...@gmail.com Date: Wed, Jan 18, 2012 at 9:59 PM Subject: Need help in building pivot using vba To: excel-macros@googlegroups.com hi experts, ** ** Please provide the code to build pivot using vba ** ** this macro is provided to me in past by rajan really thank full for the concern. ** ** adding to that i need to prepare pivot for west bu from attached macro raw data sheet. ** ** pivot format is also attached it should be as per West december2011 file's pivot manner. ** ** attached are macro and west december workbooks which contain pivot .. ** ** ** ** ** ** kindly help in this concern thanks. ** ** Rekha ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba
rajan i dint remove summary sheet and raw data sheet but still its not executing. only rest of sheets were deleted bt its opening bu list and stopping there On Sun, Jan 22, 2012 at 6:10 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi rekha. I clearly mention that don’t delete the summarySheet.. Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Jan/Sun/2012 04:47 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba ** ** Rajan, ** ** i Tried removing the sheets and tried executing this macro bt it is not executing. ** ** Please fix this... ** ** Thanks alot for your help in this concern. On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Rekha See the attached sheet.. Don’t delete SUmmarySheet *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Jan/Sat/2012 08:51 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Fwd: Need help in building pivot using vba can any one kindly help on this please. -- Forwarded message -- From: *rekha siri* rekha.siri2...@gmail.com Date: Wed, Jan 18, 2012 at 9:59 PM Subject: Need help in building pivot using vba To: excel-macros@googlegroups.com hi experts, Please provide the code to build pivot using vba this macro is provided to me in past by rajan really thank full for the concern. adding to that i need to prepare pivot for west bu from attached macro raw data sheet. pivot format is also attached it should be as per West december2011 file's pivot manner. attached are macro and west december workbooks which contain pivot .. kindly help in this concern thanks. Rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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
Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba
Rajan i could able to find out the root cause. i deleted sub delete module below and call delete function line now its working fine Thanks, Rekha On Sun, Jan 22, 2012 at 11:10 PM, rekha siri rekha.siri2...@gmail.comwrote: rajan i dint remove summary sheet and raw data sheet but still its not executing. only rest of sheets were deleted bt its opening bu list and stopping there On Sun, Jan 22, 2012 at 6:10 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi rekha. I clearly mention that don’t delete the summarySheet.. Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Jan/Sun/2012 04:47 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba ** ** Rajan, ** ** i Tried removing the sheets and tried executing this macro bt it is not executing. ** ** Please fix this... ** ** Thanks alot for your help in this concern. On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Rekha See the attached sheet.. Don’t delete SUmmarySheet *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Jan/Sat/2012 08:51 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Fwd: Need help in building pivot using vba*** * can any one kindly help on this please. -- Forwarded message -- From: *rekha siri* rekha.siri2...@gmail.com Date: Wed, Jan 18, 2012 at 9:59 PM Subject: Need help in building pivot using vba To: excel-macros@googlegroups.com hi experts, Please provide the code to build pivot using vba this macro is provided to me in past by rajan really thank full for the concern. adding to that i need to prepare pivot for west bu from attached macro raw data sheet. pivot format is also attached it should be as per West december2011 file's pivot manner. attached are macro and west december workbooks which contain pivot .. kindly help in this concern thanks. Rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles
Re: $$Excel-Macros$$ Need help
thanks one all for your help On Tue, Dec 27, 2011 at 11:34 AM, Rajan_Verma rajanverma1...@gmail.comwrote: Try this: ** ** Dim intIAs Integer For intI = 1 To Len(rngVal.Value) If Asc(UCase(Mid(rngVal.Value, intI, 1))) 64 And Asc(UCase(Mid(rngVal.Value, intI, 1))) 91 Then GiveNumeric = GiveNumeric Asc(UCase(Mid(rngVal.Value, intI, 1))) - 64 End If Next End Function ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* 27 December 2011 11:03 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need help ** ** it is resulting wrong result please help for example i gave word abc it should come 123 but it is coming like this 333435 ** ** On Tue, Dec 27, 2011 at 11:00 AM, Maries talk2mar...@gmail.com wrote:*** * *Try this formula...* =CONCATENATE(IF(LEN(A1)=1,CODE(LEFT(A1,1))-64,),IF(LEN(A1)=2,CODE(MID(A1,2,1))-64,),IF(LEN(A1)=3,CODE(MID(A1,3,1))-64,),IF(LEN(A1)=4,CODE(MID(A1,4,1))-64,),IF(LEN(A1)=5,CODE(MID(A1,5,1))-64,),IF(LEN(A1)=6,CODE(MID(A1,6,1))-64,),IF(LEN(A1)=7,CODE(MID(A1,7,1))-64,),IF(LEN(A1)=8,CODE(MID(A1,8,1))-64,),IF(LEN(A1)=9,CODE(MID(A1,9,1))-64,),IF(LEN(A1)=10,CODE(MID(A1,10,1))-64,),IF(LEN(A1)=11,CODE(MID(A1,11,1))-64,),IF(LEN(A1)=12,CODE(MID(A1,12,1))-64,),IF(LEN(A1)=13,CODE(MID(A1,13,1))-64,),IF(LEN(A1)=14,CODE(MID(A1,14,1))-64,),IF(LEN(A1)=15,CODE(MID(A1,15,1))-64,),IF(LEN(A1)=16,CODE(MID(A1,16,1))-64,),IF(LEN(A1)=17,CODE(MID(A1,17,1))-64,),IF(LEN(A1)=18,CODE(MID(A1,18,1))-64,),IF(LEN(A1)=19,CODE(MID(A1,19,1))-64,),IF(LEN(A1)=20,CODE(MID(A1,20,1))-64,),IF(LEN(A1)=21,CODE(MID(A1,21,1))-64,),IF(LEN(A1)=22,CODE(MID(A1,22,1))-64,),IF(LEN(A1)=23,CODE(MID(A1,23,1))-64,),IF(LEN(A1)=24,CODE(MID(A1,24,1))-64,),IF(LEN(A1)=25,CODE(MID(A1,25,1))-64,),IF(LEN(A1)=26,CODE(MID(A1,26,1))-64,),IF(LEN(A1)=27,CODE(MID(A1,27,1))-64,)) Regards, MARIES. On Tue, Dec 27, 2011 at 8:53 AM, Lakshman Prasad lakshman...@yahoo.com wrote: Hello Asa This =FIND(UPPER(A1),ABCDEFGHIJKLMNOPQRSTUVWXYZ) and this is ok =CODE(UPPER(A1))-64 for under result a =1 b= 2 c=3 but what about for this acb =132 Regards LAKSHMAN ** ** *From:* Asa Rossoff a...@lovetour.info *To:* excel-macros@googlegroups.com *Sent:* Tuesday, 27 December 2011 8:37 AM *Subject:* RE: $$Excel-Macros$$ Need help ** ** Hi Rekha, Here's one method. It will return 1-26 for A-Z, whether upper or lower case. If any other character, it will give an error: =FIND(UPPER(A1),ABCDEFGHIJKLMNOPQRSTUVWXYZ) Here's another method, it will return a number for any character. If the charcater is A-Z (upper or lower case), it will be 1-26, otherwise it will be a negative number or a number higher than 26: =CODE(UPPER(A1))-64 Although the above could be modified to return an error for other characters, if that's important, the FIND() method is probably simpler and faster. Asa *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Monday, December 26, 2011 2:01 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need help hi experts, please advise the formula to convert the alphabets to numbers. for example a =1 b= 2 c=3 acb =132 like this for each alphabet it should convert text to number. Thanks for your help Regards, Rekha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post
$$Excel-Macros$$ Need help
hi experts, please advise the formula to convert the alphabets to numbers. for example a =1 b= 2 c=3 acb =132 like this for each alphabet it should convert text to number. Thanks for your help Regards, Rekha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need help
it is resulting wrong result please help for example i gave word abc it should come 123 but it is coming like this 333435 On Tue, Dec 27, 2011 at 11:00 AM, Maries talk2mar...@gmail.com wrote: *Try this formula...* ** =CONCATENATE(IF(LEN(A1)=1,CODE(LEFT(A1,1))-64,),IF(LEN(A1)=2,CODE(MID(A1,2,1))-64,),IF(LEN(A1)=3,CODE(MID(A1,3,1))-64,),IF(LEN(A1)=4,CODE(MID(A1,4,1))-64,),IF(LEN(A1)=5,CODE(MID(A1,5,1))-64,),IF(LEN(A1)=6,CODE(MID(A1,6,1))-64,),IF(LEN(A1)=7,CODE(MID(A1,7,1))-64,),IF(LEN(A1)=8,CODE(MID(A1,8,1))-64,),IF(LEN(A1)=9,CODE(MID(A1,9,1))-64,),IF(LEN(A1)=10,CODE(MID(A1,10,1))-64,),IF(LEN(A1)=11,CODE(MID(A1,11,1))-64,),IF(LEN(A1)=12,CODE(MID(A1,12,1))-64,),IF(LEN(A1)=13,CODE(MID(A1,13,1))-64,),IF(LEN(A1)=14,CODE(MID(A1,14,1))-64,),IF(LEN(A1)=15,CODE(MID(A1,15,1))-64,),IF(LEN(A1)=16,CODE(MID(A1,16,1))-64,),IF(LEN(A1)=17,CODE(MID(A1,17,1))-64,),IF(LEN(A1)=18,CODE(MID(A1,18,1))-64,),IF(LEN(A1)=19,CODE(MID(A1,19,1))-64,),IF(LEN(A1)=20,CODE(MID(A1,20,1))-64,),IF(LEN(A1)=21,CODE(MID(A1,21,1))-64,),IF(LEN(A1)=22,CODE(MID(A1,22,1))-64,),IF(LEN(A1)=23,CODE(MID(A1,23,1))-64,),IF(LEN(A1)=24,CODE(MID(A1,24,1))-64,),IF(LEN(A1)=25,CODE(MID(A1,25,1))-64,),IF(LEN(A1)=26,CODE(MID(A1,26,1))-64,),IF(LEN(A1)=27,CODE(MID(A1,27,1))-64,)) Regards, MARIES. On Tue, Dec 27, 2011 at 8:53 AM, Lakshman Prasad lakshman...@yahoo.comwrote: Hello Asa This =FIND(UPPER(A1),ABCDEFGHIJKLMNOPQRSTUVWXYZ) and this is ok =CODE(UPPER(A1))-64 for under result a =1 b= 2 c=3 but what about for this acb =132 Regards LAKSHMAN *From:* Asa Rossoff a...@lovetour.info *To:* excel-macros@googlegroups.com *Sent:* Tuesday, 27 December 2011 8:37 AM *Subject:* RE: $$Excel-Macros$$ Need help Hi Rekha, Here's one method. It will return 1-26 for A-Z, whether upper or lower case. If any other character, it will give an error: =FIND(UPPER(A1),ABCDEFGHIJKLMNOPQRSTUVWXYZ) Here's another method, it will return a number for any character. If the charcater is A-Z (upper or lower case), it will be 1-26, otherwise it will be a negative number or a number higher than 26: =CODE(UPPER(A1))-64 Although the above could be modified to return an error for other characters, if that's important, the FIND() method is probably simpler and faster. Asa *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rekha siri *Sent:* Monday, December 26, 2011 2:01 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need help hi experts, please advise the formula to convert the alphabets to numbers. for example a =1 b= 2 c=3 acb =132 like this for each alphabet it should convert text to number. Thanks for your help Regards, Rekha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums
Re: $$Excel-Macros$$ Re: importing text to excel
Sam thanks for your help in this concern however the below code when i try it , i am getting bug in records passed. please assist in this concern. On Wed, Nov 30, 2011 at 4:55 PM, Sam Mathai Chacko samde...@gmail.comwrote: How about this Sub T() Dim rng As Range Dim lngRow As Long With ActiveSheet.QueryTables.Add(Connection:= _ TEXT;P:\Macro\SAP Dump.text.txt, Destination:=Range($A$1)) .Name = SAP Dump.text_1 .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .TextFilePromptOnRefresh = False .TextFilePlatform = 65001 .TextFileStartRow = 1 .TextFileParseType = xlDelimited .TextFileTextQualifier = xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter = False .TextFileTabDelimiter = True .TextFileSemicolonDelimiter = False .TextFileCommaDelimiter = False .TextFileSpaceDelimiter = False .TextFileOtherDelimiter = | .TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1) .TextFileTrailingMinusNumbers = True .Refresh BackgroundQuery:=False End With Set rng = Cells.Find(What:=Records passed, LookAt:=xlPart) Range(A1, rng.Offset(-1)).EntireRow.Delete Cells.Replace What:=--, Replacement:=, LookAt:=xlPart, SearchOrder _ :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False End Sub Sam On Nov 29, 11:28 pm, rekha siri rekha.siri2...@gmail.com wrote: subjectimporting text to excelmailed-bygmail.com hide details 11:47 PM (7 minutes ago) Hi experts, I use the below code to import the text from notepad to excel Sub Macro1() With ActiveSheet.QueryTables.Add(Connection:= _ TEXT;C:\SAP Dump.txt, _ Destination:=Range(A1)) .Name = tab-file .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .TextFilePromptOnRefresh = False .TextFilePlatform = 437 .TextFileStartRow = 1 .TextFileParseType = xlDelimited .TextFileTextQualifier = xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter = False .TextFileTabDelimiter = True .TextFileSemicolonDelimiter = False .TextFileCommaDelimiter = False .TextFileSpaceDelimiter = False .TextFileColumnDataTypes = Array(1, 1) .TextFileTrailingMinusNumbers = True .Refresh BackgroundQuery:=False End With End Sub But i require small modification here please assist in this concern after import i find using control + F The word with Records passed till there ill completely delete the upper rows means till there ill delete. and then do text to column remove all -,| through text to columns and format it. Thanks, Rekha SAP Dump.text.zip 2680KViewDownload -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss
$$Excel-Macros$$ Auto schedule for execution of macro
hi Experts, Please advise is there any option to schedule for particular time to macro for execution on its on own without manual intervention. if so please advise in this concern. Thanks, Rekha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Auto schedule for execution of macro
hi Rajan /sam, thanks for the reply please advise will it execute without opening the macro or we need to open the macro sheet and then fix the reminder. Thanks, Rekha On Sun, Dec 4, 2011 at 7:00 PM, rajan verma rajanverma1...@gmail.comwrote: Sub Test() Application.onTime now+timevalue(00:30:00),ProcedureName end sub it means after 30 minute from now procedure ProcedureName will Execute. On Sun, Dec 4, 2011 at 5:39 PM, Sam Mathai Chacko samde...@gmail.comwrote: Search the net for Application.OnTime Regards, Sam Mathai Chacko On Sun, Dec 4, 2011 at 3:25 PM, rekha siri rekha.siri2...@gmail.comwrote: hi Experts, Please advise is there any option to schedule for particular time to macro for execution on its on own without manual intervention. if so please advise in this concern. Thanks, Rekha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: importing text to excel
sorry for confusion . it is done thanks alot On Sun, Dec 4, 2011 at 10:04 PM, rekha siri rekha.siri2...@gmail.comwrote: i did it by bringing line up it ran well ... but it did not delete the records passed step. On Sun, Dec 4, 2011 at 9:45 PM, dguillett1 dguille...@gmail.com wrote: From the ss it appears that you did not bring up the next line. Bring it up or insert a continuation character _ Don Guillett SalesAid Software dguille...@gmail.com *From:* rekha siri rekha.siri2...@gmail.com *Sent:* Sunday, December 04, 2011 9:51 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Re: importing text to excel i just changed the path and i am getting compile error please find the screen shot for the same On Sun, Dec 4, 2011 at 5:40 PM, Sam Mathai Chacko samde...@gmail.comwrote: working fine at my side. Cannot comment unless you send the excel file and the text file. Sam On Sun, Dec 4, 2011 at 3:20 PM, rekha siri rekha.siri2...@gmail.comwrote: Sam thanks for your help in this concern however the below code when i try it , i am getting bug in records passed. please assist in this concern. On Wed, Nov 30, 2011 at 4:55 PM, Sam Mathai Chacko samde...@gmail.comwrote: How about this Sub T() Dim rng As Range Dim lngRow As Long With ActiveSheet.QueryTables.Add(Connection:= _ TEXT;P:\Macro\SAP Dump.text.txt, Destination:=Range($A$1)) .Name = SAP Dump.text_1 .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .TextFilePromptOnRefresh = False .TextFilePlatform = 65001 .TextFileStartRow = 1 .TextFileParseType = xlDelimited .TextFileTextQualifier = xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter = False .TextFileTabDelimiter = True .TextFileSemicolonDelimiter = False .TextFileCommaDelimiter = False .TextFileSpaceDelimiter = False .TextFileOtherDelimiter = | .TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1) .TextFileTrailingMinusNumbers = True .Refresh BackgroundQuery:=False End With Set rng = Cells.Find(What:=Records passed, LookAt:=xlPart) Range(A1, rng.Offset(-1)).EntireRow.Delete Cells.Replace What:=--, Replacement:=, LookAt:=xlPart, SearchOrder _ :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False End Sub Sam On Nov 29, 11:28 pm, rekha siri rekha.siri2...@gmail.com wrote: subjectimporting text to excelmailed-bygmail.com hide details 11:47 PM (7 minutes ago) Hi experts, I use the below code to import the text from notepad to excel Sub Macro1() With ActiveSheet.QueryTables.Add(Connection:= _ TEXT;C:\SAP Dump.txt, _ Destination:=Range(A1)) .Name = tab-file .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .TextFilePromptOnRefresh = False .TextFilePlatform = 437 .TextFileStartRow = 1 .TextFileParseType = xlDelimited .TextFileTextQualifier = xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter = False .TextFileTabDelimiter = True .TextFileSemicolonDelimiter = False .TextFileCommaDelimiter = False .TextFileSpaceDelimiter = False .TextFileColumnDataTypes = Array(1, 1) .TextFileTrailingMinusNumbers = True .Refresh BackgroundQuery:=False End With End Sub But i require small modification here please assist in this concern after import i find using control + F The word with Records passed till there ill completely delete the upper rows means till there ill delete. and then do text to column remove all -,| through text to columns and format it. Thanks, Rekha SAP Dump.text.zip 2680KViewDownload -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal