Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

Thanks sam, I just want to ask u that i have try the option at my house but i can not able to change the option in my office pc so is there any other option or any macro code for outlook which can solve my problem sorry for late reply. On Tue, Nov 29, 2011 at 7:22 PM, Sam Mathai Chacko wrote: >

Re: $$Excel-Macros$$ Most Helpful Member Nov'11 - Sam Mathai Chacko

Heartiest Congratulations Sam keep up the helping spirit. Regards, DILIPandey On 12/2/11, Ayush Jain wrote: > Hello Everyone, > > Sam Mathai Chacko has been recognised as 'Most Helpful Member' for the > month of Nov'11 > He has posted 129 posts (13% of total posts) in Nov 2011 and helped ma

Re: $$Excel-Macros$$ Working in multiple workbooks

Dear friends thanks for replyinng But I havrent got my solution On Dec 3, 11:19 pm, NOORAIN ANSARI wrote: > Dear B. Sharma, > > Read this article or use VBA Macro mentioned > thereby:-http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html > > Thanks & regards, > Noorain Ansari

Re: $$Excel-Macros$$ Condition Formatting

Dear Aamir, Please see attached Sheet. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Sat, Dec 3, 2011 at 1:46 AM, Aamir Shahzad wrote: > Dear Group

Re: $$Excel-Macros$$ Working in multiple workbooks

Dear B. Sharma, Read this article or use VBA Macro mentioned thereby:- http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ recording macros

Dear Vijay, It is actually Add-in File you have to add it in Add-In. Process : Click the Microsoft Office Button , click Excel Options, and then click Add-Ins. View the add-ins and application extensions that are categorized as follows: Active Application Add-ins: Lists the extensions that are r

Re: $$Excel-Macros$$ fso

Dear Rakesh, Please use below code to open file of Folder, *Sub open_all_fileoffolder() flname = Application.GetOpenFilename(MultiSelect:=True) For Each fname In flname Workbooks.Open fname Next End Sub * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ recording macros

Hi Noorain, Its not opening.Only excel window is opening but not able to see sheets.. can you send it once again Please ? Thanks On Sat, Dec 3, 2011 at 11:23 PM, NOORAIN ANSARI wrote: > Dear Vijay, > > Please use this add-in to Compare Sheets. > > Thanks & regards, > Noorain Ansari > *http://ex

Re: $$Excel-Macros$$ recording macros

Ok Rajan,thanks but i want to know is this possible to record a macro from oneworkbook to another workbook.? Thanks On Sat, Dec 3, 2011 at 8:14 PM, rajan verma wrote: > I think macro recording is not a good idea to find duplicates ... because > most of time sheet Name will change.. Data Ran

Re: $$Excel-Macros$$ Correction in Formula

Dear Aamir, Please use *=SUMPRODUCT(--($F$3:$F$14=B5)*($G$3:$G$14>9))* See attached sheet.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Sat, Dec 3

Re: $$Excel-Macros$$ Project

Sub Consolidator() Dim rng As Range Dim lng As Long Dim var As Variant With Worksheets("Sheet1") lng = Application.CountIf(.Range("D1", .Cells(Rows.Count, "D").End(xlUp)), "Name of party") ReDim var(0 To lng, 0 To 4) var(0, 0) = "Sl No.": var(0, 1) = "Unit

Re: $$Excel-Macros$$ Expert Advice Needed - in VBA.

http://tinyurl.com/72uneme Don Guillett SalesAid Software dguille...@gmail.com From: Secret Shot Sent: Saturday, December 03, 2011 8:46 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Expert Advice Needed - in VBA. Hay Guy,, Can any one please Help me in this, this is

Re: $$Excel-Macros$$ ActiveX Setting in Excel 2003

Dear Rajan, Its not working for me... :(, Regards Pankaj k Pandey On Sat, Dec 3, 2011 at 8:50 PM, rajan verma wrote: > Hope it will help > http://www.mrexcel.com/forum/showthread.php?t=71323 > > > On Sat, Dec 3, 2011 at 8:16 PM, Secret Shot wrote: > >> Hay Guy,, >> >> Can any one please H

Re: $$Excel-Macros$$ ActiveX Setting in Excel 2003

Hope it will help http://www.mrexcel.com/forum/showthread.php?t=71323 On Sat, Dec 3, 2011 at 8:16 PM, Secret Shot wrote: > Hay Guy,, > > Can any one please Help me in this, this is really critical.. > > Regards > Pankaj k Pandey > > > On Sat, Dec 3, 2011 at 4:26 AM, Secret Shot wrote: > >>

Re: $$Excel-Macros$$ About Marcros in 2007

please ignore that post., You can download this book.. http://www.rencross.co.uk/ebookshelf/Microsoft/Visual%20Basic/Office/VBA/Excel%202007%20Power%20Programming%20With%20VBA.pdf On Sat, Dec 3, 2011 at 8:43 PM, rajan verma wrote: > hi > its a strange problem but hope it will help you .. > > htt

Re: $$Excel-Macros$$ About Marcros in 2007

hi its a strange problem but hope it will help you .. http://www.mrexcel.com/forum/showthread.php?t=71323 On Thu, Dec 1, 2011 at 6:04 PM, Aivi wrote: > Hi,Friends > > Any body give the refernce of MACRO IN EXECEL 2007, How can create and how > do work the with macros > Pls give me some example

Re: $$Excel-Macros$$ Indirect Function

if we need to know how many Rows Contains data we can use indirect function like this : =ROWS(INDIRECT("A1:A"&COUNTA(A:A))) On Thu, Dec 1, 2011 at 11:19 PM, Aamir Shahzad wrote: > thanks Noorain / Chethan Kumar. > > Regards, > > Aamir Shahzad > > On Thu, Dec 1, 2011 at 9:03 AM, Dhartikumar Sahu

Re: $$Excel-Macros$$ Correction in Formula

you can use Countifs like this.. if you want to compare value you need to put the operator ("<" & ">") in inverted COmmas.. =countifs(B1:B17,"<10",A1:A17,">10") On Sat, Dec 3, 2011 at 4:49 AM, B.N.Chethan Kumar wrote: > Please find the information as requested > > > On Sat, Dec 3, 2011 at 1:25

Re: $$Excel-Macros$$ ActiveX Setting in Excel 2003

Hay Guy,, Can any one please Help me in this, this is really critical.. Regards Pankaj k Pandey On Sat, Dec 3, 2011 at 4:26 AM, Secret Shot wrote: > Dear Experts, > > Can anyone please tell me that how to Enable Activex Setting in Excel > 2003. I know how to do this in 2007. > Excel Option

Re: $$Excel-Macros$$ Expert Advice Needed - in VBA.

Hay Guy,, Can any one please Help me in this, this is really critical.. Regards Pankaj k Pandey On Sat, Dec 3, 2011 at 3:34 AM, Secret Shot wrote: > Dear Experts, > > Greeting of the Day, > > I am facing a very strength problem, I have created a workbook, which have > 2 Text box and 2 Com

Re: $$Excel-Macros$$ recording macros

I think macro recording is not a good idea to find duplicates ... because most of time sheet Name will change.. Data Range at worksheet will change.. You can write a macro for this purpose..by using conditional Formatting.. On Sat, Dec 3, 2011 at 9:32 AM, vijayajith VA wrote: > Hi > > I have tw

Re: $$Excel-Macros$$ What does -- suggest in formula.

As it convert TRUE/False into 1/0 ..we can debug formula error easily.. On Sat, Dec 3, 2011 at 4:02 PM, Sam Mathai Chacko wrote: > Sandeep, > > The -- is used as an unary operator to convert a boolean value ie, > TRUE/FALSE in to 1/0. Sumproduct for example does not evaluate non-numeric > values

Re: $$Excel-Macros$$ fso

By FileSystemObject we can do operation with File and folder..Here is code for that.. Sub GetAllFilesInAFolder() Dim fso As New Scripting.FileSystemObject Dim flFIle As File Dim fdFOlder As Folder Set fdFOlder = fso.GetFolder("C:\Documents and Settings\Cyber Junction\My Documents"

Re: $$Excel-Macros$$ Data validation not working properly

Remove check from Ignore Blanks in data validatoin On Sat, Dec 3, 2011 at 7:20 PM, dguillett1 wrote: > Try removing blank cells in your defined name list or ' ' ' > > > > Don Guillett > SalesAid Software > dguille...@gmail.com > -Original Message- From: B Sharma > Sent: Friday, December

Re: $$Excel-Macros$$ How to close many files at a time

This assumes you have a list of files entered in cells and have used ctrl to select the file(s) to close You can use another macro to make the list if not there Sub CloseSelectedWorkbooks() On Error Resume Next Application.DisplayAlerts = False For Each wb In Selection workbookname = wb.Value W

Re: $$Excel-Macros$$ Data validation not working properly

Try removing blank cells in your defined name list or ' ' ' Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: B Sharma Sent: Friday, December 02, 2011 10:52 PM To: MS EXCEL AND VBA MACROS Cc: rajanverma1...@gmail.com Subject: $$Excel-Macros$$ Data validation

$$Excel-Macros$$ How to close many files at a time

Hi All, In case if i want to close many excel files (& not all) or emails all at a time (in stead of selecting one at a time - want to select many..), how can we do that? Regards, Amit Desai Disclaimer: This message and its attachments contain confidential info

Re: $$Excel-Macros$$ fso

Rakesh, Application.FileSearch has been discontinued from Excel 2007 for reasons I am still not sure why. You can find an alternative method here. http://www.ozgrid.com/forum/showthread.php?t=147929 Regards, Sam Mathai Chacko On Sat, Dec 3, 2011 at 6:20 PM, Rakesh Joshi wrote: > Hi Ashish, >

$$Excel-Macros$$ fso

Hi Ashish, i need to open all files in a folder and run the macro regarding macro i can take care but opening all files in folder i am getting trouble application .filesearch is not working 2010 coudl you please let me know how to do that. -- Rakesh Joshi -- FORUM RULES (934+ members already B

Re: $$Excel-Macros$$ Most Helpful Member Nov'11 - Sam Mathai Chacko

congrats sam... On 12/3/11, Sam Mathai Chacko wrote: > Dear fellow members of this group, > > Thank you for all the kind words. For all who have posted here, a big > thanks, and I would like to keep it as a blanket thanks for anybody posting > in later (if they do :D). > > As I always maintain, i

Re: $$Excel-Macros$$ update link automatically in excel sheet

Hi Debasish, Also try Find and Replace option. *Select the cells > Ctr+H * [image: find replace.jpg] Regards, MARIES. +971559828492 On Sat, Dec 3, 2011 at 2:43 PM, Sam Mathai Chacko wrote: > The edit links feature in Excel is specifically given for this. YOu just > need to browse for the

Re: $$Excel-Macros$$ update link automatically in excel sheet

The edit links feature in Excel is specifically given for this. YOu just need to browse for the new file, and OK it. Did you try that? Regards, Sam Mathai Chacko On Sat, Dec 3, 2011 at 12:20 PM, debasish wrote: > Hi, > I maintain my monthly production figure in a excel file.The file is > maint

Re: $$Excel-Macros$$ What does -- suggest in formula.

Sandeep, The -- is used as an unary operator to convert a boolean value ie, TRUE/FALSE in to 1/0. Sumproduct for example does not evaluate non-numeric values that results in a formula like the boolean results in the array equation A1:A10="Sandeep". So to negate this, we use unary operator -- with

Re: $$Excel-Macros$$ Most Helpful Member Nov'11 - Sam Mathai Chacko

Dear fellow members of this group, Thank you for all the kind words. For all who have posted here, a big thanks, and I would like to keep it as a blanket thanks for anybody posting in later (if they do :D). As I always maintain, it is good to be a part of such a group. All regards to Donald, Noor

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

While most of the solutions revolve around getting the second highest value from a list of duplicates, here's something that will help you get a unique list of Large values from a list of duplicates. =IF(ROW($A$1:$A$10)=ROW(),LARGE($A$1:$A$10,1),LARGE($A$1:$A$10,ROWS($A$1:$A$10)-COUNTIF($A$1:$A$10

$$Excel-Macros$$ update link automatically in excel sheet

Hi, I maintain my monthly production figure in a excel file.The file is maintained for each Financial year. In one of the sheet I keep values for different months by giving links to values present in other sheets from same files & some values from other excel file. Now I want to make new file for