OleVariant in Function

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

OleVariant in Function
Davide Crudo

Posts: 23
Joined: 2005-05-09
Hello Dimitri,

I'm having some troubles converting Strings to OleVariant. How Can I use simply String as variable and not OleVariant in the excel plug-in?

The issue I have is that probably sometimes the Variable is not recognized as a string and the function fails.

I've checked in the "Type Library" but there is not String Choice.

Thank you in advance!


Posted 14 Jun, 2005 09:49:08 Top
Dmitry Kostochko

Add-in Express team

Posts: 2741
Joined: 2004-04-05
Hi Davide,

You can try to use BSTR instead of VARIANT. Also I would recommend you to look at the QDemo\XLAutomationAddIn demo project.

Posted 14 Jun, 2005 10:00:11 Top