Rtd wrapped in Xll executes before Rtd is started

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

Rtd wrapped in Xll executes before Rtd is started
 
Kiru Marimuthu


Guest


Hi

We got Rtd wrapped in Xll function, it works fine when it is inserted. But if the excel is saved with the formula and then reopen it. The Xll returns "#VALUE!".

It looks like the Rtd is not started by the time Xll tries to execute the formula.

Any idea how to delay Xll until Rtd is up and running or re-execute again when Rtd is ready?

Thanks
Kiru
Posted 04 Apr, 2018 11:46:31 Top
Andrei Smolin


Add-in Express team


Posts: 18821
 Joined: 2006-05-11
Hello Kiru,

Kiru Marimuthu writes:
It looks like the Rtd is not started by the time Xll tries to execute the formula.


To find this, you can add a number of debug messages to your code; use System.Diagnostics.Debug.WriteLine(). If the add-in is built in the Debug configuration, you collect the messages at run time using DebugView (see http://technet.microsoft.com/en-us/sysinternals/bb896647.aspx). If you debug the code using F5, the messages are shown in the Immediate window.


Andrei Smolin
Add-in Express Team Leader
Posted 05 Apr, 2018 06:21:21 Top
Kiru Marimuthu


Guest


Hi Andrei

I should have been clear in my last post. I used logging trace and found Rtd is not started but Xll returns "#VALUE!".

I have Rtd interval to 0, even if I change it to 3000 or 6000 still Rtd is not initialized.

Thanks
Kiru
Posted 06 Apr, 2018 03:36:30 Top
Andrei Smolin


Add-in Express team


Posts: 18821
 Joined: 2006-05-11
Hello Kiru,

Is the issue reproducible using the sample project described in https://www.add-in-express.com/creating-addins-blog/2010/03/24/addin-xll-rtd-one-assembly/?


Andrei Smolin
Add-in Express Team Leader
Posted 06 Apr, 2018 03:49:50 Top
Andrei Smolin


Add-in Express team


Posts: 18821
 Joined: 2006-05-11
If yes, please specify the Office build that you use.


Andrei Smolin
Add-in Express Team Leader
Posted 06 Apr, 2018 03:50:29 Top