Macro associated with template

[EMH]

Hi there,

Sorry if this is another really basic question, but I really appreciated the help I got last time and just need to know: 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?

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

 

[Ruddles]

If there's the slightest possibility your Word document, Excel workbook or Access database might move its location, it's considered good practice to make any code independent of location, i.e. don't hard code folder paths unless there's a good reason for doing so.

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

There are also methods for fetching the true paths of system folders like My Documents, the user's TEMP directory, his Desktop, etc, if this is necessary.
<!-- / message --><!-- sig -->

 

[EMH]

Thanks for this - it gives me the lead I need. I am logging off now as it's 1am - if I need further help I'll come back tomorrow!