Word to Excel hyperlinks and spaces
I want to create a Word hyperlink to an Excel spreadsheet where the spreadsheet name has a space in it.
The sheet name is "Table 58" so the hyperlink is:
"C:\MyFolder\MyFile\#Table 58!A1"
Word does not like this and gives an error.
It will accept:
"C:\MyFolder\MyFile\#Table58!A1"
But for aesthetics I want to use:
"C:\MyFolder\MyFile\#Table 58!A1"
Is there any way to get it to accept the space?
Thanks for the help in advance.
I very much appreciate it.
Graham
|