Hello
I want to reactivate an old project using Excel Link ELXL function. Anybody succeeded using that collection?
Martin
Excel Link.. Send data to Excel /Reactivating an old project [SOLVED]
- Dave Masalov
- Posts: 1712
- Joined: 16 Apr 2010
- Has thanked: 51 times
- Been thanked: 489 times
Re: Excel Link.. Send data to Excel /Reactivating an old pro
Hello Martin,
I have sent you the link to ELXL library in PM. Do you have any particular questions regarding this library?
I have sent you the link to ELXL library in PM. Do you have any particular questions regarding this library?
Re: Excel Link.. Send data to Excel /Reactivating an old pro
ThanksHello Martin,
I have sent you the link to ELXL library in PM. Do you have any particular questions regarding this library?
I never succeed to work with that library. I installed your proposed one and still the same problem. I always get error 50
- Excel sheet do exist and is opened
- One instance only ( verify with Task Manager)
- ELExcel.dll reside under Tssupport/Multicharts directory and under System32 directory
I suspect that the dll does not reside in a proper directory, but no mention on where it should be
the demo code:
Code: Select all
inputs:
string WorkbookName( "Demo Workbook 2.xls" ),
string WorksheetName( "Sheet1" ) ;
variables:
bool WorksheetReady( false ) ;
Once Print ("Step1");
WorksheetReady = ELXL_WithSheet( WorkbookName, WorksheetName ) ;
Once print ("step2");
- Attachments
-
- Error50.png
- (21.22 KiB) Downloaded 1240 times
- Dave Masalov
- Posts: 1712
- Joined: 16 Apr 2010
- Has thanked: 51 times
- Been thanked: 489 times
Re: Excel Link.. Send data to Excel /Reactivating an old pro
Hello Martin,
It seems like the problem is in the dll itself. Do you use MC 32 bit? What is the Windows version?
It seems like the problem is in the dll itself. Do you use MC 32 bit? What is the Windows version?
Re: Excel Link.. Send data to Excel /Reactivating an old pro
I'm using MC 32Hello Martin,
It seems like the problem is in the dll itself. Do you use MC 32 bit? What is the Windows version?
My Windows is Win 7 64
My Excel is Office 2010 32 bit
Martin
- Dave Masalov
- Posts: 1712
- Joined: 16 Apr 2010
- Has thanked: 51 times
- Been thanked: 489 times
Re: Excel Link.. Send data to Excel /Reactivating an old pro
Hello Martin,
Have you tried to use the test script which comes with elxl.dll? It works fine on our end.
We put the dll into MultiCharts folder, imported the archive, opened Excel documents (disabling read-only properties). Then plotted a 1 minute ESZ2 chart from Oepn E Cry with 500 bars on it and applied both indicators. Data started to come to Excel. Please see attached screenshot.
Have you tried to use the test script which comes with elxl.dll? It works fine on our end.
We put the dll into MultiCharts folder, imported the archive, opened Excel documents (disabling read-only properties). Then plotted a 1 minute ESZ2 chart from Oepn E Cry with 500 bars on it and applied both indicators. Data started to come to Excel. Please see attached screenshot.
- Attachments
-
- elxl.jpg
- (397.02 KiB) Downloaded 1266 times
Re: Excel Link.. Send data to Excel /Reactivating an old pro
Dave, good to ear that it work on your side. It mean that there is a light at the end of the tunnel...Hope it is not a train.
Yes, I did try the demo script file, but no luck yet. I will re look and retry again.
Martin
Yes, I did try the demo script file, but no luck yet. I will re look and retry again.
Martin
- Dave Masalov
- Posts: 1712
- Joined: 16 Apr 2010
- Has thanked: 51 times
- Been thanked: 489 times
Re: Excel Link.. Send data to Excel /Reactivating an old pro
Martin,Dave, good to ear that it work on your side. It mean that there is a light at the end of the tunnel...Hope it is not a train.
Yes, I did try the demo script file, but no luck yet. I will re look and retry again.
Martin
We can help you to setup the demo file as described in my previous post. Please come to our Live Chat Mon-Fri from 6:30 AM to 11 AM EST: http://messenger.providesupport.com/mes ... pport.html
Re: Excel Link.. Send data to Excel /Reactivating an old pro [SOLVED]
Dave, I did chat with Roman at your custumer service. They seem to have found the problem
For whatever reason, the dll file had to be renamed to Elexcel3.dll. Roman told me that your engeneer will investigate why!
Will work with it and let you know.
I'm more than happy to see that working finally.
Martin
For whatever reason, the dll file had to be renamed to Elexcel3.dll. Roman told me that your engeneer will investigate why!
Will work with it and let you know.
I'm more than happy to see that working finally.
Martin
Re: Excel Link.. Send data to Excel /Reactivating an old pro
Hello Young56. As mentionned, problem as been resolved by renaming the dll fileHi,
Any news about this issue ?
Best regards.
Do you have a specific problem?
Martin
Re: Excel Link.. Send data to Excel /Reactivating an old pro
Martin,
I've just renamed the dll and same problem.
Some times i have the error message 50 sometimes not !!!!!!!
Did you you find an easy way for using mc with excel ?
Best regards.
I've just renamed the dll and same problem.
Some times i have the error message 50 sometimes not !!!!!!!
Did you you find an easy way for using mc with excel ?
Best regards.
Re: Excel Link.. Send data to Excel /Reactivating an old pro
Please post your code sectionMartin,
I've just renamed the dll and same problem.
Some times i have the error message 50 sometimes not !!!!!!!
Did you you find an easy way for using mc with excel ?
Best regards.
- Did you have the correct "address" of your Excel file EX:" C:myExcelfile\Excelfile.Xls"
- Is your Excel file is already open
- The dll work in single instance only meaining
You cant' open another Excel file unless it is opened under the same instance (File Open from the opened file)
- When you close your Excel file, the link from MC to Excel is not killed and Excel is still opend
in background. The easiest way to resolve that is to use Ctrl Alt Del and from the windows menu, kill any Excel instance that is still open
That should resolve your problem
Martin
Re: Excel Link.. Send data to Excel /Reactivating an old pro
I use the demo files.
Please, have a look to the screenshot.
Please, have a look to the screenshot.
- Attachments
-
- ELEexcel.jpg
- (311.51 KiB) Downloaded 1209 times
Re: Excel Link.. Send data to Excel /Reactivating an old pro
Did you succeed once to send data to Excel?
If not, then maybe your Excel sheet is not at the proper link address "C:\...\ExcelFile.Xlsm"
- If you did succeed then probably that you have more than one Excel instance opened
Do Ctrl Alt Del.. You will get the Windows Task Manager. Look under the Process and see if more then one Excel is listed
- Kill any Excel that is present, then reopened your Excel file
Once Excel open, Remove your in MC, remove your indicator ( the one with EleXcel.dll) and re-install it
- If this those not resolve your problem, I would suggest that you contact the technical support using the chat function. They are very efficient.
Martin
If not, then maybe your Excel sheet is not at the proper link address "C:\...\ExcelFile.Xlsm"
- If you did succeed then probably that you have more than one Excel instance opened
Do Ctrl Alt Del.. You will get the Windows Task Manager. Look under the Process and see if more then one Excel is listed
- Kill any Excel that is present, then reopened your Excel file
Once Excel open, Remove your in MC, remove your indicator ( the one with EleXcel.dll) and re-install it
- If this those not resolve your problem, I would suggest that you contact the technical support using the chat function. They are very efficient.
Martin
- Attachments
-
- Excel oneInstance.png
- (81.92 KiB) Downloaded 1188 times
- TJ
- Posts: 7751
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1033 times
- Been thanked: 2228 times
Re: Excel Link.. Send data to Excel /Reactivating an old pro
Did you reboot the computer?Martin,
I've just renamed the dll and same problem.
Some times i have the error message 50 sometimes not !!!!!!!
Did you you find an easy way for using mc with excel ?
Best regards.
Re: Excel Link.. Send data to Excel /Reactivating an old pro
MC not reliable ?????Thanks MArtin,
I think all is right on my pc. I'm going to contact the MC support. It isn't the first time, i have too many problem, MC isn't reliable.
Only problem that I may have is when using tick chart or to many indicator in use on a low resolution. I'm not there to defend them, just i don't have any reliability problem with MC.
Contacting them is really the best advise..
Good luck
MT
Re: Excel Link.. Send data to Excel /Reactivating an old pro
You're lucky Martin.
I've never been able to send order to IB without problem (autotrade). I have to send my order every day with IBOSA.
However, the support is the greatest and the best i know. Actually, Henry is trying to solve my problem but it seems it's very difficult to him too.
I've never been able to send order to IB without problem (autotrade). I have to send my order every day with IBOSA.
However, the support is the greatest and the best i know. Actually, Henry is trying to solve my problem but it seems it's very difficult to him too.