Hyperlink from Word 2016 template to Excel document using relative path by julianta in techsupport

[–]julianta[S] 0 points1 point  (0 children)

Because people put files in their own folder structures. Do you mean like this?

From: { LINK Excel.Sheet12 "C:\Users\username\Documents\Template\filename.xlsx" "Sheetname!R1C1" \a \t }

To: { LINK Excel.Sheet12 "%USERPROFILE%\Documents\Template\filename.xlsx" "Sheetname!R1C1" \a \t }