Re: $$Excel-Macros$$ Need a Macro

2012-07-24 Thread NOORAIN ANSARI
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

Re: $$Excel-Macros$$ Help needed to count and sum data between two fixed dates.

2012-07-24 Thread noorain.ansari
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

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 6 Messages in 5 Topics

2012-07-24 Thread Praskandan
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

$$Excel-Macros$$ Some Help

2012-07-24 Thread ashjain2...@yahoo.co.in
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

RE: $$Excel-Macros$$ Some Help

2012-07-24 Thread Krishnaraddi V. Madolli
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:

$$Excel-Macros$$ Unable to open other Excel Files when using VBA form

2012-07-24 Thread sharath chandra
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

Re: $$Excel-Macros$$ Unable to open other Excel Files when using VBA form

2012-07-24 Thread Paul Schreiner
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

$$Excel-Macros$$ back up - vba code

2012-07-24 Thread raghu gr
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

Re: $$Excel-Macros$$ back up - vba code

2012-07-24 Thread dguillett1
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

Re: $$Excel-Macros$$ Unable to open other Excel Files when using VBA form

2012-07-24 Thread t vinay
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

Re: $$Excel-Macros$$ save excel file to dbf III file in ms excel 2007

2012-07-24 Thread dguillett1
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$$ Re: ♍Ɣ President is Dead

2012-07-24 Thread bpascal123
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

Re: $$Excel-Macros$$ Re: ♍Ɣ President is Dead

2012-07-24 Thread respuzy
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$$ Re: Summary Sheet for all Employees

2012-07-24 Thread bpascal123
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

$$Excel-Macros$$ Re: Sum on 2 conditions(one in column one in row) to another cell

2012-07-24 Thread bpascal123
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

$$Excel-Macros$$ Re: transfer data automatically from journal sheet to ledger sheet

2012-07-24 Thread bpascal123
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

Re: $$Excel-Macros$$ =IF(ISNUMBER($N3),INDEX(Master!$C:$C,N3,1),)

2012-07-24 Thread David Grugeon
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...

$$Excel-Macros$$ How to count

2012-07-24 Thread jayendra gaurav
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,

Re: $$Excel-Macros$$ How to count

2012-07-24 Thread अनिल नारायण गवली
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+