Automatic Insertion of File Path

  • Thread starter Thread starter Paige L
  • Start date Start date
P

Paige L

How can I set up our employees computers so everytime they
open Excel it Auto Inserts the File Path - I know how to
do it manually, I just don't know how to set it up to Auto
do it, along the same lines as Auto Save... THANKS!
 
Paige

Insert it where? Caption? Header? Footer? Cell?

I would suggest you put an Auto-Open macro in a Workbook and save it as an
Add-in you can distribute to all users. They will then load it through
Tools>Add-ins and leave it checked at all times.

Pick what you want from the code below. Delete the lines you don't want or
preface them with a single quote(').

Sub Auto_Open()

ActiveWindow.Caption = ActiveWorkbook.FullName
ActiveSheet.PageSetup.RightHeader = ActiveWorkbook.FullName
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName
Worksheets("Sheet1").Range("A1").Value = ActiveWorkbook.FullName

End Sub

Gord Dibben XL2002
 
Back
Top