PC Review


Reply
Thread Tools Rate Thread

Hyperlink from Different File to Specified Worksheet

 
 
MA P
Guest
Posts: n/a
 
      9th Nov 2006
I have 2 Files (File1.xls and File2.xls). Both files have 3 worksheets. How
do I create hyperlink from File1 to File2's Sheet2 worksheet?

Hope you might help.



 
Reply With Quote
 
 
 
 
bobocat
Guest
Posts: n/a
 
      9th Nov 2006
set the hyperlink to
c:\\path\file2.xls#sheet2!a1

"MA P" <(E-Mail Removed)> 撰寫於郵件新聞:(E-Mail Removed)...
>I have 2 Files (File1.xls and File2.xls). Both files have 3 worksheets. How
>do I create hyperlink from File1 to File2's Sheet2 worksheet?
>
> Hope you might help.
>
>
>



 
Reply With Quote
 
MA P
Guest
Posts: n/a
 
      10th Nov 2006
thanks
"bobocat" <(E-Mail Removed)> wrote in message
news:O02FpA%(E-Mail Removed)...
> set the hyperlink to
> c:\\path\file2.xls#sheet2!a1
>
> "MA P" <(E-Mail Removed)>
> 撰寫於郵件新聞:(E-Mail Removed)...
>>I have 2 Files (File1.xls and File2.xls). Both files have 3 worksheets.
>>How do I create hyperlink from File1 to File2's Sheet2 worksheet?
>>
>> Hope you might help.
>>
>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting a hyperlink to file creates DFS hyperlink instead of drive-letter link Brian Roden Microsoft Outlook Discussion 0 18th Sep 2006 09:32 PM
Calling a specific worksheet from a hyperlink in a seperate file. TheChris Microsoft Excel Worksheet Functions 0 2nd Feb 2006 02:48 AM
... How do I Hyperlink to worksheet of an Excel file ... =?Utf-8?B?RHIuIERhcnJlbGw=?= Microsoft Excel Misc 1 22nd Jul 2005 03:23 PM
Intranet hyperlink to specific worksheet in excel file problem jamie Microsoft Excel Misc 1 10th Jan 2004 05:35 AM
Hyperlink to a Chart1 worksheet in same file NZ Carol Microsoft Excel Misc 1 5th Jan 2004 10:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:44 PM.