Dear Robin,<div><br></div><div>Yes, in TRNSYS example file, the excel file is in .xls</div><div>I've got error message box "Access violation at address 10364756 in module TRNDLL.DLL. Read of address 00000000".</div>
<div><br></div><div>and</div><div><br></div><div><div>Message : The Excel workbook could not be open. Please check the fiIename:”C:\Program Files\Trnsys16_1\Examples\CaIling Excel\Sun Position.xls</div><div><br></div></div>
<div>this is when I try TRNSYS example calling EXCEL sun position</div><div><br></div><div>Regards,</div><div><br></div><div>Dimas</div><div><div><br></div><br><div class="gmail_quote">On Tue, Nov 2, 2010 at 5:33 PM, Robin Exertier <span dir="ltr"><<a href="mailto:robin.exertier@imelavi.fr">robin.exertier@imelavi.fr</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">Dear Dimas,<br><br>If you use Excel 2007, make sure that you have saved your file as a older version (.xls, not .xlsx)<br>
<br>Are you sure that the Excel file name is good ?<br><br>Regards,<br><br>Robin<br><br><br><br></div><div class="gmail_quote"><div class="im">
2010/11/2 Dimas Firmanda Al Riza <span dir="ltr"><<a href="mailto:dimasfirmanda@gmail.com" target="_blank">dimasfirmanda@gmail.com</a>></span><br></div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
Dear Werner,<div><div></div><div class="h5"><div><br></div><div>Thanks for the reply,</div><div>I used TRNSYS 16 btw,</div><div>I check all connection and file, it looks like all fine</div><div>but when I run the simulation, it did not work</div>
<div><br>
</div><div>Regards,</div><div><br></div><font color="#888888"><div>Dimas</div></font><div><div></div><div><div><br></div><div><br><div class="gmail_quote">On Tue, Nov 2, 2010 at 4:06 PM, keilholz, werner <span dir="ltr"><<a href="mailto:werner.keilholz@cstb.fr" target="_blank">werner.keilholz@cstb.fr</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<div link="blue" vlink="purple" lang="FR">
<div>
<p class="MsoNormal"><span style="font-size:11pt;color:rgb(31, 73, 125)" lang="EN-US">Dear Dimas, </span></p>
<p class="MsoNormal"><span style="font-size:11pt;color:rgb(31, 73, 125)" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:11pt;color:rgb(31, 73, 125)" lang="EN-US">Did you try the examples in \Trnsys17\Examples\Calling_Excel ? I
just tried it with Excel 2007 and they work nicely.</span></p>
<p class="MsoNormal"><span style="font-size:11pt;color:rgb(31, 73, 125)" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:11pt;color:rgb(31, 73, 125)" lang="EN-US">If the file cannot be found, you have to check under “Special
cards” in Type 62 (not external files as usual).</span></p>
<p class="MsoNormal"><span style="font-size:11pt;color:rgb(31, 73, 125)" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:11pt;color:rgb(31, 73, 125)" lang="EN-US">Werner</span></p>
<p class="MsoNormal"><span style="font-size:11pt;color:rgb(31, 73, 125)" lang="EN-US"> </span></p>
<div style="border-width:1pt medium medium;border-style:solid none none;border-color:rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color;padding:3pt 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10pt">De :</span></b><span style="font-size:10pt"> Dimas Firmanda Al
Riza [mailto:<a href="mailto:dimasfirmanda@gmail.com" target="_blank">dimasfirmanda@gmail.com</a>] <br>
<b>Envoyé :</b> lundi 1 novembre 2010 11:19<br>
<b>À :</b> <a href="mailto:trnsys-users@cae.wisc.edu" target="_blank">trnsys-users@cae.wisc.edu</a><br>
<b>Objet :</b> [TRNSYS-users] type 62 and Excel 2007</span></p>
</div><div><div></div><div>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Dear all,</p>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">How to make type 62 work with Excel 2007?</p>
</div>
<div>
<p class="MsoNormal">I have tried the example file (with .xls file), but it did
not work</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">"The Excel Workbook could not be open please check the
file name...."</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Thanks a lot</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Regards</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Dimas</p>
</div>
</div></div></div>
</div>
</blockquote></div><br></div>
</div></div><br></div></div><div class="im">_______________________________________________<br>
TRNSYS-users mailing list<br>
<a href="mailto:TRNSYS-users@cae.wisc.edu" target="_blank">TRNSYS-users@cae.wisc.edu</a><br>
<a href="https://www-old.cae.wisc.edu/mailman/listinfo/trnsys-users" target="_blank">https://www-old.cae.wisc.edu/mailman/listinfo/trnsys-users</a><br>
<br></div></blockquote></div><div><div></div><div class="h5"><br><br clear="all"><br>-- <br><span style="font-family:times new roman,serif">Robin Exertier</span><br style="font-family:times new roman,serif"><span style="font-family:times new roman,serif">Ingénieur Arts et Métier ParisTech - Construction et Habitat Durables</span><br style="font-family:times new roman,serif">
<span style="font-family:times new roman,serif">Mobile : +33 (0)6 89 90 35 52</span><br style="font-family:times new roman,serif"><span style="font-family:times new roman,serif">e-mail : </span><a style="font-family:times new roman,serif" href="mailto:robin.exertier@imelavi.fr" target="_blank">robin.exertier@imelavi.fr</a><br>
</div></div></blockquote></div><br></div>