Re: $$Excel-Macros$$ Need a Macro
Dear NRao, Please try it... Change path as per your requirement and Select Tools-Reference-Microsoft Scripting Runtime before run the macro Sub Consodilate_workbook() Dim wb As Workbook Dim rng As Range Dim fil As File Dim i As Integer Set wb = ThisWorkbook Dim fld As Folder Dim FSO As FileSystemObject Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Application.DisplayAlerts = False Set FSO = New FileSystemObject Set fld = FSO.GetFolder(D:\FSO\) For Each fil In fld.Files i = wb.Sheets(1).Cells(Rows.Count, A).End(xlUp).Row + 1 Workbooks.Open fil 'For Heading ActiveWorkbook.Sheets(1).Range(A1:C1).Copy wb.Sheets(3).Cells(1, 1) ActiveWorkbook.Sheets(2).Range(A2:C ActiveWorkbook.Sheets(1).Cells(Rows.Count, c).End(xlUp).Row).Copy wb.Sheets(1).Cells(i, 1) ActiveWorkbook.Save ActiveWorkbook.Close Next fil Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic Application.DisplayAlerts = True End Sub On Tue, Jul 24, 2012 at 10:58 AM, NRao Mynampati ml.narasimha...@gmail.comwrote: Hi Team, I have a morethan 10 workbooks in a folder , I need a macro for consoldate all workbooks into single workbook. 1) some of the sheets have morethan 70,000 recoreds (rows) filled -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.blogspot.comhttp://www.excelvbaclinic.blogspot.com http://accesssqclinic.blogspot.in/ -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Help needed to count and sum data between two fixed dates.
Dear Sanotsh, If you are using Excel 2007+, Attached sheet will also helpful for you. On Sat, Jul 21, 2012 at 4:38 PM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hi Group, Need another help to count and sum data between two fixed dates. Regards Santosh santoshkumar.subu...@gmail.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.blogspot.comhttp://www.excelvbaclinic.blogspot.com http://accesssqclinic.blogspot.in/ -- -- 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 Copy of count if(Santosh).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 6 Messages in 5 Topics
Hi, Need Help on Vlook Up in Excel 2007:- A Case is assigned to Person 1 (Column B) ...As a back up it is sometimes assigned to Person 2 (Column C) So if Case ID is in Column A , there is always name of Person in Column B. But only some cases are Assigned Person 2 in Column C. I want to lookup both these columns in another Sheet. This another Sheet has Names of these Persons and their Respective Departments. I want to write a Vlookup Function which first returns Department for Person 1 . If Person 1 is not available in another Sheet, it should do lookup for Person 2 in this sheet and return the department. if both Persons 1 and Person 2 are not available in the lookup table (Another Sheet), it can return # N/A Please help. On Tue, Jul 24, 2012 at 5:55 AM, excel-macros@googlegroups.com wrote: Today's Topic Summary Group: http://groups.google.com/group/excel-macros/topics - Company Name in front of Show its sector#138b6602a29a6d52_group_thread_0[1 Update] - Macro - Copy Range and Open Outlook Draft and Paste#138b6602a29a6d52_group_thread_1[1 Update] - need to consolidate data in one sheet#138b6602a29a6d52_group_thread_2[1 Update] - Submit data into web forms #138b6602a29a6d52_group_thread_3 [1 Update] - Paste Special With transpose and links to the source data#138b6602a29a6d52_group_thread_4[2 Updates] Company Name in front of Show its sectorhttp://groups.google.com/group/excel-macros/t/d7c8a2e8b0c7231e dguillett1 dguille...@gmail.com Jul 23 04:23PM -0500 You need to send ME a FILE showing EXACTLY what you want Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amar takale Sent: Thursday, July 19, 2012 11:58 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Company Name in front of Show its sector I used this code But not work. Which I send second file sample 1 Use it put code. If I put code run code not work. Y also try.My answer in sheet like H D F C Bank Ltd. Bank State Bank Of India Bank Tata Steel Ltd. Metals Minerals Sterlite Industries (India) Ltd. Metals Minerals Mahindra Mahindra Ltd. Auto Maruti Suzuki India Ltd.Auto On Thu, Jul 19, 2012 at 6:39 PM, dguillett1 dguille...@gmail.com wrote: You asked for a macro and I provided one that did work with your example. Please fully explain. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amar takale Sent: Thursday, July 19, 2012 7:59 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Company Name in front of Show its sector Code is not work.I will Sent file You will work with below code.I use but not work.There are any formula? On Thu, Jul 19, 2012 at 6:09 PM, dguillett1 dguille...@gmail.com wrote: Should work Option Explicit Sub groupsSAS() Dim mr As Range Dim b As Range Dim sr As Long Rows(2).Insert Set mr = Cells(2, b) _ .Resize(Cells(Rows.Count, b).End(xlUp).Row) For Each b In mr.SpecialCells(xlBlanks) sr = b.Offset(-1).End(xlUp).Row Cells(sr, c) _ .Resize(b.Row - sr + 1).Value = Cells(sr, b) Next b End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amar takale Sent: Thursday, July 19, 2012 5:54 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Company Name in front of Show its sector -- -- 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 mailto: excel-macros%2bunsubscr...@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
$$Excel-Macros$$ Some Help
We want to use data validation... Please see the attachment Ashok Maroti -- -- 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 Ashok.xlsx Description: Tag-d9398a9c-1ca0-4c8d-b39b-432ba35fde20
RE: $$Excel-Macros$$ Some Help
Solution Attached. Regards, Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPIP Area, Whitefield Bangalore - 560 066. India. Direct Line: +1.800.920.9657 Extn 1915 Switchboard: +90-(0)80-3054 Extn 1915 Email: krishnaraddi.mado...@asia.xchanging.com krishnaraddi.mado...@sedgwickcms.com www.sedgwickcms.com | The leader in innovative claims and productivity management solutions Success is never permanent, Failure is never final, so always do not stop effort until your victory makes a history. Please consider the environment before printing this message -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashjain2...@yahoo.co.in Sent: Tuesday, July 24, 2012 6:53 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Some Help We want to use data validation... Please see the attachment Ashok Maroti -- -- 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 CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system. -- -- 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 Ashok.xls Description: Ashok.xls
$$Excel-Macros$$ Unable to open other Excel Files when using VBA form
Hello Experts, We have created a VBA form. When we have the form open, we are unable to open any other Excel workbooks. Is there any way where we can enable multiple instances parallel to VBA form? Thank you in advance. Regards, Sharath -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Unable to open other Excel Files when using VBA form
It's possible to do what you're asking, but it's not entirely necessary. There is a property called modality. What it basically refers to is the mode of the form you display. If the form is modal then it is tied to the Excel workbook and must be dealt with before anything Excel can proceed. If the form is modeless, then it basically hangs out there and allows the user to continue to use Excel. to open the form modeless use: formname.Show vbModeless or formname.Show 0 now, if you still want to open multiple instances of Excel, we'll have to work with some Windows settings. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: sharath chandra sharath.c.sambr...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, July 24, 2012 11:49:47 AM Subject: $$Excel-Macros$$ Unable to open other Excel Files when using VBA form Hello Experts, We have created a VBA form. When we have the form open, we are unable to open any other Excel workbooks. Is there any way where we can enable multiple instances parallel to VBA form? Thank you in advance. Regards, Sharath-- -- 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$$ back up - vba code
Hi, I want to take backup of excel files periodically from some specified path and to specified path, is there vba code for same. Thank you with regards Raghu -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ back up - vba code
Sub Backup() 'kept in personal.xls assigned to toolbar button On Error GoTo BackupFile MkDir CurDir \Backup BackupFile: Here are some sub backup() With ActiveWorkbook MyWB = .Path \BACKUP\ .Name .SaveCopyAs MyWB .Save End With End Sub Sub Backup1() FNAME = ActiveWorkbook.Name MyWB = ActiveWorkbook.Path \BACKUP\ FNAME ActiveWorkbook.SaveCopyAs MyWB 'MsgBox fname 'ActiveWorkbook.SaveCopyAs C:\personal\BACKUP\ FNAME ActiveWorkbook.Save End Sub Sub Backup_SameDirectory() Application.DisplayAlerts = False FNAME = ActiveWorkbook.FullName ' File Name Including Path(Directory) FnameA = Left(FNAME, Len(FNAME) - 4) A.xls ' Strips.xls and adds A.xls 'ActiveWorkbook.SaveCopyAs C:\msoffice\personal\BACKUP\ Fname ActiveWorkbook.SaveCopyAs FnameA ' Same Directory ActiveWorkbook.Save Application.DisplayAlerts = True End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: raghu gr Sent: Tuesday, July 24, 2012 11:34 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ back up - vba code Hi, I want to take backup of excel files periodically from some specified path and to specified path, is there vba code for same. Thank you with regards Raghu -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Unable to open other Excel Files when using VBA form
Thanks Paul.. On 24 July 2012 21:38, Paul Schreiner schreiner_p...@att.net wrote: It's possible to do what you're asking, but it's not entirely necessary. There is a property called modality. What it basically refers to is the mode of the form you display. If the form is modal then it is tied to the Excel workbook and must be dealt with before anything Excel can proceed. If the form is modeless, then it basically hangs out there and allows the user to continue to use Excel. to open the form modeless use: formname.Show vbModeless or formname.Show 0 now, if you still want to open multiple instances of Excel, we'll have to work with some Windows settings. *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* sharath chandra sharath.c.sambr...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, July 24, 2012 11:49:47 AM *Subject:* $$Excel-Macros$$ Unable to open other Excel Files when using VBA form Hello Experts, We have created a VBA form. When we have the form open, we are unable to open any other Excel workbooks. Is there any way where we can enable multiple instances parallel to VBA form? Thank you in advance. Regards, Sharath -- -- 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 -- Regards, Vinay. T -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ save excel file to dbf III file in ms excel 2007
http://appscout.pcmag.com/your-questions/274021-excel-2007-can-t-save-as-dbf http://www.dbforums.com/microsoft-excel/1644233-excel-2007-add-save-dbf.html Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Govind Mori Sent: Tuesday, July 24, 2012 12:02 AM To: excel-macros Subject: $$Excel-Macros$$ save excel file to dbf III file in ms excel 2007 Dear expert I was able to save excel data to DBF III file through save as option in 97-2003 version, But in 2007 version how could i save excel data to DBF III format as i am unable find save as to dbf option in 2007 version of Excel. Please advice me. Thanks in advance Govind Mori -- -- 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$$ Re: ♍Ɣ President is Dead
He was elected a year ago I think... Should he rest in peace! -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: ♍Ɣ President is Dead
Thanks man. He was elected in 2009 and was going to run for the 2nd term in Dec this year The vice president has just been sworn in as President Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: bpascal123 bpascal...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 24 Jul 2012 12:57:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: resp...@gmail.com Subject: $$Excel-Macros$$ Re:President is Dead He was elected a year ago I think... Should he rest in peace! -- -- 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$$ Re: Summary Sheet for all Employees
Have you tried managing your data with a pivot table? -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Re: Sum on 2 conditions(one in column one in row) to another cell
Hi, Have you thought about a pivot table before going coding a macro? cells(i,j) notation is about 2 dimensional array. If you want to work any values in there, you then need 2 loops. Now, you must know before hand which direction you need to take, are you going by rows or by columns? This is what confuses me in your query. going by rows: i = 3 j = 1 for i = 2 to 31 if cell(i,j) ... then ... 'enter loop j for j = 2 to 11 if cell(i,j) next j end if next i going by columns: i = 2 j = 3 for i = 4 to 11 if cell(i,j) ... then for j = 3 to 31 cell(i,j) ... next j next i If cell(i,j) makes sense, I think you want to loop by rows. As for me, the way you explain is a little confusing. You should either choose a full pseudo code or algorithm or explain this with more words because it's difficult to see where i and j are supposed to be. Maybe someone else can see this better than me... Pascal Baro -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Re: transfer data automatically from journal sheet to ledger sheet
dsum formula can help with transactions related to ledger accounts -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ =IF(ISNUMBER($N3),INDEX(Master!$C:$C,N3,1),)
As there is no data in column N of the Master sheet it is correctly returning the value of a blank cell which is 0 Regards David Grugeon On 24 July 2012 21:16, Zibraan lucky60...@gmail.com wrote: Hi Team, Attached is the sheet but somehow its not working please help me regarding this... =IF(ISNUMBER($N3),INDEX(Master!$C:$C,N3,1),) Regards, Jay S -- -- 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 -- 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
$$Excel-Macros$$ How to count
Team, How to count a cell based on color . file is attached for your's reference. -- J.Gaurav Call-7838594954 -- -- 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 doc.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ How to count
dear Jayendra Pls find Attached Excel sheet for your ref Regards, Anil Gawli On Wed, Jul 25, 2012 at 10:10 AM, jayendra gaurav wrote: Team, How to count a cell based on color . file is attached for your's reference. -- J.Gaurav Call-7838594954 -- -- 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, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- -- 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 doc.xlsm Description: Binary data