software

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

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
=================================
quot;WilMongquot; gt; wrote in message
...
gt; After inserted a Hyperlink to another excel worksheet file successfully,
gt; error message quot;Cannot open the specified filequot; appeared while OPEN
gt; Hyperlink,
gt; please help?
If you still have a problem see some examples in
www.mvps.org/dmcritchie/excel/buildtoc.htm
www.mvps.org/dmcritchie/excel/sheets.htm

There are object hyperlinks (Ctrl K) which I think you are using since you
mentioned quot;insertquot; 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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Daniel CHENquot; gt; wrote in message ...
gt; You need to make sure that the path/file is correct.
gt; --
gt; Best regards,
gt; ---
gt; Yongjun CHEN
gt; =================================
gt; XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
gt; - - - - www.XLDataSoft.com - - - -
gt; Free Excel-Based Data Processing Tool is Available for Download
gt; =================================
gt; quot;WilMongquot; gt; wrote in message
gt; ...
gt; gt; After inserted a Hyperlink to another excel worksheet file successfully,
gt; gt; error message quot;Cannot open the specified filequot; appeared while OPEN
gt; gt; Hyperlink,
gt; gt; please help?
gt;
gt;
Thanks Daniel amp; 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 quot;Cannot open the
specified filequot;...cheers

quot;David McRitchiequot; wrote:

gt; If you still have a problem see some examples in
gt; www.mvps.org/dmcritchie/excel/buildtoc.htm
gt; www.mvps.org/dmcritchie/excel/sheets.htm
gt;
gt; There are object hyperlinks (Ctrl K) which I think you are using since you
gt; mentioned quot;insertquot; and there is the HYPERLINK Worksheet Function
gt;
gt; If you still have a problem after checking those references, you would
gt; have to post what you had, what it got changed to, specifically why
gt; you know it doesn't work (the entire text of the message).
gt;
gt; The message you refer to is at least similar to other messages such
gt; as bad references in toolbar buttons, so also think if you moved any
gt; files around (pathname problems like Yongiun mentionded)..
gt;
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;Daniel CHENquot; gt; wrote in message ...
gt; gt; You need to make sure that the path/file is correct.
gt; gt; --
gt; gt; Best regards,
gt; gt; ---
gt; gt; Yongjun CHEN
gt; gt; =================================
gt; gt; XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
gt; gt; - - - - www.XLDataSoft.com - - - -
gt; gt; Free Excel-Based Data Processing Tool is Available for Download
gt; gt; =================================
gt; gt; quot;WilMongquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; After inserted a Hyperlink to another excel worksheet file successfully,
gt; gt; gt; error message quot;Cannot open the specified filequot; appeared while OPEN
gt; gt; gt; Hyperlink,
gt; gt; gt; please help?
gt; gt;
gt; gt;
gt;
gt;
gt;