Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace all function - excel 2003 | Excel Worksheet Functions | |||
My Find and Replace function in Excel is not working? | Excel Worksheet Functions | |||
Using REPLACE function in Excel | Excel Discussion (Misc queries) | |||
Replace function not working properly in Excel 2000 SP3 | Excel Worksheet Functions | |||
help automating the Replace function in Excel | Excel Programming |