[TRNSYS-users] Calling Excell

[struong at student.ulg.ac.be]

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