[TRNSYS-users] type 62 and Excel 2007

[Dimas Firmanda Al Riza]

Dear Robin,

Yes, in TRNSYS example file, the excel file is in .xls
I've got error message box "Access violation at address 10364756 in module
TRNDLL.DLL. Read of address 00000000".

and

Message : The Excel workbook could not be open. Please check the
fiIename:”C:\Program Files\Trnsys16_1\Examples\CaIling Excel\Sun
Position.xls

this is when I try TRNSYS example calling EXCEL sun position

Regards,

Dimas


On Tue, Nov 2, 2010 at 5:33 PM, Robin Exertier <robin.exertier at imelavi.fr>wrote:

> Dear Dimas,
>
> If you use Excel 2007, make sure that you have saved your file as a older
> version (.xls, not .xlsx)
>
> Are you sure that the Excel file name is good ?
>
> Regards,
>
> Robin
>
>
>
> 2010/11/2 Dimas Firmanda Al Riza <dimasfirmanda at gmail.com>
>
>> Dear Werner,
>>
>> Thanks for the reply,
>> I used TRNSYS 16 btw,
>> I check all connection and file, it looks like all fine
>> but when I run the simulation, it did not work
>>
>> Regards,
>>
>> Dimas
>>
>>
>> On Tue, Nov 2, 2010 at 4:06 PM, keilholz, werner <werner.keilholz at cstb.fr
>> > wrote:
>>
>>>  Dear Dimas,
>>>
>>>
>>>
>>> Did you try the examples in \Trnsys17\Examples\Calling_Excel ? I just
>>> tried it with Excel 2007 and they work nicely.
>>>
>>>
>>>
>>> If the file cannot be found, you have to check under “Special cards” in
>>> Type 62 (not external files as usual).
>>>
>>>
>>>
>>> Werner
>>>
>>>
>>>
>>> *De :* Dimas Firmanda Al Riza [mailto:dimasfirmanda at gmail.com]
>>> *Envoyé :* lundi 1 novembre 2010 11:19
>>> *À :* trnsys-users at cae.wisc.edu
>>> *Objet :* [TRNSYS-users] type 62 and Excel 2007
>>>
>>>
>>>
>>> Dear all,
>>>
>>>
>>>
>>> How to make type 62 work with Excel 2007?
>>>
>>> I have tried the example file (with .xls file), but it did not work
>>>
>>>
>>>
>>> "The Excel Workbook could not be open please check the file name...."
>>>
>>>
>>>
>>> Thanks a lot
>>>
>>>
>>>
>>> Regards
>>>
>>>
>>>
>>> Dimas
>>>
>>
>>
>> _______________________________________________
>> TRNSYS-users mailing list
>> TRNSYS-users at cae.wisc.edu
>> https://www-old.cae.wisc.edu/mailman/listinfo/trnsys-users
>>
>>
>
>
> --
> Robin Exertier
> Ingénieur Arts et Métier ParisTech - Construction et Habitat Durables
> Mobile : +33 (0)6 89 90 35 52
> e-mail : robin.exertier at imelavi.fr
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/trnsys-users-onebuilding.org/attachments/20101102/f82e7f10/attachment-0005.htm>