Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2008

Tip: Looking for answers? Try searching our database.

Excel User Defined function calling RTD

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Siva - 27 Mar 2008 19:42 GMT
Hi,
I have an Excel user defined function (UDF) lets say udf1 implemented in an
XLL.

udf1(X) // Excel UDF defined in an XLL taking 1 argument

This UDF calls a RTD server using the RTD function with 3 arguments

RTD("RTDServerName", "", int X, int arg2, int arg3)

I have an Excel sheet saved with this UDF.

Now lets say the implementation of the RTD server has changed and the type
of arg2 changed incompatibly.

Eg: RTD("RTDServerName", "", int X, String arg2, int arg3) // Arg 2 changed
from int -> String

I also changed the XLL so that the UDF calls the new RTD function correctly.
But somehow the Excel sheet that was originally saved seems to remember that
the RTD was called with an int argument and the RTD server seems to be
getting called with the integer argument. The new RTD server does not like
the argument and it fails the request.

Is this normal? Is this RTD call caching some feature of Excel that can be
disabled?

Thanks
Siva - 31 Mar 2008 16:03 GMT
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.