<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Thank you for your reply, David.<br><br>The Type 62 problem happens to one of the computers in our laboratory, which is installed with TRNSYS 17 and Excel 2007.<br><br>Initially, we tried to use Excel 2010 on that computer, however, the error of "Access Violation..." happened.<br><br>Then after checking the source code of Type 62 in TRNSYS 17, as you mentioned, we found that Excel 2007 has been mentioned in the source code. Then we degrade the Excel back to 2007 on that computer. Unfortunately, the problem remains the same.<br><br>I have tried different kind of solutions as follows, but there is no effect:<br><span style="font-family:"Calibri","sans-serif";">-Install TRNSYS to the root folder C:/<br>
-Move the excel file to the root folder C:/<br>
-Enable all the macros in the Excel file<br>
-Strictly save the Excel file in the .xls format<br>-open the security permissions for all the folders and files in that computer (including the right of reading and writing)<br>-run the TRNSYS programme as an administrator<br></span><br><br>Is there any other solution to solve this problem?<br><br>Kind Regards,<br>Sunliang<br><br><br><br><br><div><hr id="stopSpelling">Date: Wed, 29 Jan 2014 12:14:41 -0600<br>From: d.bradley@tess-inc.com<br>To: trnsys-users@cae.wisc.edu; caosunliang@msn.com<br>Subject: Re: [TRNSYS-users] The problem of Type 62 Calling-Excel<br><br>
Sunliang,<br>
Which version of TRNSYS are you using? I use Windows 7 and Excel
2007 and am able to run both examples (as well as other projects
that couple TRNSYS and Excel). We did significantly rewrite Type62
for the release of Trnsys17 so if by chance you are using Trnsys16,
I can imagine that the link might not work.<br>
Kind regards,<br>
David<br>
<br>
<br>
<div class="ecxmoz-cite-prefix">On 1/29/2014 11:36, SUNLIANG CAO wrote:<br>
</div>
<blockquote cite="mid:BLU175-W16EB9BF8975739C6BC97F4ADAC0@phx.gbl">
<style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style>
<div dir="ltr">Thank you very much for your suggestion, Ben.<br>
<br>
I tried to use the method you mentioned, but unfortunately it
has no effect. I think there should be some other reasons for
this Type 62 problem.<br>
<br>
Please keep me informed when you have found some other
solutions.<br>
<br>
Kind Regards,<br>
Sunliang<br>
<br>
<br>
<div>
<hr id="ecxstopSpelling">From: <a class="ecxmoz-txt-link-abbreviated" href="mailto:BHeymer@ecw.org">BHeymer@ecw.org</a><br>
To: <a class="ecxmoz-txt-link-abbreviated" href="mailto:trnsys-users@cae.wisc.edu">trnsys-users@cae.wisc.edu</a><br>
Date: Wed, 29 Jan 2014 08:45:12 -0600<br>
Subject: Re: [TRNSYS-users] The problem of Type 62
Calling-Excel<br>
<br>
<style><!--
.ExternalClass p.ecxMsoNormal, .ExternalClass li.ecxMsoNormal, .ExternalClass div.ecxMsoNormal {
font-size:12.0pt;
font-family:SimSun;
}
.ExternalClass a:link, .ExternalClass span.ecxMsoHyperlink {
color:blue;
text-decoration:underline;
}
.ExternalClass span.ecxMsoHyperlinkFollowed {
color:purple;
text-decoration:underline;
}
.ExternalClass p {
font-size:12.0pt;
font-family:SimSun;
}
.ExternalClass span.ecxEmailStyle18 {
font-family:"Arial","sans-serif";
color:windowtext;
font-weight:normal;
font-style:normal;
}
.ExternalClass .ecxMsoChpDefault {
font-size:10.0pt;
}
.ExternalClass div.ecxWordSection1 {
}
--></style>
<div class="ecxWordSection1">
<p class="ecxMsoNormal"><span style="font-family:"Calibri","sans-serif";">Sunliang</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";">,</span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";">Sometimes
the permissions settings in the Windows OS interfere
with program interoperability. You can change settings
by right clicking the executable and selecting
¡°properties¡±. Choosing ¡°Run this program as an
administrator¡± has been helpful for me in the past.</span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";"> </span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";">This
may or may not be the source of your issue, but it¡¯s an
easy thing to try.</span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";"> </span></p>
<div>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;">Ben
Heymer, PE</span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;">Senior
Energy Engineer | <b>Energy Center of Wisconsin</b></span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:gray;">
| <b>Madison.Chicago.Minneapolis</b></span></p>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;">608.210.7168
| Mobile: 312.315.4783 | <a href="http://www.ecw.org/" title="Energy Center Home Page" target="_blank"><span style="color:black;text-decoration:none;">www.ecw.org</span></a></span></p>
</div>
<p class="ecxMsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";"> </span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in;">
<p class="ecxMsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";">
<a class="ecxmoz-txt-link-abbreviated" href="mailto:trnsys-users-bounces@cae.wisc.edu">trnsys-users-bounces@cae.wisc.edu</a>
[<a class="ecxmoz-txt-link-freetext" href="mailto:trnsys-users-bounces@cae.wisc.edu">mailto:trnsys-users-bounces@cae.wisc.edu</a>] <b>On
Behalf Of </b>SUNLIANG CAO<br>
<b>Sent:</b> Wednesday, January 29, 2014 5:44 AM<br>
<b>To:</b> <a class="ecxmoz-txt-link-abbreviated" href="mailto:trnsys-users@cae.wisc.edu">trnsys-users@cae.wisc.edu</a><br>
<b>Subject:</b> [TRNSYS-users] The problem of Type
62 Calling-Excel</span></p>
</div>
</div>
<p class="ecxMsoNormal"> </p>
<div>
<p class="ecxMsoNormal" style=""><span style="font-family:"Calibri","sans-serif";">Dear
all,<br>
<br>
We have encountered the problem with Type 62 (Calling
Excel) in TRNSYS 17. <br>
<br>
When we try to run Type 62 with Excel 2007 in Windows
7, an error shows that "Access violation at
address.......". This problem also happens for the
Example projects in TRNSYS such as the examples of
"Sun position" and "Schedule".<br>
<br>
This problem has not been happened in the computer
with Windows XP and Excel 2003.<br>
<br>
I have also noticed this problem by other TRNSYS users
in the TRNSYS forum. However, it seems there is no
solution available yet.<br>
<br>
The following solutions have been tried, but there is
no effect:<br>
-Install TRNSYS to the root folder C:/<br>
-Move the excel file to the root folder C:/<br>
-Enable all the macros in the Excel file<br>
-Strictly save the Excel file in the .xls format<br>
<br>
<br>
Is there any other solution or experience to solve
this problem?<br>
<br>
Thank you very much.<br>
<br>
Kind Regards,<br>
Sunliang<br>
<br>
</span></p>
</div>
</div>
<br>
_______________________________________________
TRNSYS-users mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:TRNSYS-users@cae.wisc.edu">TRNSYS-users@cae.wisc.edu</a>
<a class="ecxmoz-txt-link-freetext" href="https://mailman.cae.wisc.edu/listinfo/trnsys-users" target="_blank">https://mailman.cae.wisc.edu/listinfo/trnsys-users</a></div>
</div>
<br>
<fieldset class="ecxmimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
TRNSYS-users mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:TRNSYS-users@cae.wisc.edu">TRNSYS-users@cae.wisc.edu</a>
<a class="ecxmoz-txt-link-freetext" href="https://mailman.cae.wisc.edu/listinfo/trnsys-users" target="_blank">https://mailman.cae.wisc.edu/listinfo/trnsys-users</a>
</pre>
</blockquote>
<br>
<pre class="ecxmoz-signature">--
***************************
David BRADLEY
Principal
Thermal Energy Systems Specialists, LLC
22 North Carroll Street - suite 370
Madison, WI 53703 USA
P:+1.608.274.2577
F:+1.608.278.1475
<a class="ecxmoz-txt-link-abbreviated" href="mailto:d.bradley@tess-inc.com">d.bradley@tess-inc.com</a>
<a class="ecxmoz-txt-link-freetext" href="http://www.tess-inc.com" target="_blank">http://www.tess-inc.com</a>
<a class="ecxmoz-txt-link-freetext" href="http://www.trnsys.com" target="_blank">http://www.trnsys.com</a></pre></div> </div></body>
</html>