Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Question
In Excel go to View - Header and Footer - Custom Footer and enter: &[Path]&[File] |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Question
If using XL2002, there are icons in Headers/Footers Custom section for Path
and Filename. If you are using an earlier version you have to use a macro to do this. Sub PathInFooter() ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName End Sub The same code could be placed into a Workbook_BeforePrint routine. If unfamiliar with macros visit David McRitchie's website for basics. http://www.mvps.org/dmcritchie/excel/getstarted.htm Gord Dibben Excel MVP - XL97 SR2 & XL2002 On Thu, 10 Jul 2003 00:34:35 +0000 (UTC), "JS" wrote: In Excel go to View - Header and Footer - Custom Footer and enter: &[Path]&[File] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple question | New Users to Excel | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Maybe this is a simple question | Excel Worksheet Functions | |||
Simple question | Charts and Charting in Excel | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) |