RTD in excel

Add-in Express™ Support Service
That's what is more important than anything else

RTD in excel
 
Paul Willard




Posts: 8
Joined: 2017-11-09
hey Andrei, that sounds good to me.. do you think you can reply to my email with a working sample vb.net project doing with what you recommend?
Posted 17 Nov, 2017 12:13:46 Top
Andrei Smolin


Add-in Express team


Posts: 14592
Joined: 2006-05-11
Hello Paul,

Check the VB project described at https://www.add-in-express.com/creating-addins-blog/2011/10/11/invoke-excel-addin-xll/.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 20 Nov, 2017 06:11:46 Top
Paul Willard




Posts: 8
Joined: 2017-11-09
so how exactly do I update cells fast?
Posted 20 Nov, 2017 19:32:30 Top
Andrei Smolin


Add-in Express team


Posts: 14592
Joined: 2006-05-11
Paul,

If you follow that project, there's an event handler of the OnSendMessage event on the add-in module. In that event handler, the message (which is an integer greater than 1024) is filtered out and a pane is shown. In your real project, you should send a similar message and modify the OnSendMessage event handler so that it puts the data into the cells.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 21 Nov, 2017 03:42:36 Top
Paul Willard




Posts: 8
Joined: 2017-11-09
quick questions..
from a COM XLL addin how do I get this to work

Dim sheet As Excel._Worksheet = CType(ExcelApp.ActiveSheet, Excel.Worksheet)


Error BC30469 Reference to a non-shared member requires an object reference. MyXLLAddin1
Posted 21 Nov, 2017 15:17:31 Top
Andrei Smolin


Add-in Express team


Posts: 14592
Joined: 2006-05-11
Hello Paul,

XLL add-in doesn't live well with the Excel object model. Unfortunately, the page at https://support.microsoft.com/en-us/help/301443 that explained this doesn't exist any longer and I don't know what this could mean. I assume that this restriction is still in-place.

You need to replace ExcelApp in your code with _Module.ExcelApp.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 22 Nov, 2017 02:15:49 Top