Automatic Insertion of a File Path

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

Paige L

How can I set up our employees computers so that when they
Open Excel the File Path is Automatically included in the
worksheet and prints out? I know the manual way to do it,
but I was lead to believe there was a way to set it up to
do it AUTO? - along the same lines as Auto Save.

Thanks!
 
You can run the macro and then use that document to
replace the template. However, when we tried doing that
at our company, we could never get the normal template
replaced correctly. In theory though, that is what you
would do.
 
Paige, you can use the formula =CELL("FILENAME") but this obviously
requires that the file be saved before it can include the filepath and name
where it's saved to.

Please note that this formula includes the current sheet, filename as well
as the File path. Please let me know what information you don't want
included (eg everything but the active sheet) and I will tweak the formula
so that it reflects that.

Cheers,
Katherine
 
Back
Top