Hi everyone, I'm new!<br />
<br />
At work we have two documents, one is an autocad file that is a map of the area and our customers. The other is a single excel file that has each customers information. In autocad you can edit individual objects and make them hyperlinks. What I would like to do is take a customer name and make it into a hyperlink into this excel file. It doesn't matter what program opens the file. <br />
<br />
For the sake of clarity, this is what I'm talking about: You are browsing the autocad file and you come across a customer name, mary jane. You need mary jane's account information, so you click on her name in the autocad file and the excel file opens up (in IE/Excel/whatever) at the place in the file where mary janes information is.<br />
<br />
Any comments are much appreciated! thanks!<br />
<br />
jeff<!--content--><HTML><br />
<HEAD><br />
<Title>Excel Linking Example</Title><br />
</HEAD><br />
<body><br />
<p><br />
<a href=http://www.htmlforums.com/archive/index.php/"http://localhost/excel/asheet.xls#Sheet2!D4"><br />
This link will open the Excel file to the second page with the focus on<br />
cell D4</a>.<br />
<a href=http://www.htmlforums.com/archive/index.php/"http://localhost/excel/asheet.xls#TableName"><br />
This link will set the focus on a named area of the spreadsheet<br />
</a>.<br />
</p><br />
<form><br />
<input type=button<br />
value="Via Jscript"<br />
onclick='location.href = <!-- m --><a class="postlink" href="http://www.htmlforums.com/archive/index.php/">http://www.htmlforums.com/archive/index.php/</a><!-- m -->"asheet.xls#TableName"'><br />
</form><br />
</body><br />
</html><br />
<br />
<br />
from.... <!-- m --><a class="postlink" href="http://support.microsoft.com/default.aspx?scid=kb;">http://support.microsoft.com/default.aspx?scid=kb;</a><!-- m -->[LN];Q197922<!--content-->
<br />
At work we have two documents, one is an autocad file that is a map of the area and our customers. The other is a single excel file that has each customers information. In autocad you can edit individual objects and make them hyperlinks. What I would like to do is take a customer name and make it into a hyperlink into this excel file. It doesn't matter what program opens the file. <br />
<br />
For the sake of clarity, this is what I'm talking about: You are browsing the autocad file and you come across a customer name, mary jane. You need mary jane's account information, so you click on her name in the autocad file and the excel file opens up (in IE/Excel/whatever) at the place in the file where mary janes information is.<br />
<br />
Any comments are much appreciated! thanks!<br />
<br />
jeff<!--content--><HTML><br />
<HEAD><br />
<Title>Excel Linking Example</Title><br />
</HEAD><br />
<body><br />
<p><br />
<a href=http://www.htmlforums.com/archive/index.php/"http://localhost/excel/asheet.xls#Sheet2!D4"><br />
This link will open the Excel file to the second page with the focus on<br />
cell D4</a>.<br />
<a href=http://www.htmlforums.com/archive/index.php/"http://localhost/excel/asheet.xls#TableName"><br />
This link will set the focus on a named area of the spreadsheet<br />
</a>.<br />
</p><br />
<form><br />
<input type=button<br />
value="Via Jscript"<br />
onclick='location.href = <!-- m --><a class="postlink" href="http://www.htmlforums.com/archive/index.php/">http://www.htmlforums.com/archive/index.php/</a><!-- m -->"asheet.xls#TableName"'><br />
</form><br />
</body><br />
</html><br />
<br />
<br />
from.... <!-- m --><a class="postlink" href="http://support.microsoft.com/default.aspx?scid=kb;">http://support.microsoft.com/default.aspx?scid=kb;</a><!-- m -->[LN];Q197922<!--content-->