For Excel 2007/2010 Rootdrive\Documents and Settings\User\Application Data\Microsoft\Addins.
Regards, Sam On Tue, Nov 1, 2011 at 9:31 AM, Amit Desai (MERU) <amit.de...@merucabs.com>wrote: > Dear Aamir,**** > > ** ** > > Can u tell me where will be addins folder?**** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Sam Mathai Chacko > *Sent:* 01 November 2011 12:41 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Convert amount to Million**** > > ** ** > > Aamir, > > Please find attached the add-in. Just install this to the addins folder > > Regards, > > Sam Mathai Chacko**** > > On Tue, Nov 1, 2011 at 4:45 AM, Aamir Shahzad <aamirshahza...@gmail.com> > wrote:**** > > Anand, **** > > ** ** > > This is difficult for me but only tell me how I recall this macro by means > of add in. When I am creating add in & load into the excel this macro not > converting the amount to million however in the working sheet this is > working fine. **** > > ** ** > > *Private Sub Worksheet_Change(ByVal Target As Range) > > Dim rngCell As Range > > For Each rngCell In Target > If Right(UCase(Trim(rngCell.Text)), 1) = "M" Then > rngCell.Value = Replace(UCase(Trim(rngCell.Text)), "M", "") * 10 ^ 6 > End If > Next > > End Sub***** > > ** ** > > Aamir Shahzad**** > > ** ** > > On Mon, Oct 31, 2011 at 10:18 AM, anandydr <anand...@gmail.com> wrote:**** > > 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 Shahzad <aamirshahza...@gmail.com> wrote: > > 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 <aamirshahza...@gmail.com > >wrote:**** > > > > > > > > > > > > > > > > > > Yes SAM I want to enable this macro for all excel sheets in shape of > add > > > in. Well .xlam is attached where I am created new 2nd module however > your > > > "Convert to Million" Macro is running fine in sheet but when I enter > this > > > macro into add in file this won't work. > > > > > Aamir Shahzad > >**** > > > > On Sat, Oct 29, 2011 at 3:00 AM, Sam Mathai Chacko <samde...@gmail.com > >wrote:**** > > > > > >> Why do you want this in another add-in? Do you want the feature to be > > >> available in ALL the workbooks that you use? > > > > >> Also Aamir, a normal add-in does not have the require events to > capture a > > >> change in the sheets in another workbook. To get it to run > automatically, > > >> you'll need to call an application level event from the add-in. > Unless you > > >> send me this add-in, I will not be able to provide a solution. > > > > >> Sam > >**** > > > >> On Sat, Oct 29, 2011 at 3:25 AM, Aamir Shahzad < > aamirshahza...@gmail.com>wrote:**** > > > > > >>> how to call? is it not run automatically when enter 1M & enter? > > > > >>> Aamir Shahzad > >**** > > > >>> On Sat, Oct 29, 2011 at 2:52 AM, Sam Mathai Chacko < > samde...@gmail.com>wrote:**** > > > > > >>>> The original code that I gave should have been written within a > > >>>> workbook. But now that you are using an add-in, yes you can use it > in a > > >>>> different module, but for it to run, you will have to CALL it when > required. > > > > >>>> Sam > > > > >>>> On Sat, Oct 29, 2011 at 3:20 AM, Aamir Shahzad <**** > > > >>>> aamirshahza...@gmail.com> wrote: > > > > >>>>> Can I create another "Module 2" in the same add in & write code > there? > > > > >>>>> Aamir Shahzad > >**** > > > >>>>> On Sat, Oct 29, 2011 at 2:43 AM, Sam Mathai Chacko < > samde...@gmail.com**** > > > >>>>> > wrote: > > > > >>>>>> Not sure what procedure you require, but if you knew the range, > this > > >>>>>> is how you'd call this > > > > >>>>>> ---- your code ------ > > >>>>>> ---- your code ------ > > >>>>>> Call ConvertToMillions(Worksheets("NameOfSheet").Range("A1")) > > >>>>>> ---- your code ------ > > > > >>>>>> Private Sub ConvertToMillions(ByRef Target As Range) > > > > >>>>>> Dim rngCell As Range > > > > >>>>>> For Each rngCell In Target > > >>>>>> If Right(UCase(Trim(rngCell.Text)), 1) = "M" Then > > >>>>>> rngCell.Value = Replace(UCase(Trim(rngCell.Text)), > "M", > > >>>>>> "") * 10 ^ 6 > > >>>>>> End If > > >>>>>> Next > > > > >>>>>> End Sub > > > > >>>>>> Sam Mathai Chacko (GL) > > > > >>>>>> On Sat, Oct 29, 2011 at 3:10 AM, Aamir Shahzad <**** > > > >>>>>> aamirshahza...@gmail.com> wrote: > > > > >>>>>>> how? procedure required. > > > > >>>>>>> On Sat, Oct 29, 2011 at 2:39 AM, Sam Mathai Chacko <**** > > > >>>>>>> samde...@gmail.com> wrote: > > > > >>>>>>>> Yes you can > > >>>>>>>> Sam > > > > >>>>>>>> On Sat, Oct 29, 2011 at 3:07 AM, Aamir Shahzad <**** > > > >>>>>>>> aamirshahza...@gmail.com> wrote: > > > > >>>>>>>>> Can I enter this code with another add in? > > > > >>>>>>>>> On Sat, Oct 29, 2011 at 2:27 AM, Sam Mathai Chacko <**** > > > >>>>>>>>> samde...@gmail.com> wrote: > > > > >>>>>>>>>> Something like this might do the trick > > > > >>>>>>>>>> Private Sub Worksheet_Change(ByVal Target As Range) > > > > >>>>>>>>>> Dim rngCell As Range > > > > >>>>>>>>>> For Each rngCell In Target > > >>>>>>>>>> If Right(UCase(Trim(rngCell.Text)), 1) = "M" Then > > >>>>>>>>>> rngCell.Value = Replace(UCase(Trim(rngCell.Text)), > > >>>>>>>>>> "M", "") * 10 ^ 6 > > >>>>>>>>>> End If > > >>>>>>>>>> Next > > > > >>>>>>>>>> End Sub > > > > >>>>>>>>>> Regards, > > > > >>>>>>>>>> Sam Mathai Chacko (GL) > > > > >>>>>>>>>> On Sat, Oct 29, 2011 at 2:52 AM, Aamir Shahzad <**** > > > >>>>>>>>>> aamirshahza...@gmail.com> wrote: > > > > >>>>>>>>>>> Dear Experts, > > > > >>>>>>>>>>> Is it possible in excel that if I write in cell "1M" & press > tab > > >>>>>>>>>>> or enter it automatically converted this figure to > 1,000,000. or 4.5M to > > >>>>>>>>>>> 4,500,000. > > > > >>>>>>>>>>> Regards, > > > > >>>>>>>>>>> Aamir Shahzad > > > > >>>>>>>>>>> -- > > >>>>>>>>>>> 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. > > > > >>>>>>>>>>> 2) Don't post a question in the thread of another member. > > > > >>>>>>>>>>> 3) Don't post questions regarding breaking or bypassing any > > >>>>>>>>>>> security measure. > > > > >>>>>>>>>>> 4) Acknowledge the responses you receive, good or bad. > > > > >>>>>>>>>>> 5) Cross-promotion of, or links to, forums competitive to > this > > >>>>>>>>>>> forum in signatures are prohibited. > > > > >>>>>>>>>>> NOTE : Don't ever post personal or confidential data in a > > >>>>>>>>>>> workbook. Forum owners and members are not responsible for > any loss. > > > > >>>>>>>>>>> > --------------------------------------------------------------------------- > --------------------------- > > >>>>>>>>>>> To post to this group, send email to > > >>>>>>>>>>> excel-macros@googlegroups.com > > > > >>>>>>>>>> -- > > >>>>>>>>>> Sam Mathai Chacko > > > > >>>>>>>>>> -- > > >>>>>>>>>> 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. > > > > >>>>>>>>>> 2) Don't post a question in the thread of another member. > > > > >>>>>>>>>> 3) Don't post questions regarding breaking or bypassing any > > >>>>>>>>>> security measure. > > > > >>>>>>>>>> 4) Acknowledge the responses you receive, good or bad. > > > > >>>>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this > > >>>>>>>>>> forum in signatures are prohibited. > > > > >>>>>>>>>> NOTE : Don't ever post personal or confidential data in a > > >>>>>>>>>> workbook. Forum owners and members are not responsible for > any loss. > > > > >>>>>>>>>> > --------------------------------------------------------------------------- > --------------------------- > > >>>>>>>>>> To post to this group, send email to > > >>>>>>>>>> excel-macros@googlegroups.com > > > > >>>>>>>>> -- > > > > >>>>>>>>> Regards, > > > > >>>>>>>>> Aamir Shahzad > > > > >>>>>>>>> -- > > >>>>>>>>> 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. > > > > >>>>>>>>> 2) Don't post a question in the thread of another member. > > > > >>>>>>>>> 3) Don't post questions regarding breaking or bypassing any > > >>>>>>>>> security measure. > > > > >>>>>>>>> 4) Acknowledge the responses you receive, good or bad. > > > > >>>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this > > >>>>>>>>> forum in signatures are prohibited. > > > > >>>>>>>>> NOTE : Don't ever post personal or confidential data in a > > >>>>>>>>> workbook. Forum owners and members are not responsible for any > loss. > > > > >>>>>>>>> > --------------------------------------------------------------------------- > --------------------------- > > >>>>>>>>> To post to this group, send email to > excel-macros@googlegroups.com > > > > >>>>>>>> -- > > >>>>>>>> Sam Mathai Chacko > > >>>>>>>> -- > > >>>>>>>> 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. > > > > >>>>>>>> 2) Don't post a question in the thread of another member. > > > > >>>>>>>> 3) Don't post questions regarding breaking or bypassing any > > >>>>>>>> security measure. > > > > >>>>>>>> 4) Acknowledge the responses you receive, good or bad. > > > > >>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this > > >>>>>>>> forum in signatures are prohibited. > > > > >>>>>>>> NOTE : Don't ever post personal or confidential data in a > workbook. > > >>>>>>>> Forum owners and members are not responsible for any loss. > > > > >>>>>>>> > --------------------------------------------------------------------------- > --------------------------- > > >>>>>>>> To post to this group, send email to > excel-macros@googlegroups.com > > > > >>>>>>> -- > > > > >>>>>>> Regards, > > > > >>>>>>> Aamir Shahzad > > > > >>>>>>> -- > > >>>>>>> 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. > > > > >>>>>>> 2) Don't post a question in the thread of another member. > > > > >>>>>>> 3) Don't post questions regarding breaking or bypassing any > security > > >>>>>>> measure. > > > > >>>>>>> 4) Acknowledge the responses you receive, good or bad. > > > > >>>>>>> 5) Cross-promotion of, or links to, forums competitive to this > forum > > >>>>>>> in signatures are prohibited. > > > > >>>>>>> NOTE : Don't ever post personal or confidential data in a > workbook. > > >>>>>>> Forum owners and members are not responsible for any loss. > > > > >>>>>>> > --------------------------------------------------------------------------- > --------------------------- > > >>>>>>> To post to this group, send > >**** > > > ... > > > > read more ยป**** > > > -- > 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. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com**** > > > > > -- **** > > Regards,**** > > Aamir Shahzad**** > > ** ** > > -- > 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. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com**** > > > > > -- > Sam Mathai Chacko**** > > -- > 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. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com**** > > ------------------------------ > Disclaimer: This message and its attachments contain confidential > information and may also contain legally privileged information. This > message is intended solely for the named addressee. If you are not the > addressee indicated in this message (or authorized to receive for > addressee), you may not copy or deliver any part of this message or its > attachments to anyone or use any part of this message or its attachments. > Rather, you should permanently delete this message and its attachments (and > all copies) from your system and kindly notify the sender by reply e-mail. > Any content of this message and its attachments that does not relate to the > official business of Meru Cab Company Pvt. Ltd. must be taken not to have > been sent or endorsed by any of them. Email communications are not private > and no warranty is made that e-mail communications are timely, secure or > free from computer virus or other defect. > > -- > 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. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- Sam Mathai Chacko -- 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. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
