Forum Discussion
MatthiasGehrke
Jul 03, 2020Copper Contributor
LINK in combination with REF
Hello everybody, I am retrieving some data from Excel-Sheets. For this I am using the LINK field in Word: {LINK Excel.Sheet.12 \\Path\\File.xlsx CellName /t /f 2} So far, this works perfectly. ...
- Jul 04, 2020This has been a known limitation of Word since... well, forever. Macropod (Paul Edstein) created a macro solution long ago. It was originally posted in the Windows Secrets lounge, which has now been absorbed into AskWoody.com. You can find the discussion and download the zip file from https://www.askwoody.com/forums/topic/word-fields-and-relative-paths-to-external-files/.
Jay Freedman
Jul 04, 2020Brass Contributor
This has been a known limitation of Word since... well, forever. Macropod (Paul Edstein) created a macro solution long ago. It was originally posted in the Windows Secrets lounge, which has now been absorbed into AskWoody.com. You can find the discussion and download the zip file from https://www.askwoody.com/forums/topic/word-fields-and-relative-paths-to-external-files/.
- MatthiasGehrkeJul 06, 2020Copper Contributor
Thanks for the quick answer an the link to the macro!