set the path automaticly on the excel file bottom

pub66,

Do you mean, automatically add the path as a footer in the page setup?  Or something else?

>>and girls if there are

We are lucky to have some very talented girls here :)

Patrick

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?

Open up a new Excel file.  Add a custom footer that has the file path in it, like you would manually.  Then save the workbook as an Excel template (.xlt or .xltx) and use this filename:  Book

Save the file to this location (Windows XP):
C:\Documents and Settings\USERNAME\Application Data\Microsoft\Excel\XLSTART\Book.xltx

Now anytime you open up a new workbook, the file path will be added in the footer.

For more on Excel templates:
http://office.microsoft.com/en-us/excel-help/customizing-excel-defaults-with-templates-HA001054815.aspx

I guess I'm a little late... :-)

Hi there,

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\Roaming\Microsoft\Excel\XLSTART

Is there anything I did wrong ??

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

I created a new file, go to insertion,  Add a custom footer and save as template with the name Book.xltx and the path is
C:\Users\USER\AppData\Roaming\Microsoft\Templates

When I open a new Excel file, I can't see any path

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

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

Have you saved it yet?

yes

How did you create the new workbook? Ctrl+n?

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

No, I mean how are you creating the new book to test if the path appears?
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.

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

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.

Screenshots:


pagesetup.jpg
printprev.jpg

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

the solution works now thanks