View Single Post
 
Old 09-14-2008, 06:49 AM
gak gak is offline
Novice
 
Join Date: Sep 2008
Posts: 1
gak is on a distinguished road
Default 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
Reply With Quote