How can I put Range name & Full path of a file in footer?
--
Knowldege is Power
How can I put Range name & Full path of a file in footer?
--
Knowldege is Power
Hi Ajit
See
http://www.j-walk.com/ss/excel/tips/tip22.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Ajit Munj" <[email protected]> wrote in message news:[email protected]...
> How can I put Range name & Full path of a file in footer?
> --
> Knowldege is Power
Check out
http://www.mcgimpsey.com/macoffice/e...einfooter.html
In article <[email protected]>,
Ajit Munj <[email protected]> wrote:
> How can I put Range name & Full path of a file in footer?
Hi Ajit,
You also asked how to put a range name into the footer, and for that
you definitely need a macro. Though I'm not sure what you mean by
putting a range name in the footer -- will assume you mean the value
of a cell.
For the full pathname in the footer my own page is
. http://www.mvps.org/dmcritchie/excel/pathname.htm
you might add code for the value of a cell as follows
ActiveSheet.PageSetup.RightFooter = Range("A1").text
or for the value of a defined name as follows:
ActiveSheet.PageSetup.RightFooter = Range("mycell").text
for something with a format
ActiveSheet.PageSetup.RightFooter = Format(now(),"dd-mmm-yyyy")
.text is used instead of .value, since .text will include your cell formatting
You will have to run your macro before printing.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Ajit Munj" <[email protected]> wrote in message news:[email protected]...
> How can I put Range name & Full path of a file in footer?
> --
> Knowldege is Power
Thanks David,
I run the macro but it shows only the filename as C:\My Documents\NEWS.xls
but does not show Sheet Name (Sheet1, Sheet2 etc.) The range I mean is not
cell value. I have given the range A1:E5 as salary, G1:I10 as Grades etc. Now
I want the range names Salary and Grades in the footer.
I also want to convert actual fig.(A1=457899356.5664, A2=7979464889.455669
etc) in Lakhs or crores or thousands at one go as well as separately. How can
I do this? Will Excel prompt me before converting actual figures into Lakhs
/ Crores / Thousands ? Does this require a macro?
Please help.
"David McRitchie" wrote:
> Hi Ajit,
> You also asked how to put a range name into the footer, and for that
> you definitely need a macro. Though I'm not sure what you mean by
> putting a range name in the footer -- will assume you mean the value
> of a cell.
>
> For the full pathname in the footer my own page is
> . http://www.mvps.org/dmcritchie/excel/pathname.htm
>
> you might add code for the value of a cell as follows
> ActiveSheet.PageSetup.RightFooter = Range("A1").text
> or for the value of a defined name as follows:
> ActiveSheet.PageSetup.RightFooter = Range("mycell").text
> for something with a format
> ActiveSheet.PageSetup.RightFooter = Format(now(),"dd-mmm-yyyy")
>
> .text is used instead of .value, since .text will include your cell formatting
>
> You will have to run your macro before printing.
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Ajit Munj" <[email protected]> wrote in message news:[email protected]...
> > How can I put Range name & Full path of a file in footer?
> > --
> > Knowldege is Power
>
>
>
Thanks Ron
I run the macro but it shows only the filename as C:\My Documents\NEWS.xls
but does not show Sheet Name (Sheet1, Sheet2 etc.) The range I mean is not
cell value. I have given the range A1:E5 as salary, G1:I10 as Grades etc. Now
I want the range names Salary and Grades in the footer.
I also want to convert actual fig.(A1=457899356.5664, A2=7979464889.455669
etc) in Lakhs or crores or thousands at one go as well as separately. How can
I do this? Will Excel prompt me before converting actual figures into Lakhs
/ Crores / Thousands ? Does this require a macro?
Please help.
"Ron de Bruin" wrote:
> Hi Ajit
>
> See
> http://www.j-walk.com/ss/excel/tips/tip22.htm
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Ajit Munj" <[email protected]> wrote in message news:[email protected]...
> > How can I put Range name & Full path of a file in footer?
> > --
> > Knowldege is Power
>
>
>
Please stick to the question that was asked. Including another
unrelated question (lakhs) is confusing enough, but adding it after saying
you don't have the answer to the original question (the one that
matches the subject) is not helping you with any of your questions.
For the first question, I certainly have macros on the my page
that shows the pathname, filename, and sheetname, look again.
If you can't find it then show us exactly the format that you want
that information in and which footer.
Same for the range, please show the format you want the range
to show up as. You can use concatenation to show values.
For some help with Lakhs see my strings.htm and formula.htm pages.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Ajit Munj" <[email protected]> wrote in message news:[email protected]...
> Thanks David,
> I run the macro but it shows only the filename as C:\My Documents\NEWS.xls
> but does not show Sheet Name (Sheet1, Sheet2 etc.) The range I mean is not
> cell value. I have given the range A1:E5 as salary, G1:I10 as Grades etc. Now
> I want the range names Salary and Grades in the footer.
>
> I also want to convert actual fig.(A1=457899356.5664, A2=7979464889.455669
> etc) in Lakhs or crores or thousands at one go as well as separately. How can
> I do this? Will Excel prompt me before converting actual figures into Lakhs
> / Crores / Thousands ? Does this require a macro?
>
> Please help.
>
> "David McRitchie" wrote:
>
> > Hi Ajit,
> > You also asked how to put a range name into the footer, and for that
> > you definitely need a macro. Though I'm not sure what you mean by
> > putting a range name in the footer -- will assume you mean the value
> > of a cell.
> >
> > For the full pathname in the footer my own page is
> > . http://www.mvps.org/dmcritchie/excel/pathname.htm
> >
> > you might add code for the value of a cell as follows
> > ActiveSheet.PageSetup.RightFooter = Range("A1").text
> > or for the value of a defined name as follows:
> > ActiveSheet.PageSetup.RightFooter = Range("mycell").text
> > for something with a format
> > ActiveSheet.PageSetup.RightFooter = Format(now(),"dd-mmm-yyyy")
> >
> > .text is used instead of .value, since .text will include your cell formatting
> >
> > You will have to run your macro before printing.
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
> > "Ajit Munj" <[email protected]> wrote in message news:[email protected]...
> > > How can I put Range name & Full path of a file in footer?
> > > --
> > > Knowldege is Power
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks