[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



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@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