[TRNSYS-users] Calling Excell

[Mohamed Ayman]

Stéphan,
I recommend that, take a copy of Excel file that is in example folder of Trnsys. After that, you can adjust the cells what you want to read as output according to data you adjust it as inputs. Because the problem might be not only in the the security settings in Excel but also there is a macro has to be already inside the file. Therefore Trnsys can read what you want.  
--
Regards
Ayman Mohamed
________________________________________
From: trnsys-users-bounces at cae.wisc.edu [trnsys-users-bounces at cae.wisc.edu] on behalf of struong at student.ulg.ac.be [struong at student.ulg.ac.be]
Sent: Sunday, July 15, 2012 7:59 PM
To: trnsys-users at cae.wisc.edu
Subject: [TRNSYS-users] Calling Excell

Dear TRNSYS-Users,

I'm trying to use type 62 calling excel. I have the same problem as Simon (see message below). I checked the security settings in Excel and chose "Enable all macros". But it still doesn't work! Could it be a problem linked to excel 2010? I tried by saving my excel worksheet in 2007 because with 2010 we are obliged to save as a ".xlsm" when using macros... But it still doesn't work.

Thanks for any suggestions

Best Regards,

Stéphan Truong
2 ème Master STE
Gembloux Agro Bio-Tech


Simon,
Check the security settings in Excel on the computer that won't run the
example. When TRNSYS calls Excel, it runs a macro that is embedded in
the Excel file. If your Excel settings are such that Excel will not open
any files that have macros in them, you will get this error.
Best,
David


On 1/23/2012 03:02, Simon Binnemans wrote:
> Dear all,
>
> I tried to run the example file's for "calling Excel", type 62. But
> neither of them seem to work on my computer. When trying to run the
> file, the following error-window pops up:
> "Access violation at adress 104301D6 in module 'TRNDLL.DLL'. Read of
> address 000000000."
> And:
> "An unexpected error was encountered and TRNSYS will abort."
>
> At the result-file the following error-message shows up:
> "The Excel workbook could not be open. Please check the
> filename:"C:\Trnsys17\Examples\Calling_Ecxel\Schedule.xls""
>
> I already tried to copy the file directly under C:\ but the error
> remains.
>
> When I try to run the example files on a different pc, with the same
> version of TRNSYS, windows and Excel, the program works without an error.
>
> Does anyone have an idea witch might cause this problem or how to
> handle the it?
>
> Regards,
> Simon
>
> _______________________________________________
> 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
_______________________________________________
TRNSYS-users mailing list
TRNSYS-users at cae.wisc.edu
https://mailman.cae.wisc.edu/listinfo/trnsys-users