Hi

I have a C program that prints to a text file a VB macro that does excel
automation. To run this macro, I need to start an excel app (i.e by going to
START-RUN--EXCEL ) and then click on TOOLS-MACRO-CREATE NEW MACRO, supply
a name and then copy the contents of the text file (which is output of the
..exe ) and then run the macro. The macro now, operates on a excel file and
saves and closes it. " All this is working fine. "

Is there a way to automtate this task, so no user intervention is required.
Ideally, what I want is:
(1) Launch my C based program , ie. Execute the application
(2) This will now, Create the macro and also RUN it.

My OBJECTIVE In short is:
How do I run a macro from C program ?

Preferably, I would not like to use C# or .NET. my application is failry
simple; and also, I am not not a C# or .NET developer. I have seen some
articles on MSDN but they are not really helpful.
If someone can send me or tell me how to launch a macro from C, that would
be great!
Please bear in mind that I have "NO" knowledge of VB or C#. Some MSDN
examples declare vairalbes that I dont understand at all.