C / C++ / MFC

<br />
HOWTO: Use MFC to Automate Excel 97 and Navigate Worksheets<br />
Article ID: Q178782  

_Application app;  // app is an _Application object.
      _Workbook book;
      _Worksheet sheet;
      Workbooks books;
      Worksheets sheets;
      Range range;
      char buf[1024];
      LPDISPATCH lpDisp; // IDispatch *; pointer reused many times.
      long count; // Count of the number of worksheets.
      int i;



      // Common OLE variants. These are easy variants to use for
      // calling arguments.
      COleVariant
                 covTrue((short)TRUE),
                 covFalse((short)FALSE),
                 covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);

      // Start Excel and get Application object.
      if(!app.CreateDispatch("Excel.Application"))
      {
       AfxMessageBox("Couldn't CreateDispatch on Excel");
       return;
      }

      // Set visible.
      app.SetVisible(TRUE);

      // Get Workbooks collection.
      lpDisp = app.GetWorkbooks();  // Get an IDispatch pointer
      ASSERT(lpDisp);               // or fail.
      books.AttachDispatch( lpDisp );  // Attach the IDispatch pointer
                                       // to the books object.

      // Open a workbook.
      lpDisp = books.Open("C:\\My Docs\\Test",
                     covOptional, covOptional, covOptional, covOptional,
                     covOptional, covOptional, covOptional, covOptional,
                     covOptional, covOptional, covOptional, covOptional
                     );
      ASSERT(lpDisp);  // It worked!

extern CString g_strServerIP;

// dialog.cpp
CString sNewIP = "255.255.255.255"
g_strServerIP = sNewIP;