Hi, You should indicate the file name before the function : Eg. Personal.xlsb! SpellNumber...
Regards. Daniel -----Message d'origine----- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de aju chacko Envoyé : jeudi 28 juillet 2011 06:10 À : excel-macros@googlegroups.com Objet : Fwd: $$Excel-Macros$$ Help needed to comine VBA modules ---------- Forwarded message ---------- From: aju chacko <ajuvcha...@gmail.com> Date: Wed, 27 Jul 2011 11:37:44 +0100 Subject: $$Excel-Macros$$ Help to create project from the Vba modules To: excel macro forum <excel-macros@googlegroups.com> Hi Friends, Please see the attched macro work book 'Sample file with macro.xlsx" when this is macro executed from the attached file it is running without any problem.But the same module when copied into PERSONAL MACRO WOKBOOK, the line calling function 'SPELLNUMBER' is throwing '#NAME' error .Program line is (Line.no-202) (ActiveCell.FormulaR1C1 = "=SpellNumber(round(GETPIVOTDATA(""VALUE"",R1C1,""Category"",RC[-2]),0))").I t apperas that it is not recogonizing the function 'SPELLNUMBER' included in the same module when copied into personal macro book,Also i wanted to drill down the pivotable(in w.sheet ANALYSIS) in such way that the "Name of new worksheet" being created during drill down being taken form the row label (Final b,Apex..etc) of pivot table on which I clicked.Since I am novice to excel vba,i am not competent enough to solve this issue.please see the attachement & Kindly help. With regards aju v chacko ajuvcha...@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/discussexcel -- ---------------------------------------------------------------------------- ------ 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/discussexcel -- ---------------------------------------------------------------------------------- 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/discussexcel
