Re: $$Excel-Macros$$ Description while using Macro Functions in Excel
hi all, please help Thanks On Tue, Jan 4, 2011 at 1:38 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi gurumurthy, you are right. I want to see the description in our macro function as we see for microsoft functions. hi Haigreeva, as per the comments by the gurumurthy, I want to see the description in our macro function as we see for microsoft functions. hi Kiran, i am using Excel 2007 version. Thanks On Tue, Jan 4, 2011 at 12:43 PM, hanumant shinde hanumant_5...@yahoo.co.in wrote: Hi gurumurthy, i dont think he means what u said. he means lets say we write =sum(A1+A2) in excel cell you will see some info for sum function which is provided by microsoft itself. but if we have developed our own function (lets say ofunct) and we type this function in any cell like =ofunct() then e shud see the same kind of info as we see for miscrosoft functions. @Rajesh please correct me if i m wrong. -- *From:* gurumurthy sastry Kondury gurumurthy.sas...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, 4 January, 2011 10:31:34 AM *Subject:* Re: $$Excel-Macros$$ Description while using Macro Functions in Excel Hi Rajesh, If your question is to use the function in one Cell ( Say B1) and to show the description of the Function in the next cell ( say C1) , then use your function in Cell B1, and put the same function in Cell C1 leaving one space. See Example below =IF(logical_test, value_if_true, value_if_false) This is how you normally put the function. =IF(logical_test, value_if_true, value_if_false) Here you leave a space in Cell C1 and here its just a text but not the function. Hope this helps. Or correct me If my understanding is wrong. Best Regards, Haigreeva On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra rajafs...@gmail.comwrote: hi Group, i want to show description of the Function while using the same in Excel like below screen shot. e.g while using if function in excel it displays like =if(logical_test, value_if_true, value_if_false) thanks Rajesh Mahapatra -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Description while using Macro Functions in Excel
hi rajesh very gud explantion On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi Group, i want to show description of the Function while using the same in Excel like below screen shot. e.g while using if function in excel it displays like =if(logical_test, value_if_true, value_if_false) thanks Rajesh Mahapatra -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey
hi dilip sir i always felt that one day u will get this title.. congrates On Tue, Jan 4, 2011 at 8:50 PM, Suryaprasad suryaprasad...@gmail.com wrote: Congrats Dilip On Tue, Jan 4, 2011 at 7:37 PM, sharad gupta sharadgupta2...@gmail.com wrote: Hi Dilip Sir, Congratulations to you . That is good news on new year 2011. sharad gupta On Mon, Jan 3, 2011 at 7:32 PM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Congrats Dilip... Best Regards, Manoj Kumar On Mon, Jan 3, 2011 at 8:50 AM, ashish koul koul.ash...@gmail.com wrote: congrats dilip On Mon, Jan 3, 2011 at 4:48 PM, vidyut more vidyutm...@gmail.com wrote: hi Dilip ji Congratulations to you and Hatsoff u On Mon, Jan 3, 2011 at 3:35 PM, bhavya khanna bhavya...@gmail.com wrote: Hi Dilip Sir, Congratulations to you . That is good news on new year 2011. and where is treat ? On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am very very very very happy to share a good news with you. One of our dearest group member Dilip Kumar Pandey is awarded Microsoft MVP award on 1st January for his exceptional Excel skills and voluntary contribution. He is well deserving for the award and I am very happy about his recognition. Dear Dilip, Many Many congratulations, Keep it up. I am very proud of you to be part of this group. I wish your long association with this group. Best Regards, Ayush Jain Microsoft MVP-2010 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts --
RE: $$Excel-Macros$$ Custom UDF
Hi, A UDF (User Defined Function) is like any other function. It can only return a value. It cannot do anything else. To change the background colour of a cell, use Conditional formatting or a regular macro. Regards - Dave. Date: Wed, 5 Jan 2011 06:50:53 +0530 Subject: Fwd: $$Excel-Macros$$ Custom UDF From: anjulav...@gmail.com To: excel-macros@googlegroups.com Can any one answer the below or only simple questions are answered here just to become MVP -- Forwarded message -- From: Anju anjulav...@gmail.com Date: Mon, Jan 3, 2011 at 12:44 PM Subject: $$Excel-Macros$$ Custom UDF To: excel-macros@googlegroups.com Hi Team, Can anyone give me a Custom UDF which changes the cells back ground color. I have read that UDF cannot change the physical characteristic of a cell...but are there any exceptions. Please Help Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: Method 'Calculation' of object '_Application' failed
There's GOT to be something else going on. I created a new file with.xlam extension. Protected the Sheet and Workbook Created a sub called Init with only the line: Application.Calculation = xlCalculationAutomatic Created a Workbook_Open sub calling Init. It worked just fine. I also tried it with an Auto_Open sub, it worked also. So, there must be something else going on. Do you know if it is user-specific or workstation specific? (test it on another PC, and with another user) Can you send me some sample files to test? Paul On Jan 4, 12:42 pm, crconti charlesrcon...@hotmail.com wrote: Getting this error when trying to execute the following statement in Auto_Open macro: Application.Calculation = xlCalculationAutomatic We have a group of Excel templates where the Workbook is password protected, as well as some sheets that are protected. We also use .xlam file that contains some macros that are called once the Excel document is opened. Any ideas of setting the Caluclation to Automatic without getting this error message Thanks, Charles -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Macro with condition
Hi, Though not a macro... but still works the same...pls chk the attached Regards, Manoj Kumar On Wed, Jan 5, 2011 at 3:52 PM, Jorge Marques leote.w...@gmail.com wrote: Hi guys, i´m need your help, i have a list of brands, that i need to put values of sales of the various shops , from cell B2:B15, and i need that when i select a brand from cell B1 it will copy automatically the value from cell B16 to the cells from D2 to K2, example, if i select Adidas it will copy the value of B16 to the cell E2 i annexed a excel example Thank you very much in advance :) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts macrohelp.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey
Dear Mr. Dilip *Congratulations to you* Regards Sumit Vyas On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am very very very very happy to share a good news with you. One of our dearest group member Dilip Kumar Pandey is awarded Microsoft MVP award on 1st January for his exceptional Excel skills and voluntary contribution. He is well deserving for the award and I am very happy about his recognition. Dear Dilip, Many Many congratulations, Keep it up. I am very proud of you to be part of this group. I wish your long association with this group. Best Regards, Ayush Jain Microsoft MVP-2010 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: Problem in Data Validation in Excel
Hi Jitendra, A solution can be found here: http://www.ozgrid.com/Excel/dependent-lists.htm On 4 jan, 10:15, Jitendra Verma jitendra.kumarve...@gmail.com wrote: Hi All, I have a question related to data validation in excel. Below is the description.. I want to create two dropdown list using the data validation list. one is for countries and other is for State of the countries. My question is if i select country from first dropdown thee second dropdown populate only the state of India country. -- *Thanks and Regards,* Jitendra Kr. Verma| Sr. Software Engineer Mob: +91.9700695633 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ How to learn VBA Languages and Macros
Hey Susan,, If you have that book then please send it to my email address or attach here... my email address issharma(dot)ctc(at the rate)gmail(dot)com Thanks Regards, B. Sharma On Dec 30 2010, 9:43 pm, Susan susan.m.ander...@comcast.net wrote: I useExcel2007 Visual Basic for Applications, Step by Step. This book was extremely helpful to me as I am a new in learning VB and wanted to write more extensive macros. Susan -Original Message- From:excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of B Sharma Sent: Thursday, December 30, 2010 3:13 AM To: MSEXCELANDVBAMACROS Subject: $$Excel-Macros$$ How to learnVBALanguages and Macros Dear Friends, Firstly I want to thank you all for making and using this wonderful educational site. Its really superb. I am somewhat good inexcelinbuilt formulas functions and able to complete most of my work through that. But I need your help as I want to learnVBAprogramming Macros and want to automate my working. Please suggest me the way, I want to know how to write programs starting with some small programs in a easy language along with the meaning /definition of objects, array, classes, etc. How to write programmes. Along with this I will appreciate if peoples send me their working files, learning books, etc. through which I can learn programmes, etc. -- --- - -- Some important links forexcelusers: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3.Exceltutorials athttp://www.excel-macros.blogspot.com 4. LearnVBAMacros athttp://www.quickvba.blogspot.com 5.ExcelTips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email toexcel-mac...@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey
Hi Dilip, Many many congratulation to you. This group needs you. Keep it up. On Wed, Jan 5, 2011 at 4:45 PM, SUMIT VYAS svyas0...@gmail.com wrote: Dear Mr. Dilip *Congratulations to you* Regards Sumit Vyas On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am very very very very happy to share a good news with you. One of our dearest group member Dilip Kumar Pandey is awarded Microsoft MVP award on 1st January for his exceptional Excel skills and voluntary contribution. He is well deserving for the award and I am very happy about his recognition. Dear Dilip, Many Many congratulations, Keep it up. I am very proud of you to be part of this group. I wish your long association with this group. Best Regards, Ayush Jain Microsoft MVP-2010 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ How to use 'Custom' Format for Numbers, Dates and Text in Excel?
Good one. Hope the attachment meet your expectation. Thanks and regards, Maidul On Wed, Jan 5, 2011 at 1:36 AM, OpenExcel.com ashishj...@openexcel.comwrote: Hi Friends, *What is 'Custom Format' ?:* Microsoft Office Excel provides many built-in number formats, but in some cases they do not meet our needs, we can customize a built-in number format to create our own. *Why 'Custom Format' and not 'Conditional Formatting'?:* because to cure 'Common Cold' we go to doctors not surgeons. Exactly, when there is a simple and robust way then why to go otherwise. There are many benefits of using custom format including these: 1. Less overhead than Conditional Formatting. 2. Values can be used easily in formulas (Less manipulation required). 3. Charts looks better with custom colored labels/axis. 4. Works on all versions of Excel. and many more which you can figure out using your innovative mind after reading this article. Do you know how to use 'Custom' format in Excelhttp://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html, if yes then solve these 5 questions on 'Custom' format ... *COMMENTS * *TO DISPLAY* *AS * *USE WHICH CUSTOM FORMAT* Negative Number -123000 (123K) ? Date 26/05/1984 Sat, May '84 Currency 6.56 £7 Labels 25 25 feet Round off to 100th 987654321 988 If you don't know much about 'Custom' format then learn here. Hope you'll enjoy it :)http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html __ Thanks Regards Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com __ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts Custom Format.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ prevent copying xl files
Hello Rajesh, There is no foolproof method for this.Try to use run security macro before opening workbook. Try to do this.To avoid unauthorized use of your workbook. 1.Write the Machine name of Authorized person line by line in notepad 2.Save it with your desirables name 3.Check machine name before opening Workbook/ Else close Workbook. For any problem to doing this stuff,Send me mail.. Hope it Will Help On Wed, Jan 5, 2011 at 7:04 PM, Rajesh K R rajeshkainikk...@gmail.com wrote: Hi Experts, Is it possible to prevent coping a particular Excel work book , from my computer. I am thinking if the macro has an address like computer name\d\rajesh.xls it will not work in other computer other location without my permission, I don't know is it possible or is there a better way for this. pls write me Regards Rajesh Kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Regards, Prashant Tripathi Engineer-SW Mobile: 0017202597567 Please consider the environment before printing. Immer zielen auf die vollkommene Harmonie des Denkens Wort deed.Always zielen darauf ab, reinigen Sie Ihre Meinung und alles wird gut. Always aim at complete harmony of thought word deed.Always aim at purifying your thoughts everything will be well. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
RE: $$Excel-Macros$$ How to learn VBA Languages and Macros
Hi, I paid for the book via Amazon.com... you could check out your local library perhaps they have it to check out for 'free'. Susan -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of B Sharma Sent: Wednesday, January 05, 2011 3:30 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ How to learn VBA Languages and Macros Hey Susan,, If you have that book then please send it to my email address or attach here... my email address issharma(dot)ctc(at the rate)gmail(dot)com Thanks Regards, B. Sharma On Dec 30 2010, 9:43 pm, Susan susan.m.ander...@comcast.net wrote: I useExcel2007 Visual Basic for Applications, Step by Step. This book was extremely helpful to me as I am a new in learning VB and wanted to write more extensive macros. Susan -Original Message- From:excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of B Sharma Sent: Thursday, December 30, 2010 3:13 AM To: MSEXCELANDVBAMACROS Subject: $$Excel-Macros$$ How to learnVBALanguages and Macros Dear Friends, Firstly I want to thank you all for making and using this wonderful educational site. Its really superb. I am somewhat good inexcelinbuilt formulas functions and able to complete most of my work through that. But I need your help as I want to learnVBAprogramming Macros and want to automate my working. Please suggest me the way, I want to know how to write programs starting with some small programs in a easy language along with the meaning /definition of objects, array, classes, etc. How to write programmes. Along with this I will appreciate if peoples send me their working files, learning books, etc. through which I can learn programmes, etc. -- --- - -- Some important links forexcelusers: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3.Exceltutorials athttp://www.excel-macros.blogspot.com 4. LearnVBAMacros athttp://www.quickvba.blogspot.com 5.ExcelTips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email toexcel-mac...@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ I want to apply formula in excel sheet can you implementation this formula.
I want to apply formula in excel sheet can you implementation this formula. Fibrotest = 4.467 × log [α2-macroglobulin] −1.357 × log [haptoglobin] + 1.017 × log [GGT] + 0.0281 × [age] + 1.737 × log [bilirubin] − 1.184 × [apolipoprotein A1] + 0.301 × Sex (female=0, male=1− 5.540. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Macro with condition
It´s excellent, this will do fine! thank you very much Manoj :) 2011/1/5 Manoj kumar manoj.vishwakarma...@gmail.com Hi, Though not a macro... but still works the same...pls chk the attached Regards, Manoj Kumar On Wed, Jan 5, 2011 at 3:52 PM, Jorge Marques leote.w...@gmail.comwrote: Hi guys, i´m need your help, i have a list of brands, that i need to put values of sales of the various shops , from cell B2:B15, and i need that when i select a brand from cell B1 it will copy automatically the value from cell B16 to the cells from D2 to K2, example, if i select Adidas it will copy the value of B16 to the cell E2 i annexed a excel example Thank you very much in advance :) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Heartly Congratulations
Hi Dilip Sir, Congratulations By Narasimharao ML 09010509753 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Emergency: Vba Code requested for PDF file has to be converted as Word Document.
Hi Friends, As a part of my official activities, I will get incoming document as an Ordinary PDF format. I have to covert this to a word document before I processing it. Now I am Doing the below steps for convertion for each files. 1. Open the PDF File. 2. Select all content using Cntrl+A 3. Copy the content Using Cntrl+C 4. Paste the content in a blank word document. 5. Save the document as rtf format. Now I am expecting to do this in a macro or other systematic way. It would be more helpful if anyone give me a solution for this activities. This will bring my work stress a lot. Reason for looking VBA Code or Macro: 1. I dont have Fine Reader package in my office. 2. I dont have privilage to download any Free PDF to word converter from google search. 3. I will get 30 to 100+ Documents in a day. I am expecting emergency solution for the above. Thanks in Advance. By, R. K. Maariappan marimac...@gmail.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Understand macro code in timesheet
Problem - I have one spreadsheet which is used to record our time sheet in office. Sheet 1 is named Macro1 and has following code/lines in the cells starting from A1 till A18: Next Fortnight =ECHO(FALSE) =SELECT(R56C13) =COPY() =SELECT(R9C15) =PASTE.SPECIAL(3,1,FALSE,FALSE) =SELECT(R10C4:R49C5) =CLEAR(3) =SELECT(R12c10:R13c10,R16c10:R17c10,R20c10:R21c10,R24c10:R25c10,R24c10) =CLEAR(3) =SELECT(R28c10,R28c10:R29c10,R32c10:R33c10,R36c10:R37c10,R40c10:R41c10,R44c10:R45c10,R48c10:R49c10,R48c10) =CLEAR(3) I=FLEXY!$B$12 I=I+14 =SELECT(R10C4) =FORMULA(I,FLEXY!$B$12) =CALCULATE.NOW() =RETURN() In second sheet named 'TimeSheet' we have to enter time in and time out and it calculates total time and credit. There are 2 buttons on the sheet - 'Next fortnight' and 'Re- Calculate'. No code in visual basic window at all. When I right click 'Next fortnight' and select 'Assign macro' - It goes to second line of the code - =ECHO(FALSE) When I right click Re-Calculate' and select 'Assign macro' - It goes to second line of the code - =CALCULATE.NOW() I want to make few changes like copy fortnight data to new blank sheet and few other minor bits, but completly clueless how to make any change. Can you please guide me how can I make any changes in the spreadsheet? Is the macros locked? Thanks in advance -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes
Hi, I have a list of numbers and I need to find the highest of the most frequent occurrances. For example: List 1 1 3 3 4 4 Should return the value 4 because its the highest of the most frequent occurrances of any number. List 2 1 3 3 3 4 4 Should return 3 because it's the most frequent occurrance outright. I've tried using the mode command but it returns the first of the most frequent occurances but I want the highest of the most frequent occurrances. Any help would be greatly appreciated. Thanks Kim -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Copy files in folder except one file
Hi, I need to combine several excel files into one file. I create this new file in the directory that user chooses (this folder contains the files I want to copy). It loops trough the files and works perfectly except that it copies the combined Manual Timesheets.xls file and pastes it to itself (so the info is duplicated!) I get the folder from user in a function I found from net. how can I exclude this combined file from being copied? Thanks for your help in advance. Here is part of my code: Fpath = BrowseFolder(Caption:=Select the folder .) excelFile = Dir(Fpath \*.xls) ' I create the Combined Manual Timesheets.xls here Do While excelFile ' Do While excelFile Combined Manual Timesheets.xls or :This line did not work 'This IF does not work for some reason: If excelFile = Combined Manual Timesheets.xls Then Exit Do End If Workbooks.Open Filename:=Fpath \ excelFile ' copy rows ActiveWorkbook.Sheets(1).Activate LastRow = ActiveWorkbook.Sheets(1).Cells(Rows.Count, 1).End(xlUp).Row ActiveSheet.Rows(8: LastRow).EntireRow.Select Selection.Copy With Workbooks(Combined Manual Timesheets.xls) .Sheets(1).Activate LastRow = .Sheets(1).Cells(Rows.Count, B).End(xlUp).Row End With With Workbooks(Combined Manual Timesheets.xls).Sheets(1).Range(A (LastRow + 1)) ' Paste:=8 will copy the columnwidth in Excel 2000 and higher .PasteSpecial Paste:=8 .PasteSpecial xlPasteValues End With Application.CutCopyMode = False ActiveWorkbook.Save Workbooks(excelFile).Close excelFile = Dir Loop Thanks, Nasim -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes
check the attachment see if it helps On Thu, Jan 6, 2011 at 6:17 AM, Kim anast...@gmail.com wrote: Hi, I have a list of numbers and I need to find the highest of the most frequent occurrances. For example: List 1 1 3 3 4 4 Should return the value 4 because its the highest of the most frequent occurrances of any number. List 2 1 3 3 3 4 4 Should return 3 because it's the most frequent occurrance outright. I've tried using the mode command but it returns the first of the most frequent occurances but I want the highest of the most frequent occurrances. Any help would be greatly appreciated. Thanks Kim -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts sample datat.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes
Hi Ashish,
can you pls explain this.
{=OFFSET(E1,MAX(IF(F2:F9=MAX(F2:F9),ROW(F2:F9),))-1,0)}
Also,why have u used {}. when to use them. if do F2 i get Value error. why is
it
so.
so many que :( can you please explain.
From: ashish koul koul.ash...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thu, 6 January, 2011 10:37:35 AM
Subject: Re: $$Excel-Macros$$ How do I find the highest of the most repeating
values in a list of numbers ie. the max of the modes
check the attachment see if it helps
On Thu, Jan 6, 2011 at 6:17 AM, Kim anast...@gmail.com wrote:
Hi,
I have a list of numbers and I need to find the highest of the most
frequent occurrances.
For example:
List 1
1
3
3
4
4
Should return the value 4 because its the highest of the most
frequent
occurrances of any number.
List 2
1
3
3
3
4
4
Should return 3 because it's the most frequent occurrance outright.
I've tried using the mode command but it returns the first of the
most
frequent occurances but I want the highest of the most frequent
occurrances.
Any help would be greatly appreciated.
Thanks
Kim
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
--
Regards
Ashish Koul
akoul.blogspot.com
akoul.wordpress.com
My Linkedin Profile
PBefore printing, think about the environment.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Emergency: Vba Code requested for PDF file has to be converted as Word Document.
try this macro first get all the pdf names with complete path by clicking on file name and selecting the folders having pdfs then click on make documents remebr u need to chang i =1 to last no and C:\Program Files\Adobe\Reader 9.0\Reader\AcroRd32.exe path in the code On Thu, Jan 6, 2011 at 12:48 AM, Mariappan Kulasekaran marimac...@gmail.com wrote: Hi Friends, As a part of my official activities, I will get incoming document as an Ordinary PDF format. I have to covert this to a word document before I processing it. Now I am Doing the below steps for convertion for each files. 1. Open the PDF File. 2. Select all content using Cntrl+A 3. Copy the content Using Cntrl+C 4. Paste the content in a blank word document. 5. Save the document as rtf format. Now I am expecting to do this in a macro or other systematic way. It would be more helpful if anyone give me a solution for this activities. This will bring my work stress a lot. Reason for looking VBA Code or Macro: 1. I dont have Fine Reader package in my office. 2. I dont have privilage to download any Free PDF to word converter from google search. 3. I will get 30 to 100+ Documents in a day. I am expecting emergency solution for the above. Thanks in Advance. By, R. K. Maariappan marimac...@gmail.com -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts copy_from_pdf_to_word.xlsm Description: Binary data
$$Excel-Macros$$ Excel Puzzle of the week
Dear members, There is a excel puzzle for you. Let see who all can give the answer correctly. There is a data of [month] in excel with no fixed length , minimum three characters, text format. You need to develop formula (Not Macro) which can convert it into number. For example Jan to 1 March to 3 Apr to 4. Decem to 5. so on. The best formula(short relevant) winner name will be published on exceldailytip.blogspot.com blog of this group. Let see who is the first and who is the winner. Thank you. Best Regards, Ayush Jain Group Manager Microsoft MVP -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Excel Puzzle of the week
there was Typo in example...its Decem to 12 Submit your answer now. :D Thnx again. On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote: Dear members, There is a excel puzzle for you. Let see who all can give the answer correctly. There is a data of [month] in excel with no fixed length , minimum three characters, text format. You need to develop formula (Not Macro) which can convert it into number. For example Jan to 1 March to 3 Apr to 4. Decem to 5. so on. The best formula(short relevant) winner name will be published on exceldailytip.blogspot.com blog of this group. Let see who is the first and who is the winner. Thank you. Best Regards, Ayush Jain Group Manager Microsoft MVP -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Best regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Excel Puzzle of the week
check the attachment MONTH(VALUE(LEFT(A1,3)1)) On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote: Dear members, There is a excel puzzle for you. Let see who all can give the answer correctly. There is a data of [month] in excel with no fixed length , minimum three characters, text format. You need to develop formula (Not Macro) which can convert it into number. For example Jan to 1 March to 3 Apr to 4. Decem to 5. so on. The best formula(short relevant) winner name will be published on exceldailytip.blogspot.com blog of this group. Let see who is the first and who is the winner. Thank you. Best Regards, Ayush Jain Group Manager Microsoft MVP -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts puzzle.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Excel Puzzle of the week
Wow AshishSuperfast...I liked it.. Dear group, Do you have better answer to beat ashish :P On Thu, Jan 6, 2011 at 11:57 AM, ashish koul koul.ash...@gmail.com wrote: check the attachment MONTH(VALUE(LEFT(A1,3)1)) On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote: Dear members, There is a excel puzzle for you. Let see who all can give the answer correctly. There is a data of [month] in excel with no fixed length , minimum three characters, text format. You need to develop formula (Not Macro) which can convert it into number. For example Jan to 1 March to 3 Apr to 4. Decem to 5. so on. The best formula(short relevant) winner name will be published on exceldailytip.blogspot.com blog of this group. Let see who is the first and who is the winner. Thank you. Best Regards, Ayush Jain Group Manager Microsoft MVP -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Best regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Copy files in folder except one file
try this it may help Fpath = BrowseFolder(Caption:=Select the folder .) excelFile = Dir(Fpath \*.xls) Do While excelFile If excelFile Combined Manual Timesheets.xls Then Workbooks.Open Filename:=Fpath \ excelFile ' copy rows ActiveWorkbook.Sheets(1).Activate LastRow = ActiveWorkbook.Sheets(1).Cells(Rows.Count, 1).End(xlUp).Row ActiveSheet.Rows(8: LastRow).EntireRow.Select Selection.Copy With Workbooks(Combined Manual Timesheets.xls) .Sheets(1).Activate LastRow = .Sheets(1).Cells(Rows.Count, B).End(xlUp).Row End With With Workbooks(Combined Manual Timesheets.xls).Sheets(1).Range(A (LastRow + 1)) ' Paste:=8 will copy the columnwidth in Excel 2000 and higher .PasteSpecial Paste:=8 .PasteSpecial xlPasteValues End With Application.CutCopyMode = False ActiveWorkbook.Save Workbooks(excelFile).Close End If Loop On Thu, Jan 6, 2011 at 10:11 AM, Nasim nbeiz...@gmail.com wrote: Hi, I need to combine several excel files into one file. I create this new file in the directory that user chooses (this folder contains the files I want to copy). It loops trough the files and works perfectly except that it copies the combined Manual Timesheets.xls file and pastes it to itself (so the info is duplicated!) I get the folder from user in a function I found from net. how can I exclude this combined file from being copied? Thanks for your help in advance. Here is part of my code: Fpath = BrowseFolder(Caption:=Select the folder .) excelFile = Dir(Fpath \*.xls) ' I create the Combined Manual Timesheets.xls here Do While excelFile ' Do While excelFile Combined Manual Timesheets.xls or :This line did not work 'This IF does not work for some reason: If excelFile = Combined Manual Timesheets.xls Then Exit Do End If Workbooks.Open Filename:=Fpath \ excelFile ' copy rows ActiveWorkbook.Sheets(1).Activate LastRow = ActiveWorkbook.Sheets(1).Cells(Rows.Count, 1).End(xlUp).Row ActiveSheet.Rows(8: LastRow).EntireRow.Select Selection.Copy With Workbooks(Combined Manual Timesheets.xls) .Sheets(1).Activate LastRow = .Sheets(1).Cells(Rows.Count, B).End(xlUp).Row End With With Workbooks(Combined Manual Timesheets.xls).Sheets(1).Range(A (LastRow + 1)) ' Paste:=8 will copy the columnwidth in Excel 2000 and higher .PasteSpecial Paste:=8 .PasteSpecial xlPasteValues End With Application.CutCopyMode = False ActiveWorkbook.Save Workbooks(excelFile).Close excelFile = Dir Loop Thanks, Nasim -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Excel Puzzle of the week
how about this... =MONTH(1A1) Regards, Manoj Kumar On Thu, Jan 6, 2011 at 12:05 PM, ayush jain jainayus...@gmail.com wrote: Wow AshishSuperfast...I liked it.. Dear group, Do you have better answer to beat ashish :P On Thu, Jan 6, 2011 at 11:57 AM, ashish koul koul.ash...@gmail.comwrote: check the attachment MONTH(VALUE(LEFT(A1,3)1)) On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote: Dear members, There is a excel puzzle for you. Let see who all can give the answer correctly. There is a data of [month] in excel with no fixed length , minimum three characters, text format. You need to develop formula (Not Macro) which can convert it into number. For example Jan to 1 March to 3 Apr to 4. Decem to 5. so on. The best formula(short relevant) winner name will be published on exceldailytip.blogspot.com blog of this group. Let see who is the first and who is the winner. Thank you. Best Regards, Ayush Jain Group Manager Microsoft MVP -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Best regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes
Thanks so much Ashish but the problem is in the temporary column. I really need to do it in one cell only without introducing any new data. Any idea on how I can achieve that? Again, thanks for your help. Kim On Jan 6, 4:07 pm, ashish koul koul.ash...@gmail.com wrote: check the attachment see if it helps On Thu, Jan 6, 2011 at 6:17 AM, Kim anast...@gmail.com wrote: Hi, I have a list of numbers and I need to find the highest of the most frequent occurrances. For example: List 1 1 3 3 4 4 Should return the value 4 because its the highest of the most frequent occurrances of any number. List 2 1 3 3 3 4 4 Should return 3 because it's the most frequent occurrance outright. I've tried using the mode command but it returns the first of the most frequent occurances but I want the highest of the most frequent occurrances. Any help would be greatly appreciated. Thanks Kim -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. sample datat.xls 24KViewDownload- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
