Re: $$Excel-Macros$$ ActiveX component can't create object

Thanks Bro... It worked... :-) :-) On Fri, Oct 21, 2011 at 1:47 AM, Sam Mathai Chacko wrote: > Not tested. When you create the OutLook object, try using > CreateObject("Outlook.Application.12") for 2007, or .11 for 2003 (assuming > you have outlook in 2003) > > Regards, > Sam > > > On Thu, Oct 20

Re: $$Excel-Macros$$ Convert amount to Million

Hi Aamir, In case you want to create a button in the ribbon it is a bit difficult in Excel 2007. Somehow you can add a command button which is available in Developer tab in the ribbon and right click on the button and assign macro to it. Hope that helps, Anand Kumar On Oct 31, 1:55 am, Aamir Sha

Re: $$Excel-Macros$$ Simple Excel Calendar

Hello Siti; Simple & a nice formula. -- FORUM RULES (925+ 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.

$$Excel-Macros$$ Re: formulas to get the week in the month and week of the year

Hello Lee, See the attached. If you are using XL 2003 or prior WEEKNUM function need Analysis ToolPak Addin to be installed & activated. Other formulas will work with all versions. Hope this help you. Haseeb -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurat

$$Excel-Macros$$ formulas to get the week in the month and week of the year

hi i have a column in excel with the following date format-- ship date 20110801 20110823 20110903 I need another column adjacent to it which gives me the following results for every respective date above-- basically calcualate month and the week in that particular month in below format... Also t

Re: $$Excel-Macros$$ Convert amount to Million

Dear SAM I found my requirement in the link below http://www.contextures.com/xltoolbar02.html#AddIn I have also created & Installed 2 buttons but how create more buttons+assign macros to buttons. Regards, Aamir Shahzad On Sat, Oct 29, 2011 at 8:53 AM, Aamir Shahzad wrote: > Yes SAM I want to

Re: $$Excel-Macros$$ Simple Excel Calendar

Dear Noorain/Setiyowati, Can you brief below mentioned formulas how these are fetching data & generating calendar. Aamir Shahzad On Sun, Oct 30, 2011 at 8:14 PM, NOORAIN ANSARI wrote: > Great Setiyowati, > > Excellent Formula..Mind blowing > > > -- > Thanks & regards, > Noorain An

Re: $$Excel-Macros$$ Simple Excel Calendar

Great Setiyowati, Excellent Formula..Mind blowing -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Sun, Oct 30, 2011 at 8:25 AM, STDEV(i) w

Re: $$Excel-Macros$$ Compare the data across different sheets and put into one sheet

A better explanation Don Guillett SalesAid Software dguille...@gmail.com From: Darwin Chan Sent: Sunday, October 30, 2011 4:28 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Compare the data across different sheets and put into one sheet Hi Don, 1. How if I want to copy

Re: $$Excel-Macros$$ Compare the data across different sheets and put into one sheet

Hi Don, 1. How if I want to copy specific columns from ci file to paste on mr and cy sheet? Need to set range first? 2. What code can be added to make the location to be split into parts? just like sample shown in mr and cy sheet? 2011/10/29 dguillett1 > I did this in the ci file after addi