[TRNSYS-users] Transfer of data from TRNSYS to Excel

[Diego A. Arias]

Dear João,

João Lopes wrote:

>Dear TRNSYS Users,
>
>Please delete previous emailas subject was incorrect. Apologies for the
>inconvenience.
>
>1. Problem description
>Using TRNSYS I am trying to use TYPE62 to call Excel just for a single data
>transfer from TRNSYS to a Excel spreadsheet.
>
>The error I get is the following:
>Acess violation at address 0101656 in module TRNDLL.DLL. READ of address 000
>
>This is the same error I get when using the examples from TRNSYS.
>  
>
Do you get this same error when you run the example found in 
\Examples\Calling Excel?

>2. Possible cause of error
>TRNSYS can acess Excel spreadsheet with macros due to security setting.
>
>Then I create a simple spreadsheet without any macro, only with three cells
>(inp1, inp2 e inp3) and I got the same error.
>  
>
You have to create a macro called 'TRNSYS'.  Please follow the code in 
the examples provided in the mentioned directory.
Please let me know if this helps.
Best regards,

Diego

>3. Need for help
>I just want to pass some output data from Trnsys to excel in order to edit
>it using excel capabilities.
>
>Would please let me know how to fix this.
>
>Thank you
>
>Best regards
>
>J Lopes
>
>
>
>_______________________________________________
>TRNSYS-users mailing list
>TRNSYS-users at engr.wisc.edu
>https://www.cae.wisc.edu/mailman/listinfo/trnsys-users
>  
>


-- 

Diego A. Arias
TRNSYS Coordinator
Solar Energy Laboratory
University of Wisconsin - Madison
1500 Engineering Drive
Madison, WI 53706