<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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="moz-cite-prefix">On 1/29/2014 11:36, SUNLIANG CAO wrote:<br>
</div>
<blockquote cite="mid:BLU175-W16EB9BF8975739C6BC97F4ADAC0@phx.gbl"
type="cite">
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
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="stopSpelling">From: <a class="moz-txt-link-abbreviated" href="mailto:BHeymer@ecw.org">BHeymer@ecw.org</a><br>
To: <a class="moz-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 moz-do-not-send="true"
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="moz-txt-link-abbreviated" href="mailto:trnsys-users-bounces@cae.wisc.edu">trnsys-users-bounces@cae.wisc.edu</a>
[<a class="moz-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="moz-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="moz-txt-link-abbreviated" href="mailto:TRNSYS-users@cae.wisc.edu">TRNSYS-users@cae.wisc.edu</a>
<a class="moz-txt-link-freetext" href="https://mailman.cae.wisc.edu/listinfo/trnsys-users">https://mailman.cae.wisc.edu/listinfo/trnsys-users</a></div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
TRNSYS-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:TRNSYS-users@cae.wisc.edu">TRNSYS-users@cae.wisc.edu</a>
<a class="moz-txt-link-freetext" href="https://mailman.cae.wisc.edu/listinfo/trnsys-users">https://mailman.cae.wisc.edu/listinfo/trnsys-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
***************************
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="moz-txt-link-abbreviated" href="mailto:d.bradley@tess-inc.com">d.bradley@tess-inc.com</a>
<a class="moz-txt-link-freetext" href="http://www.tess-inc.com">http://www.tess-inc.com</a>
<a class="moz-txt-link-freetext" href="http://www.trnsys.com">http://www.trnsys.com</a></pre>
</body>
</html>