Automatically Add Foorter with full filename in Excel

  • Thread starter Thread starter JP SIngh
  • Start date Start date
J

JP SIngh

Hi All

I am trying to add the full path name of the file as a footer to every excel
file that is created new or opened in Excel.

I am quite certain this can be done through VBA but not sure how.

Can someone please help?

Thanks
 
Hi
depending on your Excel version you could create a new
template and save this as book.xlt in your XLStart folder
 
I am using Office 2003 and placed the file called book.xlt in the XLstartup
folder but it simply opens up the book.xlt together with a new workbook.

What I really need is an automactic way of including the footer on everyfile
that is opened or created from now on

Any more suggestions
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble Installing Excel VBA Code Cleaner into Office 365 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
File Name and Full Path Name 6
Adding code right after the "Save As" dialog box 2
Problem with file path to sharepoint 0
Excel VBA in Citrix. 0
change filename 2
How to read Excel Array to vb.net Arrays? 20

Back
Top