<div>
pub66,<br />
<br />
Do you mean, automatically add the path as a footer in the page setup? &nbsp;Or something else?<br />
<br />
<i>&gt;&gt;and girls if there are</i><br />
<br />
We are lucky to have some very talented girls here :)<br />
<br />
Patrick
</div>


<div>
You can create a template workbook and save it as book.xlt (or book.xltx for later versions) in your XLSTART directory and set its footer to display the file path if that's what you mean?
</div>


<div>
Open up a new Excel file. &nbsp;Add a custom footer that has the file path in it, like you would manually. &nbsp;Then save the workbook as an Excel template (.xlt or .xltx) and use this filename: &nbsp;Book<br />
<br />
Save the file to this location (Windows XP):<br />
C:\Documents and Settings\USERNAME\Applicat<wbr />ion Data\Microsoft\Excel\XLSTA<wbr />RT\Book.xl<wbr />tx<br />
<br />
Now anytime you open up a new workbook, the file path will be added in the footer.<br />
<br />
For more on Excel templates:<br />
<a href="http://office.microsoft.com/en-us/excel-help/customizing-excel-defaults-with-templates-HA001054815.aspx" rel="ugc">http://office.microsoft.com/en-us/excel-help/customizing-excel-defaults-with-templates-HA001054815.aspx</a>
</div>


<div>
I guess I'm a little late... :-)
</div>


<div>
Hi there, <br />
<br />
Thanks for the fast answers. I have created a book.xltx file with the footer (path) but when I open a new excel file, I cannot see the path. I have Windows 7 and the path where I have copied de file is C:\Users\USERNAME\AppData\<wbr />Roaming\Mi<wbr />crosoft\Ex<wbr />cel\XLSTAR<wbr />T<br />
<br />
Is there anything I did wrong ??
</div>


<div>
How did you create the new file? Ctrl+n? Did you save it? (it has no path otherwise)
</div>


<div>
I created a new file, go to insertion, &nbsp;Add a custom footer and save as template with the name Book.xltx and the path is <br />
C:\Users\USER\AppData\Roam<wbr />ing\Micros<wbr />oft\Templa<wbr />tes<br />
<br />
When I open a new Excel file, I can't see any path
</div>


<div>
You need to put the book.xltx template in your XLSTART folder, and not in the templates folder.
</div>


<div>
I did it but still. Where you should see the path ? I can't see it if I create a new file
</div>


<div>
How did you create the new workbook? Ctrl+n?
</div>


<div>
no, I did new workbook, insert, Add a custom footer, acces path then save as 
</div>


<div>
No, I mean how are you creating the new book to test if the path appears?<br />
If you use the File-New-Blank workbook then Excel ignores your template, but if you use Ctrl+N (or the New workbook button on the QAT) then your template will be used.
</div>


<div>
I've tried and still does not work. Could you do a screenshot and send me please like that I will see better where the path should appear
</div>


<div>
When you print preview (or print) it should appear at the bottom of the page, assuming you used a footer, or top if you used a header.
</div>


<div>
Screenshots:<br />
<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2011/06_w23/465040/pagesetup.jpg" target="_blank" class="file-inline" title="page setup (79 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>pagesetup.jpg</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2011/06_w23/465041/printprev.jpg" target="_blank" class="file-inline" title="print preview (7 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>printprev.jpg</a>
</div>


printprev.jpg

pagesetup.jpg

<div>
ok it works but it's not automaticly, you have to do it to all new documents
</div>


<div>
the solution works now thanks
</div>


<div>
<div class="content wysiwyg-content">
Hi guys (and girls if there are),<br />
<br />
Is there any way to set automaticly in excel the path of the file on the bottom ? I can do it manually but if you open a new excel file, you have to do it again.<br />
<br />
Thanks and you do a good job
</div>
</div>


Hi guys (and girls if there are),

Is there any way to set automaticly in excel the path of the file on the bottom ? I can do it manually but if you open a new excel file, you have to do it again.

Thanks and you do a good job

set the path automaticly on the excel file bottom

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.