Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2014, 04:26 PM
fumei fumei is offline Object Links in Word Windows 7 64bit Object Links in Word Office XP
Expert
 
Join Date: Jan 2013
Posts: 440
fumei is on a distinguished road
Default

While having multiple templates in multiple folders is generally not a great idea, in this case you could:

have the template, when it is used to create a new file, use DocumentNew to pull in your spreadsheet from the current folder. To get the current folder (i.e. the folder the template dotm file is in) use:

AttachedTemplate.Path & "\"



therefore to point to a xls file in the same folder:
AttachedTemplate.Path & "\test.xls"
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Links need to be Hot links in Bibliography in Word 2010, 2013 synses Word 1 11-23-2013 12:48 AM
Object Links in Word Linking an Excel object into Word cncolom Word 1 03-29-2013 03:01 PM
Problem: object library invalid or contains references to object definitions aligahk06 Office 0 08-19-2010 12:29 PM
How to insert a project into Word as an object? xxsawer Project 0 04-11-2010 04:21 PM
Could not load this object as this object is not present in your computer k.gaurav Office 0 08-17-2009 09:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft