Recording scripting macros is a feature pretty specific to the specific enviornment for which the macro is being recorded. (as far as I know). So recording an excel will generate excel specific code. I dont know if the tool is generic enough to generate code for just any activex server out there. You might refer to the documentation that comes with Excel to see what kind of limitations their macro recording capabilities have. The only time I've used this is to automate tasks in Excel (or any other packahe that supports macro recording).
But I'm sure you can write VBA code yourself for controlling the activex server that you create. And that run that VBA code via the Excel automation interface. or write a vb script file, and run the script via command line using cscript, which uses te Windows Scripting Host. Check out the following link for more information about WSH
http://www.microsoft.com/technet/scriptcenter/guide/sas_wsh_qlcc.mspx
Bilal Durrani
NI