Search results

  1. A

    Can you call macros in one spreadsheet from another workbook using C#/.Net?

    REALLY appreciate your help Schizo ..... have a great evening.
  2. A

    Can you call macros in one spreadsheet from another workbook using C#/.Net?

    Thanks Schizo for your help it is very much appreciated. I am trying find a way of calling the macro from within another worksheet using .net. I will persist and report back - thanks everyone.
  3. A

    Can you call macros in one spreadsheet from another workbook using C#/.Net?

    That article is how to reference cells from one worksheet to another. I am attempting (and so far failing) to call a macro to run in worksheet A from a master in worksheet B. If you could point me in the right direction I would be indebted.
  4. A

    Can you call macros in one spreadsheet from another workbook using C#/.Net?

    Thanks so much - let me take a look at that ....
  5. A

    Can you call macros in one spreadsheet from another workbook using C#/.Net?

    Hi, I am really sorry for not being clearer. Thank you for trying to understand. To be honest I am a trader not a programmer so I apologize for the ambiguity. I have two separate excel spreadsheets that run at the same time. They run continuously during market hours monitoring the markets. One...
  6. A

    Can you call macros in one spreadsheet from another workbook using C#/.Net?

    For some years I have been running two ActiveX Excel spreadsheets in VBA simultaneously and have been able to run one spreadsheet as a kind of slave from the other using the "Application.Run" function eg. Application.Run "OtherWorkbook.xls!Sheet1.RunMacro" However just recently I have needed...
  7. A

    Connecting IB's ActiveX Excel API to TWS

    After a LOT of messing around it seems that I needed to use a new Client ID. Thank you for taking the time to read ... all the best
  8. A

    Connecting IB's ActiveX Excel API to TWS

    Hi, I need help in connecting IB's ActiveX Excel API to TWS - any help would be GREATLY appreciated! I used the old ActiveX API for ages but have just downloaded the new one and cannot get it to connect to TWS. The port is still 7496 and the Client ID and Log levels remain unchanged (0 & 5) I...
Back
Top