#1
|
|||
|
|||
Macros not working when template is emailed
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? |
#2
|
|||
|
|||
Hi
First of all this should be posted in the Office section not the Excel section. Are you saving the template as a macro enabled template? Also are you saving the macro in the template rather than the normal template when you create it. Hope this helps. Tony (OTPM) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
emailed outlook calendar not working | Tankerman | Outlook | 0 | 12-08-2010 10:36 AM |
Macros not working in word 2010 | louise_chapman | Word VBA | 3 | 10-25-2010 08:34 AM |
Macro to open template not working | Brandi | Mail Merge | 2 | 06-24-2010 09:29 AM |
Discover if Macros exist in template or document | jimbassett | Excel | 2 | 02-08-2010 08:06 AM |
Word field stops working on template launch | anakeimai | Word | 0 | 09-10-2009 08:49 AM |