Original pathname from &path

Excel 2003 has a feature that one can put in the header and footer not only
the file name, but also the path "&path"

I am trying to search to see if there is a way to show what was stored in
the original path of the excel document, or maybe be able to turn this
feature off.
Without editing the document, is there a way?

Tyler Robbins:

try,

MsgBox ThisWorkbook.Path
MsgBox ThisWorkbook.FullName


--
天行健，君å*ä»¥è‡ªå¼·ä¸æ¯
地勢坤，君å*ä»¥åŽšå¾·è¼‰ç‰©

http://www.vba.com.tw/plog/


"Tyler Robbins" wrote:

> Excel 2003 has a feature that one can put in the header and footer not only
> the file name, but also the path "&path"
>
> I am trying to search to see if there is a way to show what was stored in
> the original path of the excel document, or maybe be able to turn this
> feature off.
> Without editing the document, is there a way?
>

What do you mean by the original path, and by turning off?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tyler Robbins" <TylerRobbins@discussions.microsoft.com> wrote in message
news:E42B206E-0B51-4A7D-A3AA-2DB4152C6126@microsoft.com...
> Excel 2003 has a feature that one can put in the header and footer not
only
> the file name, but also the path "&path"
>
> I am trying to search to see if there is a way to show what was stored in
> the original path of the excel document, or maybe be able to turn this
> feature off.
> Without editing the document, is there a way?
>

To the best of my knowledge, this is a code that is interpreted when you
print and the current path inserted. So I don't see how you could retrieve
any previous setting. That said, if you wanted to get a hex editor and
examine the binary content of the file, the original path may be stored in
there somewhere.

--
Regards,
Tom Ogilvy


"Tyler Robbins" <TylerRobbins@discussions.microsoft.com> wrote in message
news:E42B206E-0B51-4A7D-A3AA-2DB4152C6126@microsoft.com...
> Excel 2003 has a feature that one can put in the header and footer not
only
> the file name, but also the path "&path"
>
> I am trying to search to see if there is a way to show what was stored in
> the original path of the excel document, or maybe be able to turn this
> feature off.
> Without editing the document, is there a way?
>