Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default C Add-In clashes with VBA?

I am trying to write an Add-In XLL in C that calls functions from the
Analysis ToolPack as user-defined functions, for example

Excel(xlUDF, &xRes, 5, TempStr("COUPPCD"),
TempNum(settle), TempNum(maturity), TempNum(freq),
TempNum(basis));

When macros are disabled, things seem to work fine. However if the
spreadsheet contains enabled VBA functions using the Analysis
ToolPack, things go wild. The first invocation of a ToolPack function
from the C Add-In works fine, but the second time the xRes XLOPER has
the xltype field set to xltypeBool instead of xltypeNum, even though
the Exel function itself returns xlretSuccess.
Any ideas about what's happening?
Thanks

Anton Kryukov
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to find time clashes using excel Jack Excel Worksheet Functions 6 December 11th 08 10:12 AM
excel application clashes oldLearner57 Excel Discussion (Misc queries) 3 October 26th 08 04:38 AM


All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"