| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footer Program
Hi So I am int he middle of writing a program in VBA Macro that would loo through all the Excel files in a directory and change the footer HOwever the code that I have now .LeftFooter = "&[Date]" .CenterFooter = "&[Path]&[File]" .RightFooter = "&[Page]of &[Pages]" VB i percieving this code (the code that appears in the Vie Header/Footer Window) As a string.. so its putting the word date on th left hand of the footer. Any Suggestions -- bs27 ----------------------------------------------------------------------- bs272's Profile: http://www.excelforum.com/member.php...fo&userid=3681 View this thread: http://www.excelforum.com/showthread.php?threadid=56614 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel footer to look like Word footer? | Excel Discussion (Misc queries) | |||
| Footer Program | Excel Programming | |||
| Footer Program | Excel Programming | |||
| Landscape Orientation when Footer set using mso-footer-data Disappear | Excel Programming | |||
| merging excel program with tdc finance program | Excel Programming | |||
![bs272[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
