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