Macros not working when template is emailed

[EMH]

Hi there,

I am creating a macro enabled template in Word 2010 for someone. I have some really basic macros e.g. inserting an autotext (as the end user is more familiar with macros than autotexts). When I look at the code, it references where the template is saved i.e. my C drive. If I email this template it still points to this location, and therefore won't run (run time error 5941 - the requested member of the collection does not exist). Do I just take out everything except the template name or do I need to add something else? Is there a way to update macros to reflect being saved to a different location - it seems crazy that they're not just simply attached to a file no matter where it is?

Thanks in advance!

Application.Templates( _
         "C:\Documents and Settings\Final\Note_Template Final.dotm" _
        ).BuildingBlockEntries("Chart Narrow").Insert Where:=Selection.Range, _
        RichText:=True

 

[Datsmart]

Duplicate Post as this one:
http://www.mrexcel.com/forum/showthread.php?p=2777136#post2777136

Please take a moment to read over the forum's guidelines:
http://www.mrexcel.com/forum/showthread.php?t=127080
Specifically rule #21.
You want to keep all information in one location and simplify both your understanding and those that are trying to help you.

 

[TiaXL]

Dude, no need for double post plus this is excel forum not word

 

[Ruddles]

ThisDocument.FullName tells you what your document is called and where it was loaded from.

 

[RoryA]

I'm locking this so please post any answers in the other thread.