View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
j23 j23 is offline
external usenet poster
 
Posts: 2
Default Excel events - please help!!!!

How to catch excel events form C++ program? I have no idea?

Here is my code, I can connect to excel, create new workbook, but how to
connect my handler to Excel event?

HRESULT BeforeSave (VARIANT_BOOL SaveAsUI, VARIANT_BOOL *Cancel)
{
MessageBox(NULL, "Hello fro beforesave", "zzz", MB_OK);
*Cancel = false;
return 0;
}

{
_ApplicationPtr pXL;
try {
pXL.CreateInstance(L"Excel.Application");
pXL-Visible = VARIANT_TRUE;

pXL-EnableEvents = true;
WorkbooksPtr pBooks = pXL-Workbooks;
_WorkbookPtr pBook = pBooks-Add((long)xlWorksheet);

?????????
}