View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default file path changes when emailed

Type in what you want.

You don't want to use something that points to the current location.

jane wrote:

For the footers on my excel documents, I am requried to include the complete
file path.

When I email the docs to another user, the file path changes. This creates
a problem when I email the docs to the copy center to have them printed. The
temp file location appears and not the original location that our users need
to see at the bottom of the docs.

How can I lock the file location so it doesn't change when emailed?

thanks in advance, jane


--

Dave Peterson