<br /> Dear Anubhav Mehrotra,<br /><br />I was able to run more than one instance of Type62 in a TRNSYS Simulation. It should be able to work unless your Excel program is preventing something.<br /><br />Best regards,<br /><br />Matt Duffy<br /> <br /> <!--replyfwdwrap--><div style="background-image: url("http://webmail.fusemail.com/de/r_bg_img.gif"); background-position: center top; background-repeat: repeat-x;"><strong>----- Original Message -----</strong><br /><strong>From:</strong> "Anubhav Mehrotra" <enggmechm1@gmail.com> <br /><strong>Sent:</strong> Wed, April 20, 2011 3:08<br /><strong>Subject:</strong> [TRNSYS-users] Calling type 62 twice (2 Excel sheets)<br /><br /><table cellspacing="5" width="100%"><tbody><tr><td><div class="PrivateMsgDiv"><!-- begin sanitized html --> <style type="text/css">
</style><div class="bodyclass"><div class="WordSection1"><p class="MsoNormal"><i><span style="font-size: 10pt; font-family: "Courier New"; color: black;">Dear TRNSYS users,</span></i></p><p class="MsoNormal"><i><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> </span></i></p><p class="MsoNormal"><i><span style="font-size: 10pt; font-family: "Courier New"; color: black;">In a project, I am using the type 62 multiple time (4) in order to call Excel. The excel sheets called are not the same. The problem is that there seems to be a conflict, because the macros of each sheet do not work. While only one sheet is called it works perfectly fine.The problem is that more than one type 62 needs to be used, since more than ten variables are needed! We found out that the limit for types 62 to be used is 20.</span></i></p><p class="MsoNormal"><i><span style="font-size: 10pt; font-family: "Courier New"; color: black;">&nb!
sp;</span></i></p><p class="MsoNormal"><i><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> Thank you very much in advance</span></i></p><p class="MsoNormal"><i><span style="font-size: 10pt; font-family: "Courier New"; color: black;"> </span></i></p><p class="MsoNormal"><i><span style="font-size: 10pt; font-family: "Courier New"; color: black;">Regards</span></i></p><p class="MsoNormal"><i><span style="font-size: 10pt; font-family: "Courier New"; color: black;">Anubhav Mehrotra </span></i></p><p class="MsoNormal"><i><span style="font-size: 10pt; font-family: "Courier New"; color: black;">VIT University</span></i></p></div></div><!-- end sanitized html --> <hr size="1" noshade="noshade" /><pre>
_______________________________________________
TRNSYS-users mailing list
<a href="javascript:bodyCreateMail('TRNSYS-users%40cae.wisc.edu')">TRNSYS-users@cae.wisc.edu</a>
<a target="_blank" href="https://mailman.cae.wisc.edu/listinfo/trnsys-users">https://mailman.cae.wisc.edu/listinfo/trnsys-users</a>
</pre></div></td></tr> </tbody></table></div>