set the path automaticly on the excel file bottom

pub66
pub66 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010

Commented:
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
Most Valuable Expert 2011
Top Expert 2011

Commented:
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?
TracyVBA Developer

Commented:
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
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

TracyVBA Developer

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

Author

Commented:
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 ??
Most Valuable Expert 2011
Top Expert 2011

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

Author

Commented:
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
Most Valuable Expert 2011
Top Expert 2011

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

Author

Commented:
I did it but still. Where you should see the path ? I can't see it if I create a new file
Most Valuable Expert 2011
Top Expert 2011

Commented:
Have you saved it yet?

Author

Commented:
yes
Most Valuable Expert 2011
Top Expert 2011

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

Author

Commented:
no, I did new workbook, insert, Add a custom footer, acces path then save as
Most Valuable Expert 2011
Top Expert 2011

Commented:
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.

Author

Commented:
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
Most Valuable Expert 2011
Top Expert 2011

Commented:
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.
Most Valuable Expert 2011
Top Expert 2011

Commented:

Author

Commented:
ok it works but it's not automaticly, you have to do it to all new documents
Most Valuable Expert 2011
Top Expert 2011
Commented:
Not if you set up the template correctly and in the correct location and you use ctrl+n to create the new workbooks.

Author

Commented:
the solution works now thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial