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