AnsweredAssumed Answered

vrf VRF Excel Anaylsis Tool Pack Functions

Question asked by mford on May 21, 2004
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"><META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD><BODY><DIV><FONT face=Arial size=2><SPAN class=709171221-21052004>Greetings VRF,</SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=709171221-21052004></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=709171221-21052004>I'm have a weird problem using the (Excel Anaylsis Tool Pack) Function Dec2Hex(x,x) in Excel.</SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=709171221-21052004></SPAN></FONT> </DIV><UL>  <LI><FONT face=Arial size=2><SPAN class=709171221-21052004>When I open Excel   Manually, this function works fine, but when I call the same file with ActiveX   I get the <STRONG>#Name?</STRONG> error in the cell containing the   function.</SPAN></FONT></LI>  <LI><FONT face=Arial size=2><SPAN class=709171221-21052004>If I save the file   complete with data and reopen it with ActiveX it initially looks fine until I   attempt to make any change. Then the error appears on all cells with this   function.</SPAN></FONT></LI>  <LI><FONT face=Arial size=2><SPAN class=709171221-21052004>If I deselect the   Analysis Tool Pack, the error occurs always. </SPAN></FONT></LI></UL><DIV><FONT face=Arial size=2><SPAN class=709171221-21052004></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=709171221-21052004></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=709171221-21052004>I'm presently using VEE 6.01, NT, and  Office 2000. I'm starting to believe that out Network Administrator has disabled certain Office functions when used remotely, but I won't get the chance to ask him until Monday.</SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=709171221-21052004></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=709171221-21052004>Has anyone else seen this problem?</SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=709171221-21052004> </SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=709171221-21052004></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=709171221-21052004></SPAN></FONT> </DIV><DIV><FONT face="Century Gothic" size=2><STRONG><DIV><FONT face="Century Gothic" size=2><STRONG>Michael Ford</STRONG></FONT></DIV><DIV><FONT face=Arial size=2>Test Engineering</FONT></DIV><DIV><FONT face=Arial size=2>Herley Farmingdale</FONT></DIV><DIV><FONT face=Arial size=2>425 Smith Street Farmingdale, NY 11735-1198</FONT></DIV><DIV><FONT face=Arial size=2>(phone) 631.630.2000 ext 268  (fax) 631.630.2066</FONT></DIV><DIV><FONT face=Arial><FONT size=2><SPAN class=284475519-02032004><FONT face="Century Gothic"><A href="mailto:Michael.Ford@Herley.com">mailto:</FONT></SPAN>Michael.Ford@Herley.com</A></FONT></FONT></DIV><DIV><FONT face=Arial size=2></FONT> </DIV></STRONG></FONT></DIV><DIV> </DIV>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list,  email "vrf@agilent.com".  <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></HTML>  

Outcomes