Hyperlink failed
 

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

Hyperlink failed
 

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
=================================
"WilMong" wrote in message
...
After inserted a Hyperlink to another excel worksheet file successfully,
error message "Cannot open the specified file" appeared while OPEN
Hyperlink,
please help?

Hyperlink failed
 

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)..

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Daniel CHEN" wrote in message ...
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
=================================
"WilMong" wrote in message
...
After inserted a Hyperlink to another excel worksheet file successfully,
error message "Cannot open the specified file" appeared while OPEN
Hyperlink,
please help?

Hyperlink failed
 

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

"David McRitchie" wrote:

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)..

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Daniel CHEN" wrote in message ...
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
=================================
"WilMong" wrote in message
...
After inserted a Hyperlink to another excel worksheet file successfully,
error message "Cannot open the specified file" appeared while OPEN
Hyperlink,
please help?