Page 1 of 1

help!!!!!use dll call data from excel to mc9 ???

Posted: Mar 03 2015
by king989
dear,
can help me how to fix this problem as following? i already reset my computer and mc9 more than once, the problem still there.

when the begin, i use dll for call the data from excel to mc9, i use the file name is xxx.xsm.xls, the problem happened, after that, i use the second computer to do that, it happened again, i used the third computer to do that, but this time i use the file name is xxx.xlm, it working.

i reset my frist one and second computer, but the problem still there, can anyone help me to fix that??

<<EXCEPTION>>
Code: 0xFFFFFFFFE0434352 ( -532462766 )
Continuable: 0x0000000000000001 ( 1 )
ErrorCode: 0xFFFFFFFFE0434352 ( -532462766 )
ExceptionType: 0x0000000000000000 ( 0 )
Module: C:\Windows\system32\KERNELBASE.dll
Process: C:\Program Files\TS Support\MultiCharts64\MultiCharts64.exe
Thread ID: 0x0000000000000BE4 ( 3044 )
Time: 02.03.2015 - 14:11:22.391


david king

Re: help!!!!!use dll call data from excel to mc9 ???

Posted: Mar 20 2015
by Henry MultiŠ”harts
Hello king989,

When "Application error" window appears with Exception or Assert information please click "Terminate" button and manually collect the logs. Here is how to find the logs. Once you have the logs folder zipped please send it to support@multicharts.com for analysis.

Re: help!!!!!use dll call data from excel to mc9 ???

Posted: Mar 31 2015
by arjfca
I had experienced a lot of problem when using a dll to transfert data directly or from Excel. Basically, one of the inside function seem to cause a memory leak.

How I resolve the problem:

I'm using 2 procedure to do it now. Won't work for live data

1' Transferring data trough a text file. Excel to read a text file generated by MC. MC to read Text file created by Excel. Text file formatted as a CSV file. All number represented as a string

2' Use Global Variable ( string)
Global Variable dll could be define in Excel. Both MC and Excel could share the same GV_Named_String variable. Again, I use only string of data to transfer my info

To capture a specific data in your CSV string, you could use the function that I published on this site for Excel and MC. Look for SplitString() EX:Splitstring(2) ( "Hello, how,are,you") = "how"

Martin