C / C++ / MFC

range = oSheet.get_Range("A1", Missing.Value);
range = range.get_End(Excel.XlDirection.xlDown).get_Offset(1, 0);

range.EntireRow.Insert(Excel.XlInsertShiftDirection.xlShiftDown, Excel.XlInsertFormatOrigin.xlFormatFromLeftOrAbove);

// Move range to the above row, then copy it to the newly inserted row
range = range.EntireRow.get_Offset(-1, 0);
range.get_Offset(-1, 0).Copy(range);
range.Cells.get_Offset(0, 0).set_Value(Missing.Value, "ASDF");

char Buf[20]={0};
AnsiString DataString;
...
/* I then copy two zeros in front of it */
strcpy(coidBuf, "00");
...
/* I then add the value to the buffer */
strcat(Buf, DataString.c_str());
...

---

The only programmers that are better that C programmers are those who code in 1's and 0's

Programm3r
My Blog: ^_^

void CMyDialog::OnSelFontButton()
{
  CFontDialog dlg;
  if (dlg.DoModal() == IDOK)
  {
    CString strFace = dlg.GetFaceName();
    int iFontSize = dlg.GetFontSize();
    LOGFONT lf = {0};
    lf.lfWeight = iFontSize;
    _tcscpy(lf.lfFaceName,  strFace);
    CFont cfont;
    cfont.CreateIndirectFont(&lf);

    CDC *pdc = m_MYEDITCTL.GetDC();
    pdc->SelectObject(&cfont);
    m_MYEDITCTL.ReleaseDC(pdc);
  }
}