Thank u very much Daniel,can u help me in naming the sheets created while
pivot table being drill down
aju
On Thu, Jul 28, 2011 at 2:46 PM, Daniel <dcolarde...@free.fr> wrote:
> 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
>
--
----------------------------------------------------------------------------------
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
