Advice needed re:data linkage between separate workbooks

  • Thread starter Thread starter syswizard
  • Start date Start date
S

syswizard

I'm looking for a recommendation that would indicate the most
efficient techique for having two workbooks share data on a realtime
basis. One workbook (#1) would be collecting data in realtime using an
ActiveX component and would run in a separate Excel instance. The
other workbook running in a separate Excel instance would need to
fetch this data every minute on a timer. The data would be stored in a
worksheet in workbook #1. Approximately 5000 cells would need to be
referenced....mostly numeric.
The options I've derived are as follows:
1) DDE
2) COM Add-in
3) Open read-only via Excel automation
4) Open read-only using standard workbook open
5) DAO query

Any comments ?
 
Whoops forgot to mention these two as well:
6) ExecuteExcel4Macro technique
7) ADO Query

Anyone have a feel for which has best performance ?
 
Whoops forgot to mention these two as well:
6) ExecuteExcel4Macro technique
7) ADO Query

Anyone have a feel for which has best performance ?
Click to expand...

bump.....
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COM addin won't connect when workbook opened via another workbookfrom another instance 3
Excel is removing Macros from workbook 3
Macro that opens a separate workbook to a specified worksheet whenthe active workbook is right mouse 8
Help/Advice Required 3
Separate code from workbook?! 2
Custom Document Properties in Word documents and Excel workbooks 13
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook 6
Switch to Excel workbook in a separate instance of Excel 3

Back
Top