Object Links in Word

jalbes · #4 03-19-2014, 07:13 AM

Quote:

Originally Posted by macropod

Shaun,

What you're describing would require relative file paths, which Word's LINK field (used for linking to Excel) doesn't support. However, you can achieve such an outcome with a macro. To see how to do so, check out the macro attached to my post at:
http://windowssecrets.com/forums/sho...External-Files

Hi Paul:
Exactly! I read over the link you provided, and tried a couple of attempts, but I'm not getting the right result. For example, I currently have the following link...
( LINK Excel.Sheet.12 "\\\\MINESTEEL\\JOBS\\MFL Jobs\\6000\\6008 - NMT (PTFI 22 ea 20m3 Cars)\\Manual\\Working\\Project-Manual-Variables.xlsx" Sheet1!Product.Name \a \t )

I modified it as follows, but Word auto corrects it back the original format above.
( LINK Excel.Sheet.12 "\\\\MINESTEEL\\JOBS\\MFL Jobs\\6000\\6008 - NMT (PTFI 22 ea 20m3 Cars)\\Manual\\Working\\Project-Manual-Variables.xlsx\\..\\Project-Manual-Variables.xlsx" Sheet1!Product.Name \a \t )

I also tried this way below, which would be ideal, but it comes back with errors. Any idea's?
( LINK Excel.Sheet.12 "\\..\\Project-Manual-Variables.xlsx" Sheet1!Product.Name \a \t )

Thanks,
Shaun

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
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