Network path in footer

[MagiCat]

I know how to get the file path in the footer by using &[Path] but I was wondering how to get the network path.

Instead of:

S:\share\pathname\

I wanted to get
\\server-1\share\pathname\

because different people's S drive would be mapped to a different server depending on where they are located.

 

[dreid1011]

See if this helps:

https://stackoverflow.com/questions...t-network-path-to-the-file-you-are-working-on

The directions for customizing the ribbon. It adds a box with the full path that you can copy/paste.

 

[MagiCat]

That's kindof a nice thing that I didn't know about in order to allow me to copy and paste a network drive name, but it doesn't get it into the footer, nor do I know how to get it into the footer from that. I have a VBA routine that I use to get the network path pretty reliably and could hard code the footer with a VBA function using the BeforePrint event but the problem with this is that I need to make it reliable for other people so that they can add it to their sheets and not everyone is familiar with VBA.

See if this helps:

https://stackoverflow.com/questions...t-network-path-to-the-file-you-are-working-on

The directions for customizing the ribbon. It adds a box with the full path that you can copy/paste.