how to read the formula values without quote?

[krish]

hi all,

If I create a formula say, =mytest("aa","bb")
when I read activecell.formula returns =mytest("aa","bb") . Is there anyway I can read the values without quotes?

I'm trying this in c# and I split the formula after removing the func name. ie.
("aa","bb"). the result array of the split has "\aa\".

I don't need "\" this part and is there anyway I can get the values without quotes?

thanks

 

[Norie]

Are you sure they actually have quotes?

Also are you sure this is an Excel/VBA problem and not a C# one?

 

[krish]

sorry for the delay( was on vacation). this is a c# issue and I've resolved it.