Can I use Excel_KeepSingleInstance with other Excel applications and manage multiple instances?

August 8, 2011 admin 2 comments

Excel_KeepSingleInstance is an Excel Add-In that can be used with any other applications for Excel.

Excel_KeepSingleInstance helps prevent the Excel application from opening multiple instances of itself. Often times when users click on a workbook they do not intend to open a secondary instance of Excel, but it can happen. And this can cause problems with DLLs that interface with Excel.

Excel_KeepSingleInstance does not prevent you from opening multiple instances though. You can open multiple instances of Excel if you specifically do so, by re-launching the Excel executable. And in such cases, if you are not using the XLInputs solution, you will likely have trouble with DLLs that commonly interface with a single Excel instance only.

XLInputs has the advantage of interfacing with multiple instances of Excel. More importantly, it has the advantage of efficiently interfacing with cells relative to indentifying text in your spreadsheets. XLInputs comes with over a 100 functions, and avoids cumbersome EasyLanguage and PowerLanguage code configurations such as to initialize Excel workbooks. By design, XLInputs functions can be used directly in input lines of TradeStation and MultiCharts studies and strategies.

XLInputs none

#1 | Written by HaeRim Lee about 13 years ago.

My core question is not clearly answered yet.

Can Excel_KeepSingleInstance allow me to use ELExcel.dll with MultiCharts along with multiple Excel workbooks?
For example, I can open 3 workbooks at the same time communicating with MC via ELExcel.dll using Excel_KeepSingleInstance?

Best would be to show via video capture.

thx
#2 | Written by admin about 13 years ago.

Here are clarification statements:
• Excel_KeepSingleInstance is an Add-In to help keep a single instance of Excel.
• You can use Excel_KeepSingleInstance with the ELExcel.dll. It helps avoid Excel instance problems.
• Note: You can have multiple Workbooks in a single instance of Excel. Workbooks can also be in multiple instances, which would be undesirable for the free ELExcel.dll of TradeStation.
• If target Workbooks are in different instances of Excel, the free ELExcel.dll of TradeStation will not be able to find Workbooks in secondary instances.

On the other hand:
• XLInputs can find workbooks in multiple Excel instances.
• XLInputs efficiently interacts with cells located by identifying text.
• XLInputs comes with over 100 functions, can read/write comments, trigger recalculations, save workbooks, etc.
• XLInputs is designed to be easy to use.
• XLInputs can also be used from outside TradeStation, as demonstrated by the Test-XLInputs.exe installed with XLInputs.

!QCL Solutions

Can I use Excel_KeepSingleInstance with other Excel applications and manage multiple instances?

Leave a Comment