Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-14-2008, 06:49 AM
gak gak is offline
Novice
Word to Excel hyperlinks and spaces
 
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
  #2  
Old 09-14-2008, 08:38 AM
Matrix's Avatar
Matrix Matrix is offline Word to Excel hyperlinks and spaces Windows 10 Word to Excel hyperlinks and spaces Office 2010
Admin
 
Join Date: Jan 2005
Posts: 396
Matrix is on a distinguished road
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook hyperlinks don't work. russia5 Office 1 05-21-2009 02:20 PM
Linking from Excel to Word streng Word 4 10-28-2008 08:23 AM
HELP! Merging Excel to Word peevenjo Mail Merge 0 07-06-2007 03:24 PM
Hyperlinks dont work iturnrocks Outlook 0 11-21-2006 10:19 AM
protected form with underline fillable spaces rohitsahib Word 0 02-02-2006 10:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft