ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Replace function in Excel with MFC (https://www.excelbanter.com/excel-programming/299238-replace-function-excel-mfc.html)

Thomas Giessner

Replace function in Excel with MFC
 
Hello,
I tried to use the replace function for Excel like this:

t_sTmp.Format("1/%d",m_iScale);
oRange.Replace(COleVariant("string to find"),//const VARIANT& What
COleVariant(t_sTmp),//const VARIANT& Replacement
COleVariant((short)1),//const VARIANT& LookAt
COleVariant((short)1),//const VARIANT& SearchOrder
COleVariant((short)TRUE),//const VARIANT& MatchCase
COleVariant((short)FALSE),//const VARIANT& MatchByte
COleVariant((short)FALSE),//const VARIANT& MatchControlCharacters
COleVariant((short)FALSE),//const VARIANT& MatchDiacritics
COleVariant((short)FALSE),//const VARIANT& MatchKashida
COleVariant((short)FALSE));//const VARIANT& MatchAlefHamza

But if I run the program I get an error: Unzulässige Parameteranzahl
(incorrect amount of parameter).
Whats wrong?
Thanks for helping
Thomas


All times are GMT +1. The time now is 01:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com