Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-28-2014, 03:22 PM
JohnN JohnN is offline Can I program like a macro to add the filepath to the bottom of the final page? Windows 7 64bit Can I program like a macro to add the filepath to the bottom of the final page? Office 2010 64bit
Novice
Can I program like a macro to add the filepath to the bottom of the final page?
 
Join Date: Feb 2014
Posts: 1
JohnN is on a distinguished road
Default Can I program like a macro to add the filepath to the bottom of the final page?

I was hoping that there was a way to possibly program a macro to hit a special ctrl+"letter" to insert the file path to the last page of a document. The closest I've come is adding a footnote but that adds it to every page and not what I am looking for.

I'm also not a programmer so I really don't understand the complex language thats involved with programming it on my own

Last edited by Charles Kenyon; 03-07-2014 at 07:18 PM. Reason: Mark as solved
Reply With Quote
  #2  
Old 02-28-2014, 08:13 PM
Charles Kenyon Charles Kenyon is offline Can I program like a macro to add the filepath to the bottom of the final page? Windows 7 64bit Can I program like a macro to add the filepath to the bottom of the final page? Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

This would be a calculated page field.

First, these fields must be constructed by hand, you can't just insert them. Second, the braces { } or field delimiters must be entered in pairs using Ctrl+F9. This is something that can be done. It is straightforward, but there are a lot of steps in the setup.

The basic fields are { PAGE } and { NUMPAGES }. I will first show you the field you need. Then I will take you step-by-step on how to construct the field. Finally, I will take you through the steps to put it in your footer. Then I will show you how to save it as a building block AutoText. Finally, if you want, I will show you how to make it a Footer Building Block.

I will post this in pieces.

Start, in your document, by typing PAGE or page or Page. Select the word you typed and press Ctrl+F9. Then press F9.

While I'm typing, you might want to look at How to control the page numbering in a Word document.
Reply With Quote
  #3  
Old 02-28-2014, 08:36 PM
Charles Kenyon Charles Kenyon is offline Can I program like a macro to add the filepath to the bottom of the final page? Windows 7 64bit Can I program like a macro to add the filepath to the bottom of the final page? Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

The field that will print a page number only on the last page is:
{IF { PAGE } = { NUMPAGES } "{ PAGE }" }


This will only work if page numbering has not been restarted.

If you are restarting page numbering at the beginning of a section, then try the { SECTIONPAGES } field instead of { NUMPAGES }.


To create this field, on the last page of your document, type the field without the field codes (or copy from below and paste):
IF PAGE < NUMPAGES "PAGE"
Then select each PAGE and Press Ctrl+F9, then F9 for each.


If you are on page 25 it should then look like this:


IF 25 = NUMPAGES "25"


Then do the same thing for NUMPAGES (or SECTIONPAGES). It should look like this:

IF 25 = 25 "25"


Then select the entire field (IF 25 = NUMPAGES "25") and Press Ctrl+F9, then F9


You should see 25.

If you copy and paste this field to any page other than the last page, nothing will show.

Copy the field.

Insert > Footer > Edit Footer.

Paste the field where you want it in the footer. If you have more than one footer, copy it to all of them. (Each section has three footers, even though you may not see them all.
Reply With Quote
  #4  
Old 02-28-2014, 08:37 PM
Charles Kenyon Charles Kenyon is offline Can I program like a macro to add the filepath to the bottom of the final page? Windows 7 64bit Can I program like a macro to add the filepath to the bottom of the final page? Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

If this field in the footer does what you want, let me know and I'll take you through the steps of saving building blocks so you can easily reproduce it in the future.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I program like a macro to add the filepath to the bottom of the final page? How to enter different texts on the bottom of the page? Pws Word 5 02-24-2014 11:54 PM
Can I program like a macro to add the filepath to the bottom of the final page? Aligning table with bottom of page Smallweed Word Tables 3 09-17-2013 08:24 AM
Can I program like a macro to add the filepath to the bottom of the final page? final page paragraph spacing pieter_bruegel Word 3 04-24-2012 03:48 AM
Can I program like a macro to add the filepath to the bottom of the final page? Can't Delete bottom page bad_dog81 Word 1 07-08-2011 02:54 AM
Can I program like a macro to add the filepath to the bottom of the final page? Page numbers top and bottom Perseid Word 3 06-16-2011 07:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft