software

Hey

I know you can insert the dir and name of the file as a footer in a
sheet, but can this be set as standard? so when i make a new excel file
it automatically adds the footer?

thanks

jimmyp--
jimmyp
------------------------------------------------------------------------
jimmyp's Profile: www.excelforum.com/member.php...oamp;userid=32217
View this thread: www.excelforum.com/showthread...hreadid=542056There is likely a Folder created in your Excel (Program) installation
called
quot;XLStartquot;. Find it (with your Explorer program) and see if you have a
file
Called Book.xlt.

If you do:
Open it with Excel - make any and all modifications you wish to it
(meaning
Doctor-it-up so that it appears exactly the way you want a new workbook
to
Look (including such as in the Page Setup, the Dir Name and the File
name, etc). Now Do a File-SaveAs and make sure you save it to the same
folder (XLStart) and the file extention is .xlt -- so quot;Book.xltquot;

Close Excel, and reopen -- your new quot;and improvedquot; new wb should have
the
Characteristics you want.

If you do not have:
Create a new wb (from scratch) doing the doctor-up part and just save it
The the existing XLStart folder as Book.xlt

That should do it.
HTH
Jim May
quot;jimmypquot; gt; wrote in
message :

gt; Hey
gt;
gt; I know you can insert the dir and name of the file as a footer in a
gt; sheet, but can this be set as standard? so when i make a new excel file
gt; it automatically adds the footer?
gt;
gt; thanks
gt;
gt; jimmyp
gt;
gt;
gt; --
gt; jimmyp
gt; ------------------------------------------------------------------------
gt; jimmyp's Profile: www.excelforum.com/member.php...oamp;userid=32217
gt; View this thread: www.excelforum.com/showthread...hreadid=542056
cheers JimMay that did the trick

jimmyp--
jimmyp
------------------------------------------------------------------------
jimmyp's Profile: www.excelforum.com/member.php...oamp;userid=32217
View this thread: www.excelforum.com/showthread...hreadid=542056The only downside is that it does this for ALL new workbooks, so
If you don't want it you'll have to remove it from your Page setup.
Thanks for the feedback,
Jim May

quot;jimmypquot; gt; wrote in
message :

gt; cheers JimMay that did the trick
gt;
gt; jimmyp
gt;
gt;
gt; --
gt; jimmyp
gt; ------------------------------------------------------------------------
gt; jimmyp's Profile: www.excelforum.com/member.php...oamp;userid=32217
gt; View this thread: www.excelforum.com/showthread...hreadid=542056