Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Simple Question


In Excel go to View - Header and Footer - Custom Footer and enter:
&[Path]&[File]


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 51
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple question hacdunqh New Users to Excel 2 February 23rd 08 01:08 AM
IF formula-simple question; simple operator Rich D Excel Discussion (Misc queries) 4 December 6th 07 04:36 PM
Maybe this is a simple question www Excel Worksheet Functions 8 February 6th 07 04:34 PM
Simple question MasterMind Charts and Charting in Excel 1 October 1st 05 02:45 PM
Simple Simple Excel usage question BookerW Excel Discussion (Misc queries) 1 June 23rd 05 10:06 PM


All times are GMT +1. The time now is 07:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"