Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In addition to the buttons on the Header/Footer toolbar (such as &[File]), is
it possible to add other fields: the equivalent of Word field codes really? I'd like to include specifically "Last Saved By" and "Last Saved Date", but pointers to otherf fields would, of course, be really helpful. Thanks in advance Amanda |
#2
![]() |
|||
|
|||
![]()
Click on -
<Format<Cells<Custom In 'Type' enter - "Last saved Date_"dd/mm/yyyy In the actual cell enter =today() Regards. Bill Ridgeway Computer Solutions "Birmangirl" wrote in message ... In addition to the buttons on the Header/Footer toolbar (such as &[File]), is it possible to add other fields: the equivalent of Word field codes really? I'd like to include specifically "Last Saved By" and "Last Saved Date", but pointers to otherf fields would, of course, be really helpful. Thanks in advance Amanda |
#3
![]() |
|||
|
|||
![]()
Thanks for the prompt response Bill. I believe that this solution will only
work in a cell, NOT in a header/footer, which is what I need to do. For the date, I think I would type "Last Saved On " followed by clicking the Date button on the header/footer toolbar, which I believe defaults to the date last saved. For the user, I may have to write a macro that copies & pastes the Author data from the Properties dialog box into a custom header/footer... Unless someone else can think of a simpler solution? TIA Amanda "Bill Ridgeway" wrote: Click on - <Format<Cells<Custom In 'Type' enter - "Last saved Date_"dd/mm/yyyy In the actual cell enter =today() Regards. Bill Ridgeway Computer Solutions "Birmangirl" wrote in message ... In addition to the buttons on the Header/Footer toolbar (such as &[File]), is it possible to add other fields: the equivalent of Word field codes really? I'd like to include specifically "Last Saved By" and "Last Saved Date", but pointers to otherf fields would, of course, be really helpful. Thanks in advance Amanda |
#4
![]() |
|||
|
|||
![]()
Ah, yes. I overlooked that point!
Regards. Bill Ridgeway Computer Solutions "Birmangirl" wrote in message ... Thanks for the prompt response Bill. I believe that this solution will only work in a cell, NOT in a header/footer, which is what I need to do. For the date, I think I would type "Last Saved On " followed by clicking the Date button on the header/footer toolbar, which I believe defaults to the date last saved. For the user, I may have to write a macro that copies & pastes the Author data from the Properties dialog box into a custom header/footer... Unless someone else can think of a simpler solution? TIA Amanda "Bill Ridgeway" wrote: Click on - <Format<Cells<Custom In 'Type' enter - "Last saved Date_"dd/mm/yyyy In the actual cell enter =today() Regards. Bill Ridgeway Computer Solutions "Birmangirl" wrote in message ... In addition to the buttons on the Header/Footer toolbar (such as &[File]), is it possible to add other fields: the equivalent of Word field codes really? I'd like to include specifically "Last Saved By" and "Last Saved Date", but pointers to otherf fields would, of course, be really helpful. Thanks in advance Amanda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I take some of my Excel fields and make address labels? | Excel Discussion (Misc queries) | |||
Access -> Excel: How to export fields > 255 characters | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Use Excel fields in Word document | Excel Discussion (Misc queries) |