C / C++ / MFC

POSITION posTemplate = theApp.GetFirstDocTemplatePosition();
while (posTemplate)
{
    CDocTemplate * pTemplate = theApp.GetNextDocTemplate(posTemplate);

    POSITION posDocument = pTemplate->GetFirstDocPosition();
    while (posDocument)
    {
        CDocument * pDocument = pTemplate->GetNextDoc(posDocument);

        POSITION posView = pDocument->GetFirstViewPosition();
        if (posView)
        {
            CView * pView = (CSpecExView *)pSpecExDoc->GetNextView(posView);
            CFrameWnd * pChildFrame = pView->GetParentFrame();
        }
    }
}

_Application    app;
Workbooks       books;
_Workbook       book;
Worksheets      sheets;
_Worksheet      sheet;
Range           range;
COleVariant     vtOptional((long) DISP_E_PARAMNOTFOUND, VT_ERROR),
                vtTrue((short) TRUE),
                vtFalse((short) FALSE);
CString         strText;


if (app.CreateDispatch("Excel.Application") == TRUE)
{
    app.SetVisible(TRUE);

    books = app.GetWorkbooks();

    book = books.Add(vtOptional);

    sheets = book.GetSheets();

    sheet = sheets.GetItem(COleVariant((short) 1));

    range = sheet.GetRange(COleVariant("A1"), COleVariant("A1"));
    m_ebCellA1.GetWindowText(strText);
    range.SetValue(COleVariant(strText));

    range = sheet.GetRange(COleVariant("A2"), COleVariant("A2"));
    m_ebCellA2.GetWindowText(strText);
    range.SetValue(COleVariant(strText));

    range = sheet.GetRange(COleVariant("A4"), COleVariant("A4"));
    range.SetFormula(COleVariant("=A1 + A2"));
}

_Application    app;    
Workbooks       books;    
_Workbook       book;    
Worksheets      sheets;    
_Worksheet      sheet;    
Range           range;