Hyperlink failed

[Guest]

After inserted a Hyperlink to another excel worksheet file successfully,
error message "Cannot open the specified file" appeared while OPEN Hyperlink,
please help?

 

[Daniel CHEN]

You need to make sure that the path/file is correct.
--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
=================================

 

[David McRitchie]

If you still have a problem see some examples in
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
http://www.mvps.org/dmcritchie/excel/sheets.htm

There are object hyperlinks (Ctrl+K) which I think you are using since you
mentioned "insert" and there is the HYPERLINK Worksheet Function

If you still have a problem after checking those references, you would
have to post what you had, what it got changed to, specifically why
you know it doesn't work (the entire text of the message).

The message you refer to is at least similar to other messages such
as bad references in toolbar buttons, so also think if you moved any
files around (pathname problems like Yongiun mentionded)..

 

[Guest]

Thanks Daniel & David on the guidance.
The error is on the file name. filename Job#123 with # symbol interpreted by
Hyperlink as Job-123 which error message appeared as "Cannot open the
specified file"...cheers