File location

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony - 07 May 2006 01:10 GMT

How to I determine the name of the file path to the file with the macro
that's running ? Word 97.

Thanks, for any help,

Tony

Reply to this Message

Shauna Kelly - 07 May 2006 03:19 GMT

Hi Tony

ThisDocument.Path will return the path to the document (or template or
add-in) that holds the code that's running.

That works in Word 2000 and above. I don't have a copy of Word 97 here to
check, but I think it worked then too.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word

> How to I determine the name of the file path to the file with the macro
> that's running ? Word 97.
>
> Thanks, for any help,
>
> Tony

Reply to this Message

Jonathan West - 07 May 2006 11:57 GMT

> Hi Tony
>
[quoted text clipped - 3 lines]
> That works in Word 2000 and above. I don't have a copy of Word 97 here to
> check, but I think it worked then too.

Application.MacroContainer.Path also works.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Reply to this Message