Calling Macros from Other Exe's

[maneesh]

I want to call a macro written in VBA
from a VC++ exe. The exe would pass an int array to the macro and the macro would read the array and fill a row in the excel sheet

Please let me know whether i could do this or is there and optimized way to to this

Please do provide me the Codes

 

[Colo]

Hi!
Please have a look at 'Open ANY Program' on following saite.
http://xcelfiles.homestead.com/Excel01.html

 

[Colo]

Oh sorry, I've misunderstood your Q.
Win32SDK yes? Here is a code execute external application and wait untill it will be finished.
So, execute excel itself from VisualC++, and why don't you write Auto_open code in the module of excel?
I have no idea except that...

<pre>
BOOL ExecuteAndWait(const CString &appPath, const CString &cmdLine)
{

CString cmdLine;
cmdLine.Format("%s %s",appPath,cmdLine);

char* commndLine=cmdLine.GetBuffer(cmdLine.GetLength());

STARTUPINFO infoStart;
PROCESS_INFORMATION infoProcess;

memset(&infoStart,0,sizeof(infoStart));
infoStart.cb=sizeof(STARTUPINFO);

BOOL res=CreateProcess(NULL,commndLine,NULL,NULL,FALSE,DETACHED_PROCESS,
NULL,NULL,&infoStart,&infoProcess);

if(res)
::WaitForSingleObject(infoProcess.hThread,INFINITE);
else
return FALSE;

return TRUE;

}
</pre>