Can't you just do a CopyPasteSpecial xlValues ?

NickHK

"T G" wrote in message
...
I have a DLL that uses Microsoft Excel C API to modify data in Excel
documents. It's an old DLL developed 6-7 years ago that needs to get a few
fixes. It compiles in Visual C++ 6.

I have Excel documents where the cells have formulas getting values that
the
user can see. I need to build a function in my DLL that replaces all
formulas
with the actual values.

Can anyone give me a hint on what functions to use?

I would also appreciate if someone has links to documentation on how
functions like Excel, Excel4, xlcWorkbookSelect, xlCoerce, xlFree,
xlfEvaluate, etc works as it seems like all help on MSDN have disappeared.

Thanks in advance /T