HiI am in the process of automating my simulations in Murex. Currently I record macros which generate the xml files which i trigger at a certain time everyday. If i need to make any changes in the nature of simulation (for example change the bump size of curve from +10 bps to -10bps), I modify the xml file for that change and run it. I want to however make the one time effort to develop a neat interface to be able to do these modifications from excel such that the xml file gets created automatically for me to run the script.Question1) Is it better to do this using VBA's Microsoft Scripting Runtimeor2) Using C++ (i do not know how to create xml files through C++ yet though - is it worth the effort to learn it and do it through C++?)regards

oops, dbl

Quote2) Using C++ (i do not know how to create xml files through C++ yet though - is it worth the effort to learn it and do it through C++?)It's possible in C++ using MS drivers. I have a discussion in my 2004 book.But personally I think using C# is much much easier, especially since we can use Reflection API (meta stuff). You could use some Event/Delegate to trigger generation of XML file instead of manual editing?hope this helps.

You can add Microsoft XML in the references of your VBA project just like you do it with Scripting Runtime.M.