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

Try C:\MyFolder\MyFile#'Table 58'!A1.