Com Automation latest library for working with ms excel in mfc vosual studio vc++, can anyone suggest from where i get this.

Below is my code but note working same header footer is set to all page, please suggest best solution for this. oWorkSheets2007 = oWorkBook2007.GetWorksheets(); oWorkSheet2007 = oWorkSheets2007.GetItem(COleVariant((short)sheetNum)); XLS2007::Window owindObj = oApp2007.GetActiveWindow(); XLS2007::Pages oPages = owindObj.GetPanes(); oPageSetup = oWorkSheet2007.GetPageSetup(); oPages = oPageSetup.GetPages(); long a = oPages.GetCount(); int l=0; for( l=l+1;l<=a;l++) { oPage= oPages.GetItem(COleVariant((short)l)); oPageSetup = oWorkSheet2007.GetPageSetup(); oPageSetup.SetPrintErrors(1); oPageSetup.SetAlignMarginsHeaderFooter(HFI.bAlignWithMargins); oPageSetup.SetScaleWithDocHeaderFooter(HFI.bScaleWithDoc); oPageSetup.SetCenterHeader(LPCTSTR(HFI.FirstCentreHeader)); oPageSetup.SetCenterFooter(LPCTSTR(HFI.FirstCentreFooter)); oPageSetup.SetLeftHeader(LPCTSTR(HFI.FirstLeftHeader)); oPageSetup.SetLeftFooter(LPCTSTR(HFI.FirstLeftFooter)); oPageSetup.SetRightHeader(LPCTSTR (HFI.FirstRightHeader)); oPageSetup.SetRightFooter(LPCTSTR(HFI.FirstRightFooter)); oPageSetup.SetCenterHeader(LPCTSTR(HFI.OddCentreHeader)); oPageSetup.SetCenterFooter(LPCTSTR(HFI.OddCentreFooter)); oPageSetup.SetLeftHeader(LPCTSTR(HFI.OddLeftHeader)); oPageSetup.SetLeftFooter(LPCTSTR(HFI.OddLeftFooter)); oPageSetup.SetRightHeader(LPCTSTR(HFI.OddRightHeader)); oPageSetup.SetRightFooter(LPCTSTR(HFI.OddRightFooter));