[TRNSYS-users] The problem of Type 62 Calling-Excel

Thu Jan 30 00:46:47 PST 2014

Thank you for your reply, David.

The Type 62 problem happens to one of the computers in our laboratory, which is installed with TRNSYS 17 and Excel 2007.

Initially, we tried to use Excel 2010 on that computer, however, the error of "Access Violation..." happened.

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.

I have tried different kind of solutions as follows, but there is no effect:
-Install TRNSYS to the root folder C:/

                  -Move the excel file to the root folder C:/

                  -Enable all the macros in the Excel file

                  -Strictly save the Excel file in the .xls format
-open the security permissions for all the folders and files in that computer (including the right of reading and writing)
-run the TRNSYS programme as an administrator

Is there any other solution to solve this problem?

Kind Regards,
Sunliang

Date: Wed, 29 Jan 2014 12:14:41 -0600
From: d.bradley at tess-inc.com
To: trnsys-users at cae.wisc.edu; caosunliang at msn.com
Subject: Re: [TRNSYS-users] The problem of Type 62 Calling-Excel

    Sunliang,

      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.

    Kind regards,

     David

    On 1/29/2014 11:36, SUNLIANG CAO wrote:

      Thank you very much for your suggestion, Ben.

        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.

        Please keep me informed when you have found some other
        solutions.

        Kind Regards,

        Sunliang

          From: BHeymer at ecw.org

          To: trnsys-users at cae.wisc.edu

          Date: Wed, 29 Jan 2014 08:45:12 -0600

          Subject: Re: [TRNSYS-users] The problem of Type 62
          Calling-Excel

            Sunliang,

            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.

            This
                may or may not be the source of your issue, but it’s an
                easy thing to try.

              Ben
                  Heymer, PE
              Senior
                  Energy Engineer | Energy Center of Wisconsin
                  | Madison.Chicago.Minneapolis
              608.210.7168
                  | Mobile: 312.315.4783 | www.ecw.org

                From:
                    trnsys-users-bounces at cae.wisc.edu
                    [mailto:trnsys-users-bounces at cae.wisc.edu] On
                      Behalf Of SUNLIANG CAO

                    Sent: Wednesday, January 29, 2014 5:44 AM

                    To: trnsys-users at cae.wisc.edu

                    Subject: [TRNSYS-users] The problem of Type
                    62 Calling-Excel

              Dear
                  all,

                  We have encountered the problem with Type 62 (Calling
                  Excel) in TRNSYS 17. 

                  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".

                  This problem has not been happened in the computer
                  with Windows XP and Excel 2003.

                  I have also noticed this problem by other TRNSYS users
                  in the TRNSYS forum. However, it seems there is no
                  solution available yet.

                  The following solutions have been tried, but there is
                  no effect:

                  -Install TRNSYS to the root folder C:/

                  -Move the excel file to the root folder C:/

                  -Enable all the macros in the Excel file

                  -Strictly save the Excel file in the .xls format

                  Is there any other solution or experience to solve
                  this problem?

                  Thank you very much.

                  Kind Regards,

                  Sunliang

          _______________________________________________
          TRNSYS-users mailing list
          TRNSYS-users at cae.wisc.edu
          https://mailman.cae.wisc.edu/listinfo/trnsys-users

      _______________________________________________
TRNSYS-users mailing list
TRNSYS-users at cae.wisc.edu
https://mailman.cae.wisc.edu/listinfo/trnsys-users

    -- 
***************************
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
d.bradley at tess-inc.com

http://www.tess-inc.com
http://www.trnsys.com 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/trnsys-users-onebuilding.org/attachments/20140130/2f776441/attachment-0004.htm>